DCD (Data Content Discovery) encounters the error message DCD0190E performing scans

Products

• Data Content Discovery

Issue/Introduction

Performing scans in DCD the DCDCONTL task reveals the following problem: Error in getting scan by pageId                                
com.ca.security.dcd.exceptions.DatabaseException: Error in getting scan by page id        
Exception Context:                                                                        
1:ERRORCODE=DCD0190E¨                                                                   
2:ERROR=Error while getting scans.¨                                                     
3:STATUSCODE=¨                                                                          
4:TRANSLATIONKEY=error_in_getScans¨                                                     
5:Page id=1¨                                                                            
6:Scan limit=20¨                                                                        
7:Resolution=Contact CA Support.¨                

Environment

Release : 3.0

Component : CA DATA CONTENT DISCOVERY

Cause

The Db2 subsystem was still at v12 CM causing an SQL error 4743 when trying to display scans in DCD.  

Resolution

Upgrading Db2 to v12 NFM corrected the problem.

If using SPUFI, DCD uses two packages, NULLID.SYSLH200 and NULLIDRA.SYSLH200, when processing SQL statements.  These two packages should be bound with Db2 V12 maintenance levels.  The APPLCOMPAT field in the SPUFI output should either be V12R1 or V12R1M500 which are equivalent.