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.
Release : 3.0
Component : CA DATA CONTENT DISCOVERY
There are two options to address the -805 sql error:
To disable switching to NULLIDRA package issue the following modify command:
With the next PTF of DCD, a dao properties parameter will be introduced that can permanently override the switching to NULLIDRA.