Monday, March 10, 2008

ITM 6.1 Annoyance: Testing the SPA database connection for DB2 on AIX

When you configure the ITM 6.1 Summarization and Pruning Agent, you have to add several files to the JAR file list. DB2 requires db2jcc.jar, db2java.zip, and db2jcc_license_cu.jar from the DB2 installation java directory. Using the SPA configuration GUI, you navigate to the java directory where you installed DB2, and select the files then add them to the list. But when you click on the test connection button, a long winded dialog describing how the JDBC object requires a license jar, specifically the one included in your list!

The way to solve this problem is to set the CLASSPATH environment variable and export it before running itmcmd manage to start the GUI and configure the SPA:
CLASSPATH=/DB2/java/db2jcc.jar:/DB2/java/db2java.zip:/DB2/java/db2jcc_license_cu.jar
export CLASSPATH
itmcmd manage

No comments: