AL2DCA40 fails with DDTRS0016E, SQL RC: -117, and RC 13(011)

Products

• Datacom
• Datacom/AD
• CA 7 Workload Automation

Issue/Introduction

AL2DCA40 fails with following error: 

DDTRS0016E DBQEXEI FAILED SQL COMMAND QEXEI, RC: -117.
           SQL ERROR MESSAGE: RETURN CODE <13(011)> ON COMMAND <OPEN> TABLE <DSO> DBID <00770> KEY <>

Environment

z/OS

 

Resolution

Run a CXX report, look for database 770 (or the database # that is being affected) and locate the AREAs that have a Data Set Name of - UNKNOWN. This means that an INIT/NULL LOAD were never done.
An excerpt of the report is pasted down below

Base:   770         ******************************************************************************** Directory: cxxname
TABLE NAME - DSO                                            AREA NAME  - DFS
OCCURRENCE - CA7770-DSO P001                                OCCURRENCE - CA7770-DFS-AREA P001
TABLE ID   -     24                                         AREA SQLNAME - CA7770_DFS_AREA
RECORD LENGTH    -    422 /    434                          BLOCK LENGTH      -       8,19
....
....
....
CURRENT ROW(S) VIOLATE CONSTRAINT(S) - NO      HISTORY ROW(S) VIOLATE CONSTRAINT(S) - NO
DATA SET NAME - UNKNOWN                        DATA  DTF/DDNAME - AWL770

To solve this, use the CA7 provided JCL yourhlq.CAL2OPTN(AL2INLD) for the //SYSYIN step of job AL2DCA30 to INIT/NULL LOAD all areas.
*NOTE* The AL2INLD job will delete all data in these tables. Modify accordingly if not all tables/areas should be deleted.

The AL2INLD member should contain:

COMM OPTION=CLOSE,DBID=770                
INIT AREA=IXX,DBID=770                    
INIT AREA=MIN,DBID=770                    
INIT AREA=DFS,DBID=770                    
INIT AREA=JOB,DBID=770                    
INIT AREA=AWS,DBID=770                    
INIT AREA=AWL,DBID=770                    
INIT AREA=AWH,DBID=770                    
INIT AREA=HIS,DBID=770                    
INIT AREA=HIL,DBID=770                    
LOAD AREA=MIN,DBID=770,FORMAT=NONE,SORT=1 
LOAD AREA=DFS,DBID=770,FORMAT=NONE,SORT=1 
LOAD AREA=JOB,DBID=770,FORMAT=NONE,SORT=1 
LOAD AREA=AWS,DBID=770,FORMAT=NONE,SORT=1 
LOAD AREA=AWL,DBID=770,FORMAT=NONE,SORT=1 
LOAD AREA=AWH,DBID=770,FORMAT=NONE,SORT=1 
LOAD AREA=HIS,DBID=770,FORMAT=NONE,SORT=1 
LOAD AREA=HIL,DBID=770,FORMAT=NONE,SORT=1  

Make the necessary changes, rerun, and continue to Configure Datacom/AD for Use with CA 7 .