DCDCONTL fails at startup with ERRORCODE=DCD0324E

Products

• Data Content Discovery

Issue/Introduction

DCDCONTL fails at startup 

with

 

2021-02-08 11:34:09,755 Error in getting table encoding                           
com.ca.security.dcd.exceptions.DatabaseException: Exception in getEncodingForTable

Exception Context:                                                                
1:ERRORCODE=DCD0324E.                                                           
2:ERROR=Database exception in TableEncoding DAO getEncodingForTable..           
3:STATUSCODE=.                                                                  
4:TRANSLATIONKEY=error_in_dbEncoding.                                           
5:table Name=CLASSIFIER.                                                        
6:Resolution=Contact CA Support..      

 

Environment

Release : 3.0

Component : CA DATA CONTENT DISCOVERY

Resolution

The DCDCONTL started task is executing an SQL statement to query SYSIBM.SYSTABLES under DCDADM userid to make sure that the DCD repository has been created with a correct encoding.

 

Verify that the DCDADM has the permissions to query SYSIBM.SYSTABLES in the DB2 subsystem specified in

dao.properties file in '/DCDRUNTIME/config' directory.

 

Perform the following:

1). Check the contents of '/DCDRUNTIME/config/dao.properties' and find

'jdbc.db2.dbUrl=jdbc:db2://host:port/location' definitions.

2). Check the DB2 subsystem configured in dao.properties for any security violations in either xxxxMSTR or xxxxDIST coming from DCDADM or DCDCONTL.

3). Check if DCDADM has permissions to issue query 'SELECT ENCODING_SCHEME FROM SYSIBM.SYSTABLES WHERE CREATOR='@DB2_QUALIFIER@' AND  NAME = 'CLASSIFIER';'

Note: @DB2_QUALIFIER@ value has been configured during DCD Install/Configuration and can be found in the dao.properties as 'jdbc.db2.dbQualifier'.