CNVGRANT getting -00805 executing CADB2C11 for first time

Document ID : KB000012527
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Running CNVGRANT job after upgrading to DB2 v11 from DB2 v10, but receive a SQLCODE -00805.


DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DEVC..CADB2C11.1952B6B-
A0110E94C NOT FOUND IN PLAN CADB2C11. 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

Question:

Running CNVGRANT job after upgrading to DB2 v11 from DB2 v10, but receive a SQLCODE -00805. 

 

DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DEVC..CADB2C11.1952B6B- 
A0110E94C NOT FOUND IN PLAN CADB2C11. 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 

Answer:


CA Top Secret for DB2 1.3 must be up and initialized before running the CNVGRANT job.

The following documentation lists the requirements needed before running the utility. Having TSSDB2 1.3 installed is the first requirement on the list.

https://docops.ca.com/display/CTSOFDS13/Using+the+Conversion+Utility

Common causes for TSSDB2 to not initialize are:

1. DB2 v11 compatibility maintenance is not on for TSSDB2 and ENF. You have already verified that is on.

RO54332 TSSDB2 support fix
RO64641 TSS Base

RO65361 - CA DB2 common code fix
RO55816 - CA DB2 common code fix

Common Services (ENF) solution RI63020 documents RO57094/RO57084 for DB2 V11 support.

2. ENF is not up when DB2 starts up. Please make sure ENF is up before starting DB2.

3. DB2REL in ENF parms is not set correctly.

MODE(DB2,ON)
DB2REL(23)


4. The TSSDB2 DCM is not installed and not in the ENF database.

DCM(DB10DCM1,DCMTSSDB)