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.¨
Release : 3.0
Component : CA DATA CONTENT DISCOVERY
The Db2 subsystem was still at v12 CM causing an SQL error 4743 when trying to display scans in DCD.
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.