Implementing CA Compliance Manager for CA Chorus for Security and Compliance Management › Implement the CA Compliance Manager DB2 Repositories › Define the CA Compliance Manager Repositories for DB2

Define the CA Compliance Manager Repositories for DB2

The CMGRIDB2 job defines the DB2 repositories for the following CA Compliance Manager components:

• Warehouse
• Data Mart
• Monitor

Follow these steps:

1. Edit the CMGRIDB2 job in CAI.CEIQJCL0.

   Modify the job to conform to your installation standards. Follow the instructions in the Notes and the Customization sections of the job to customize the job for your environment.

   Note: The CMGRIDB2 job contains multiple steps. The job defines the DB2 repositories for the Warehouse, Data Mart, and Monitor components. The CMGRIDB2 job binds the CA Compliance Manager plans, and using native DB2 security, grants access to DB2 resources to the component started tasks.

2. Delete the job steps that define the repository for the CA Compliance Manager components that you are not running.
3. Submit the CMGRIDB2 job.
4. Review the output of the CMGRIDB2 job.

   Verify that the repositories are successfully defined, the plans are bound, and the GRANT statements are successful.