Navigate to the DB2 cartridge agent library directory (cd. {fglam location}\agents\DB_DB2\{cartridge version}\lib
Run the connection utility batch file (e.g. db2-connection-test-5.7.5.50-bat.bat or .\db2-connection-test-5.7.5.41-ksh.ksh)
Enter the path location for the Foglight java home when the bin folder is located (e.g. {foglight}\jre)
Users will be presented with the following options.
DB2 Connection Test:
1. DB2 Connection
2. WMI Connection
3. SSH Connection
4. WinShell Connection
5. Exit
Select the option corresponding to the connection being tested.
As examples:
To test an DB2 Database Agent connection, select option 1
- Create a subfolder called "test" in the lib folder with an empty file called 0.txt in the folder.
- Enter the hostname, then press Enter
- Enter the port and press Enter
- Enter the DB Username, and press Enter
- Enter the DB Password, and press Enter
- Enter 1, 2, 3, or 4 for the Authentication type (1 Default, 2 Server, 3, Client, 4 Data Encrypt)
- Enter the DB Code page and press Enter or press Enter to accept the default
- Enter the Query file full path and press Enter or press Enter to accept the default
- Enter a SQL Query and press Enter or press Enter to accept the default
- Enter the Connection Time Out in seconds, and press Enter
To test a WMI connection using the Agent Manager services, select option 2
- Enter the target hostname, then press Enter
- Enter the FglAM hostname, then press Enter
- Enter the Agent name, then press Enter
- Enter the RMI port and press Enter, or press enter to accept the default
- Enter a WMI query to test and press Enter, or press Enter to accept the default query
- Enter a Connection TimeOut value in seconds, then press Enter
To test a WinShell connection using JInterop (this requires Windows registry permissions), select option 3
- Enter the target hostname, then press Enter
- Enter the FglAM hostname, then press Enter
- Enter the Agent name, then press Enter
- Enter the RMI port and press Enter, or press enter to accept the default
- Enter a test script to test and press Enter, or press Enter to accept the default
- Enter a Connection TimeOut value in seconds, then press Enter