Compliance Manager load job fails with:
SEC##02E SQLD - SQL Failure Detected (Diagnostic Location IRQO , 387)
SEC##03I SQLD - DSN00545E THE REQUESTED OPERATION IS NOT ALLOWED BECAUSE A ROW DOES NOT SATISFY THE CHECK CONSTRAINT RESC_ACCESSOR_TYPE
SEC##04E SQLD - SQLCODE = -545
Release : 2.0
Component : CA COMPLIANCE MANAGER FOR Z/OS
CA7 scheduler id associated with the Scheduled Compliance Manager load job is not authorized to the DB2 objects. Authorizing the acid associated with the job resolves the problem.