Implementing CA Compliance Manager for CA Chorus for Security and Compliance Management › Implement the Data Mart › Load the DB2 Data Mart Repository

Load the DB2 Data Mart Repository

If you implement a DB2 Data Mart repository, the CMGRDL00 job executes the DB2 Load Utility to load the security information from an UNLOAD DD data set into the DB2 Data Mart repository in the target DB2 subsystem. It executes a series of steps to load and replace the entire DB2 Data Mart repository.

The CMGRDL00 job refers to the following other jobs in CAI.CEIQJCL0. These jobs contain the scripts to load the security event information from the UNLOAD DD data set into each table in the DB2 Data Mart repository:

CMGRDLAA

Loads the ADMACCOUNT target table

CMGRDLAM

Loads the ADMMISC target table

CMGRDLAP

Loads the ADMPOLICY target table

CMGRDLOA

Loads the OBJACCESS target table

CMGRDLSA

Loads the SYSACCESS target table

CMGRDLSC

Loads the SECCONTROL target table

CMGRDLUF

Loads the USSFILE target table

CMGRDLUU

Loads the USSUSER target table

Follow these steps:

1. Edit the CMGRDL00 job in CAI.CEIQJCL0 to conform to your installation standards. Direct it to the target DB2 subsystem where the DB2 Data Mart repository is defined.
2. Modify the job to conform to your installation standards. Follow the instructions in the Notes and Customization sections of the job to customize the job for your environment.

   Important! The DB2 LOAD Utility requires DFSORT. If DFSORT is not your default sort program, add a STEPLIB to the CMGRDL00 or CMGRDA00 job to specify the correct libraries where DFSORT resides.

3. Submit the job.
4. Check the output of the CMGRDL00 job to verify that the security information has been loaded successfully.

   Note: Run the CMGRDL00 job each time you run the Data Mart to replicate the most current information in the DB2 Data Mart repository.