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____________
Release : 12.1
Component : CA 7
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.
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([email protected]) ID(userid)) ACC(READ)