We are installing CA Datacom/AD for use with CA 7 and have an error when running IVP job AXIVP01.
SELECT * FROM MUF_BUF_USE ;
___________SQL ERROR SUMMARY START___________
SQLCODE = -117, SQLSTATE=S158B, DB RETURN CODE = 15(139)
MESSAGE = RAAT/CBS ERROR: CMD=SELFR TBL=MBU DBID=01000 KEY=MBUKY RC=15 (139)
____________SQL ERROR SUMMARY END____________
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 1000 which contains the Datacom dynamic system tables.
Release : 15.1
Component : Datacom/AD
The userid running the IVP job needs to be granted access to the tables in DBID 1000.
If using the sample CA 7 external security members in the CAL2OPTN library, the external security resource class for tables is DCTABLE.
Use the following command to grant access:
RECKEY cxxname ADD(DB01000.- UID(userid) SERVICE(READ) ALLOW)
TSS PER(userid)) DCTABLE(cxxname.DB01000.) ACCESS(READ)
PERMIT cxxname.DB01000.* CLASS([email protected]) ID(userid)) ACC(READ)
See the CA 7 documentation section Secure the CA Datacom/AD MUF, the CA7 sample security members in the CAL2OPTN library are: