CNVGRANT getting -00805 executing CADB2C11 for first time
search cancel

CNVGRANT getting -00805 executing CADB2C11 for first time

book

Article ID: 12527

calendar_today

Updated On:

Products

Top Secret Top Secret - LDAP

Issue/Introduction

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


DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME SYS1..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



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

 

DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME SYS1..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 

Environment

Release: TOPSDB00200-1.3-Top Secret-Security-Option for DB2 UDB
Component:

Resolution


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.

Use 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)