Troubleshooting steps for ITPA when PA Agent communicates to the Database.

a ) login to DB2 using  su - db2inst1    

b )  db2 connect to WAREHOUS user <dbschema-username> using <dbschema-password >  



 
2. What is the JDBC driver being used in 'WPA and 'S&P  Versus  the ones used in the 'ITPA ?   Are they from DB2 drivers only.

Check the Database level/version.



3. Is this an upgrade from one Database to another .

In other words you were at V9.7 and then upgraded to V10.1  <== ?? "ERRORCODE=-4214, SQLSTATE=280"  leads me to ask this.




a ) Can you enter the hostname when configuring instead of localhost, and try once.
Can you send the snapshot of the WPA, S&P Manage TEMS configuration panels that show the user name and the JDBC credentials, and the ITPA having this driver and the 'Test Connection being successful'.

 



Was the agent.cfg - parameters hand tweaked ? or hand edited or removed /deleted etc.

ITMHOME/<arch>/pa/config/agent.cfg

....
analytic NLT_DELETE_TEMP_FILES=true
# TDW Database Connection
TDW_DB_TYPE=DB2
analytic TDW_DB_TYPE=DB2
analytic TDW_DB_CONN_TYPE=JDBC
analytic TDW_DB_DRIVER=com.ibm.db2.jcc.DB2Driver
analytic TDW_DB_DSN="jdbc:db2://9.118.41.57:50000/WAREHOUS"
analytic TDW_DB_USER=itmuser
analytic TDW_DB_PASSWD={AES256:keyfile:a}j7tKGILZ8xw3myYH3g6sXg==    <========== I'm interested in seeing this.
analytic TDW_DB_SCHEMA=itmuser
analytic SPSS.Home=/opt/IBM/SPSS/StatisticsServer20
analytic SPSS.Enabled=false
analytic TEP_TMSC=ip.pipe:#9.118.41.57
analytic start