DCD when running Autoscans getting -805 sql error using DB2 NULLIDRA packages

Products

• Data Content Discovery

Issue/Introduction

With DCD Autoscan queries in r3 are pretty complex, DCD requires the dynamic package SYSLH200 is bound with into a new collection NULLIDRA with a bind option REOPT(ALWAYS).  In DCD, when running Autoscans, DCD switches from using the default DB2 collection NULLID and using the NULLIDRA.  The NULLIDRA is not shipped with Db2. Sites that do not have that NULLIDRA package get the -805 when running Autoscans.

Environment

Release : 3.0

Component : CA DATA CONTENT DISCOVERY

Resolution

There are two options to address the -805 sql error:

1. Run binds to have the NULLIDRA available.
2. Disable the switching to NULLIDRA by running the MODIFY command.

To disable switching to NULLIDRA package issue the following modify command:

/f stc,appl=reopt=TRUE|FALSE

With the next PTF of DCD, a dao properties parameter will be introduced that can permanently override the switching to NULLIDRA.