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

book

Article ID: 224915

calendar_today

Updated On:

Products

CA Datacom CA Workload Automation CA 7 Edition CA Datacom/AD

Issue/Introduction

I ran AL2DCA40 and it is failing with this error. Please advise.

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

Environment

Release : 15.1

Component : CA Datacom/AD

Resolution

Run a CXX report, look for database 770 (or base # that is being affected) and locate the AREA's 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: CA7MFP1

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 you do not want to delete all tables and areas. 

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 CA Datacom/AD for Use with CA WA CA 7