Enabling ARM on DB2

For best results, use the Transaction Tracking JDBC feature from ITCAM for Application Diagnostics (was ITCAM for WebSphere) rather than ARM to track DB2.

By using ITCAM for Application Diagnostics (was ITCAM for WebSphere) V6.1 FP4 or higher you can track indicative response times for DB2.

Only registered JDBC data source calls are supported for WebSphere to DB2 transactions. Direct DB2 database access, such as Java code directly communicating with DB2 is not supported.

DB2® only issues ARM calls for sub-transactions when they originate from WebSphere®. Therefore you can only get ARM data from DB2 for WebSphere transactions, and then only if WebSphere is configured to send the ARM correlator to DB2. See Enabling ARM on WebSphere for further information about configuring WebSphere to issue ARM calls and pass its correlator to DB2.

DB2 registers with ARM if it finds libarm4.dll in its library path. In order to issue start or stop calls for transactions, DB2 requires a correlator to be passed in with the JDBC connection (configured in WebSphere). To configure the DB2 library path, run the following command from within the DB2 environment:

db2set DB2LIBPATH=libarm4.dll directory location

where libarm4.dll directory location is:

AIX - $CANDLE_HOME/tmaitm6/aix533/lib/
HPUX - $CANDLE_HOME/hp11/tu/tusupport/:$CANDLE_HOME/hp11/tu/lib/:$CANDLE_HOME/tmaitm6/hp11/lib/
Linux - $CANDLE_HOME/li6263/tu/tusupport:$CANDLE_HOME/li6263/tu/lib/:$CANDLE_HOME/tmaitm6/li6263/lib
Solaris - $CANDLE_HOME/sol293/tu/tusupport/:$CANDLE_HOME/sol293/tu/lib/:$CANDLE_HOME/tmaitm6/sol283/lib/

Note: On Windows 64-bit systems also add the value of DB2LIBPATH to the system Path environment variable.

Ensure that you restart the computer.

$CANDLE_HOME defaults to c:\ibm\itm for Windows systems and /opt/IBM/ITM/ for UNIX systems.

Note: On Windows systems, IBM Tivoli Monitoring automatically includes c:\ibm\itm\tmaitm6\ in the system path.

Note: If you use 64-bit ARM with 64-bit DB2, you must manually rename the 64-bit library libarm4_64.a to libarm4.a to ensure libarm4.a becomes a 64-bit library.