DB00501E OPEN ERROR 25 (020) -35 TTM IS UNUSABLE -117

Products

• Datacom/AD
• Datacom/DB
• DATACOM - AD
• Datacom

Issue/Introduction

Started the Datacom MUF with the SQL option for the first time.

Getting the following errors running SQL commands:

DB00501E - OPEN ERROR - RETURN CODE 25 (020) CXX=xxxxxxx   (TTM00017)

SQLCODE = -35, SQLSTATE=58S02, DB RETURN CODE = 25(20)

MESSAGE = TTM IS UNUSABLE: SQLCODE -117, DB RC 25(20) ON INITIALIZATION

 

Cause

The TTM area, DBID 17 comes already defined in the CXX during installation, in the CXX LOAD from backup.

But in this case the CXX is missing DBID 17 and also DBID 16 which is used by SQL.

Resolution

Run the following DDUPDATE to add the missing DBIDs:

//UPDATE    EXEC PGM=DDUPDATE,REGION=4M
//STEPLIB  DD DISP=SHR,DSN=DATACOM.CUSLIB   
//         DD DISP=SHR,DSN=DATACOM.CABDLOAD 
//         DD DISP=SHR,DSN=IPC.CAVQLOAD 
//DDSNAP   DD SYSOUT=*
//SYSOUT   DD SYSOUT=*
//SYSPUNCH DD DUMMY
//SYSPRINT DD SYSOUT=*
//SNAPER   DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN    DD  *
+USR DATACOM-INSTALL,NEWUSER
//         DD  DSN=DATACOM.CABDSAMP(BTG0016),DISP=SHR 
//         DD  DSN=DATACOM.CABDSAMP(BTG0017),DISP=SHR 
/*
//