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

Load Additional Data Into an Existing DB2 Data Mart Repository

You may need to load additional security information from an UNLOAD DD data set into an existing Data Mart repository without deleting or replacing any of the existing data. Unlike the CMGRDL00 job, which loads and replaces the entire DB2 Data Mart repository, the CMGRDA00 job executes a series of steps to load additional security information into an existing DB2 Data Mart repository in the target DB2 subsystem without replacing any data.

The CMGRDA00 job in CAI.CEIQJCL0 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:

CMGRDAAA

Loads the ADMACCOUNT target table

CMGRDAAM

Loads the ADMMISC target table

CMGRDAAP

Loads the ADMPOLICY target table

CMGRDAOA

Loads the OBJACCESS target table

CMGRDASA

Loads the SYSACCESS target table

CMGRDASC

Loads the SECCONTROL target table

CMGRDAUF

Loads the USSFILE target table

CMGRDAUU

Loads the USSUSER target table

Follow these steps:

1. Edit the CMGRDA00 job in CAI.CEIQJCL0. Direct it to the target DB2 subsystem where the DB2 Data Mart repository is defined.

   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 job to specify the correct libraries where DFSORT resides.

2. Submit the job.
3. Verify that the security information has been loaded successfully by checking the output of the CMGRDA00 job.

   Note: Run the CMGRDA00 job each time you run the Data Mart to add the most current information to the DB2 Data Mart repository.