Executing the Db2 Catalog Customization Task, INS Compare Db2 Objects, job ssid0000, fails with SQL errors -805.
RMA199E PROGRAM [email protected] RECEIVED THE FOLLOWING SQL ERROR:
DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME location-
[email protected] NOT FOUND IN PLAN RCMAPLAN. REASON
03
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -251 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF05' X'00000000' X'00000000'
X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION
RMA199E PROGRAM [email protected] RECEIVED THE FOLLOWING SQL ERROR:
DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME location-
[email protected] NOT FOUND IN PLAN RCMAPLAN. REASON 03
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -251 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF05' X'00000000' X'00000000'
X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION
Release : 20.0
Component : DB2 Common Components
The -805 SQL errors in the COMPRT step indicate that the CDBALOAD load library and the CDBADBRM DBRM library are out of sync or incomplete.