search cancel

SQL error -805 in COMPRT step of ssid0000 Compare job

book

Article ID: 243215

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS

Issue/Introduction

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                                                      

 

Environment

Release : 20.0

Component : DB2 Common Components

Resolution

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.