CA Data Content Discovery Controller startup receives: 'Could not get JDBC Connection' and 'Cannot load JDBC driver class'

Products

• Data Content Discovery

Issue/Introduction

 During the CA Data Content Discovery Controller startup, I see messages in the STDERR file: 'Could not get JDBC Connection' and 'Cannot load JDBC driver class', how do I address these errors?

Exception in thread "Thread-9" org.springframework.jdbc.CannotGetJdbcConnectionException: 

Could not get JDBC Connection; nested exception is java.sql.SQLException: 

Cannot load JDBC driver class 'com.ibm.db2.jcc. DB2Driver'

 

  

Environment

Release:
Component: DCD

Resolution

The DB2 path is set incorrectly. To change the DB2 path, do the following steps:

1. Stop the CA Data Content Discovery Controller address space:

   P DCDCONTL

2. Edit the DB2_JDBC_PATH variable in yourhlq.CFEYOPTN(FEYCFG), and save the member.

   Important! Running the FEYDEPLY job overwrites the values in the runtime environment with the values that are specified in the FEYCFG member. If you made changes to the runtime environment since you last ran the FEYDEPLY job, we recommend that you make a backup copy of the runtime environment before you continue with this procedure.

3. Submit the FEYDEPLY job in yourhlq.CFEYJCL. Doing so propagates the DB2_JDBC_PATH value to the runtime environment.

   The expected return code is 0.

   Note: For more information about FEYDEPLY, see Deploy Maintenance to the Runtime Environment.

4. Restart the CA Data Content Discovery Controller address space:

   S DCDCONTL