When I start the DCDCONTL controller Task I am getting 'Could not get JDBC Connection' with ERRORCODE=-4499, SQL STATE=58014, what is causing this error?

Products

• Data Content Discovery

Issue/Introduction

When I start the DCDCONTL controller Task I am getting 'Could not get JDBC Connection' with ERRORCODE=-4499, SQL STATE=58014, what is causing this error?

Environment

Release:
Component: DCD

Resolution

The 'Could not get JDBC Connection' with ERRORCODE=-4499, SQL STATE=58014 can be caused by specifying the wrong DB2 port for your DB2 database.

The DB2 port for your DB2 databases is specified in the CONFIG(FEYCFG) file for the DB_PORT variable. This value is the currently assigned port used by your database.  For IBM DB2, the port can be identified in the DB2 initialization job by the TCPPORT value in the message DSNL004I.

To change the DB2 port, do the following steps:

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

    P DCDCONTL

2. Edit the DB_PORT 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 DB_PORT 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