CA 7 SQL job receiving SQLCODE = -117, SQLSTATE=S158B, DB RETURN CODE = 15(139)

Products

• CA 7 Workload Automation

Issue/Introduction

When running the AL2SQL job against the CA 7/CA Datacom database, receiving the error

 ___________SQL ERROR SUMMARY START___________                           
                                                                         
 SQLCODE = -117, SQLSTATE=S158B, DB RETURN CODE = 15(139)                
 MESSAGE = RAAT/CBS ERROR: CMD=SELFR TBL=JOB DBID=00770 KEY= RC=15 (139) 
 ____________SQL ERROR SUMMARY END____________                           
                                                                         

Environment

Release : 12.1

Component : CA 7

Cause

The return code 15(139) is a security violation, see the Datacom documentation section Return Code 15 - SECURITY VIOLATION. 

This means Datacom external security is turned on and the userid running the IVP job does not have access to DBID 770 which contains the Datacom dynamic system tables.

Resolution

If using the sample CA 7 external security members, AL2ACF2D or AL2RACFD or AL2TSSD  in the CAL2OPTN library, the external security resource class for tables is DCTABLE.

 

Use the following command to grant access:

ACF2:
SET RESOURCE(DCT)                                                               
RECKEY cxxname ADD(DB00770.- UID(userid) SERVICE(READ) ALLOW)  

Top Secret:
TSS PER(userid)) DCTABLE(cxxname.DB00770.) ACCESS(READ)  

RACF:
PERMIT cxxname.DB00770.* CLASS(DC@ABLE) ID(userid)) ACC(READ)