Javelin connects fine on one server and not the other Can't connect to DB2 z/OS using Javelin

book

Article ID: 210101

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We have a simple Javelin Flow that works in one environment

021-03-04 14:45:22 - Exception occurred executing query: SQL1159  Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 11.1.0, Process Owner: TDBFG\guralr5
2021-03-04 14:45:22 - Error executing Db2test: SQL1159  Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 11.1.0, Process Owner: TDBFG\guralr5
2021-03-04 14:45:22 - Running Test Case: Flowchart
2021-03-04 14:45:22 - Test Case: Flowchart Execution Complete
Execution complete with error:SQL1159  Initialization error with DB2 .NET Data Provider, reason code 10, tokens 0.0.0, 11.1.0, Process Owner: TDBFG\guralr5 

I checked DLL versions on both. v2.0.800.37 including IBM DLL's in their respective folders.

Cause

The installation location for the DB2 files was different on the two servers.
And the permissions were not the same.
The user did not have permissions to the DB2 directory on the none working machine.

Environment

TDM 4.9.X
Javelin 4.9.x

Component : TDM ACTION SERVICE

Resolution

The is a permissions issue on the server for access to the db2 drivers.

 

Additional Information

We used procemon to monitor the process on both systems.

from the non Working server provide I am seeing the following access denied:

 Line 354: "8:27:07.1814164 AM","Javelin.exe","16892","QueryOpen","C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2systm","ACCESS DENIED","","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 355: "8:27:07.1818485 AM","Javelin.exe","16892","QueryOpen","C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2systm","ACCESS DENIED","","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 355: "8:27:07.1818485 AM","Javelin.exe","16892","QueryOpen","C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2systm","ACCESS DENIED","","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 355: "8:27:07.1818485 AM","Javelin.exe","16892","QueryOpen","C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2systm","ACCESS DENIED","","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 355: "8:27:07.1818485 AM","Javelin.exe","16892","QueryOpen","C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2systm","ACCESS DENIED","","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"

it looks like on the working system the DB2 files are installed on the D dive.

 Line 1216: "8:35:04.2529316 AM","Javelin.exe","1900","ReadFile","D:\ibm\BIN\db2app.dll","SUCCESS","Offset: 8,033,280, Length: 32,768, I/O Flags: Non-cached, Paging I/O, Synchronous Paging I/O, Priority: Normal"
 Line 1217: "8:35:04.2572697 AM","Javelin.exe","1900","ReadFile","D:\ibm\BIN\db2app.dll","SUCCESS","Offset: 8,135,680, Length: 12,288, I/O Flags: Non-cached, Paging I/O, Synchronous Paging I/O, Priority: Normal"
 Line 1218: "8:35:04.2608676 AM","Javelin.exe","1900","ReadFile","D:\ibm\BIN\db2app.dll","SUCCESS","Offset: 7,889,920, Length: 24,576, I/O Flags: Non-cached, Paging I/O, Synchronous Paging I/O, Priority: Normal"
 Line 1219: "8:35:04.3088884 AM","Javelin.exe","1900","ReadFile","D:\ibm\BIN\db2app.dll","SUCCESS","Offset: 988,160, Length: 32,768, I/O Flags: Non-cached, Paging I/O, Synchronous Paging I/O, Priority: Normal"

 

some other errors as well:

  C:\My Documents\My Downloads\LogfileProdCSVOnly\Logfile.CSV (12 hits)
 Line 5598: "8:27:05.5085154 AM","Javelin.exe","16892","QueryOpen","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","SUCCESS","CreationTime: 6/10/2016 8:28:04 AM, LastAccessTime: 5/10/2019 2:44:43 PM, LastWriteTime: 6/10/2016 8:28:04 AM, ChangeTime: 5/10/2019 2:46:23 PM, AllocationSize: 20,131,840, EndOfFile: 20,127,952, FileAttributes: A","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5599: "8:27:05.5091515 AM","Javelin.exe","16892","QueryOpen","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","SUCCESS","CreationTime: 6/10/2016 8:28:04 AM, LastAccessTime: 5/10/2019 2:44:43 PM, LastWriteTime: 6/10/2016 8:28:04 AM, ChangeTime: 5/10/2019 2:46:23 PM, AllocationSize: 20,131,840, EndOfFile: 20,127,952, FileAttributes: A","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5600: "8:27:05.5093955 AM","Javelin.exe","16892","CreateFile","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","SUCCESS","Desired Access: Read Data/List Directory, Execute/Traverse, Synchronize, Disposition: Open, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: n/a, ShareMode: Read, Delete, AllocationSize: n/a, OpenResult: Opened","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5601: "8:27:05.5098271 AM","Javelin.exe","16892","CreateFileMapping","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","FILE LOCKED WITH ONLY READERS","SyncType: SyncTypeCreateSection, PageProtection: ","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5602: "8:27:05.5105017 AM","Javelin.exe","16892","CreateFileMapping","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","SUCCESS","SyncType: SyncTypeOther","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5603: "8:27:05.5107585 AM","Javelin.exe","16892","DeviceIoControl","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","SUCCESS","Control: 0x86968 (Device:0x8 Function:2650 Method: 0)","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5604: "8:27:05.5108508 AM","Javelin.exe","16892","QueryStreamInformationFile","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","SUCCESS","0: ::$DATA","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5605: "8:27:05.5116622 AM","Javelin.exe","16892","DeviceIoControl","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","NOT FOUND","Control: 0x86968 (Device:0x8 Function:2650 Method: 0)","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5606: "8:27:05.5117883 AM","Javelin.exe","16892","Load Image","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","SUCCESS","Image Base: 0x72130000, Image Size: 0x1362000","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5607: "8:27:05.5118457 AM","Javelin.exe","16892","CloseFile","C:\Program Files (x86)\IBM\SQLLIB\BIN\db2app.dll","SUCCESS","","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5995: "8:27:05.6104286 AM","Javelin.exe","16892","QueryOpen","C:\Windows\Microsoft.NET\assembly\GAC_32\IBM.Data.DB2\v4.0_9.7.4.4__7c307b91aa13d208\db2app.dll","NAME NOT FOUND","","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"
 Line 5996: "8:27:05.6105896 AM","Javelin.exe","16892","QueryOpen","C:\Windows\Microsoft.NET\assembly\GAC_32\IBM.Data.DB2\v4.0_9.7.4.4__7c307b91aa13d208\db2app.dll","NAME NOT FOUND","","C:\Program Files (x86)\Grid-Tools\Javelin\Javelin.exe"