Getting the following error in CICS or batch program trying to open a database:
DB00501E - OPEN ERROR - RETURN CODE 69 (071) CXX=SBMUF01
Releases: All releases
Component CA Datacom
The error indicates there is a problem with the index (IXX).
Either the index was damaged, initialized or changes were made to key definitions which marked the keys as not loaded.
The index needs to be initialized and rebuild using the DBUTLTY INIT and RETIX functions.
Follow this procedure:
//SYSIN DD *
ACCESS STATUS=OFF,DBID=nnn,USERS=FAIL
COMM OPTION=CLOSE,DBID=nnn
/*
//SYSIN DD *
INIT AREA=IXX,DBID=nnn
RETIX DBID=nnn,OPTIMIZE=YES,SORT=999999999,OPTION1='(I)'
ACCESS STATUS=WRITE,DBID=nnn
/*
Sample JCL to run DBUTLTY
//UTLTY EXEC PGM=DBUTLTY,REGION=4M
//STEPLIB DD DISP=SHR,DSN=DATACOM.CUSLIB
// DD DISP=SHR,DSN=DATACOM.CABDLOAD << CAAXLOAD for AD
//CXX DD DISP=SHR,DSN=DATACOM.CXX
//SYSPRINT DD SYSOUT=*
//SNAPER DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
Input statements here
/*