Troubleshooting Articles › Debug Security Discipline-DB2 Connection

Debug Security Discipline-DB2 Connection

Symptom:

I get one or more of the following failed-connection messages in the server.log:

• GMT ERROR com.ca.chorus.server.translator.delegator.LazyConnectionInvocationHandler (CA Chorus Application Server, System Threads(1)-8) Unable to initialize connectionorg.jboss.util.NestedSQLException: Unable to get managed connection for chorus-cia-jdbc; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for chorus-cia-jdbc)
• TeiidProcessingException.SECURITY_DM_DB2_D91APTIB_CMGRD1: ETJJB012E Could not connect to DB2 ,SQLState=08001 ,ERRORCODE=-4499. Research the error code and correct the problem. TranslatorException.ETJJB012E Could not connect to DB2 ,SQLState=08001 ,ERRORCODE=-4499. Research the error code and correct the problem.

Solution:

CA Chorus for Security and Compliance Management connects to a DB2 subsystem using JDBC to access the CM or the CIA databases. The following data source XML files define the connection information:

• chorus-cm-jdbc
• chorus-cia-jdbc

After you identify that DB2 subsystem causes the connection problem, use the following procedure to resolve the problem.

Follow these steps:

1. Determine the DB2 subsystem and the system it runs.
2. Log in to the system, and enter SYSVIEW or SDSF.
3. Determine if the subsystem is running by setting the prefix to the DB2 subsystem name.

   Example: View the following active address spaces by using the DA command:

   • D91AIRLM
   • D91AMSTR

     Note: This value is the DB2 Master Address space. You find the DDF messages here.

     The list shows examples of DDF terminating messages:

     18.39.47 STC56790  DSNL007I  !D91A DDF IS ABNORMALLY TERMINATING                             
     

     18.39.49 STC56790  DSNL008I  !D91A DDF ABNORMAL TERMINATION COMPLETE 
     

   • D91ADBM1
   • D91ADIST

     Note: This value is the DB2 DIST Address space. You find information on ACID password, facility, or suspend problems here.

   • D91ACCA
4. Recycle the DB2 subsystem:

   Check the activity in the region before recycling.

   1. Stop the DB2 subsystem by issuing the following command:

      -stop db2 
      

   2. Start the DB2 subsystem by issuing the following command:

      -start db2