DB2 probe error - probe has to be started for connection test
Document ID : KB000117130
Last Modified Date : 08/10/2018
 Show Technical Document Details
Issue:
db2 probe error in IM - probe has to be started for connection test
Environment:
- UIM 8.5.1
- dbs probe v4.11
Cause:
- probe configuration
Resolution:
The db2 probe configuration requires information from the DB2 administrator for the correct configuration parameters.

You MUST set the DB2INSTANCE on the controller as below.

   <environment>
   LD_LIBRARY_PATH = /IBM/DB2/sqllib/lib64/
   DB2INSTANCE = <DEFAULTINSTANCE>
   </environment>

If there is no DB2 'default' instance please check out this link:

How to configure the db2 probe when there is no default DB2 instance

   https://comm.support.ca.com/kb/how-to-configure-the-db2-probe-when-there-is-no-default-db2-instance/kb000033893

Also,check the environment variables as specified and use the appropriate client version and bit, e.g., 64-bit client for 64-bit server if probe is running remotely versus locally.

The probe not starting and throwing that error on a Windows host is most likely due to the probe not finding the db2app.dll file usually located in the BIN folder in the run-time client folder.

Ensure that the correct path to the DB2 run-time client is in the PATH environment variable in the controller environment. Usually, the paths that needs to be added are:

   C:\PROGRA~1\IBM\SQLLIB\BIN
   C:\PROGRA~1\IBM\SQLLIB\FUNCTION

After setting this, the probe should be able to be started by the controller.

****Note - On Windows platform after deploying DB2 probe and setting environmental variables, the Robot Watcher service must be restarted in order to initialize DB2 environment variables.

The LD_LIBRARY_PATH to where the db2 probe is deployed is added in the controller probe > Environment tab Instructions

If Linux/UNIX OS:
Example of Robot (controller) environment settings:

   <environment>
   LD_LIBRARY_PATH = /opt/IBM/db2/V10.1/fp3/lib64
   LIBPATH = /opt/IBM/db2/V10.1/fp3/lib64
   </environment>

Moreover, the output of the commands './db2_monitor' and 'ldd db2_monitor' ran in the db2 probe directory should not point towards a missing library:

   './db2_monitor: error while loading shared libraries: libdb2.so.1: cannot open shared object file: No such file or directory'

This library libdb2.so.1 is located away from the other libraries. Therefore, the environment variable within the Robot controller needs to point to this location for the probe to be able to Activate.

Restart the robot after adding the environment variables.

To test, execute the db2 connection test.

You may also want to reboot and check the probe to make sure it is still operational and you encounter no issues.