Implementing CA Compliance Manager for CA Chorus for Security and Compliance Management › Implement the Data Mart › Load the CA Datacom/AD Data Mart Repository › Execute the Data Mart CA Datacom/AD Conversion Utility

Execute the Data Mart CA Datacom/AD Conversion Utility

The CMGRDLDC job in the CAI.CEIQJCL0 library converts the UNLOAD DD data set information, which is in DB2 load format into CA Datacom load format and loads the information into the CA Datacom Data Mart repository.

The CMGRDLDC job consists of the following steps:

DELETE.

Deletes existing CA Datacom load format data sets.

CONVERT.

Executes the ECADMDCC conversion utility to convert the unload data set into the appropriate CA Datacom load format data sets. This unload data set is created by the CMGRDUNL job.

CLEARDB.

Deletes any information currently in the Data Mart repository tables.

Note: The CLEARDB step of this job deletes all existing data in the current Data Mart repository tables. To add new data to an existing Data Mart repository, remove the CLEARDB step from the job before execution.

LOAD.

Executes the CA Datacom DBUTLTY program to load the security information into the Data Mart repository tables.

CONTBLS.

Inserts constant information into the constant value tables in the Data Mart repository.

Follow these steps:

1. Edit the CMGRDLDC job in CAI.CEIQJCL0.

   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.

2. Modify the space parameters in the CONVERT step for each CA Datacom/AD load format data set based on your estimates. See Estimate the Storage Space for Data Mart CA Datacom/AD Conversion Utility Output Data Sets.
3. Add new data to an existing Data Mart repository by removing the CLEARDB step from the job before execution.

   The CLEARDB step of this job deletes all existing data in the current Data Mart repository tables.

4. Specify the Data Mart Selection Utility UNLOAD DD output data set that contains security event information in DB2 Load Utility format. The Data Mart CA Datacom/AD Conversion Utility converts this information into CA Datacom/AD load format.
5. Specify the Data Mart CA Datacom/AD Conversion Utility (REPORT DD) Statistical Report output data set.

   The Utility writes the following information to this file:

   • Statistical summary information about the DB2 to CA Datacom/AD load format conversion process
   • Errors that caused the Utility to terminate before successful completion
6. Submit the job.

   The job executes and completes.

7. Verify the output of the CMGRDLDC job.

   Check the output of the CMGRDLDC job, verifying that the security event information has been loaded successfully.

   Note: If the CMGRDLDC job fails for any reason, review the error in the Data Mart CA Datacom/AD Conversion Utility Report (REPORT DD) output data set, fix the error, and rerun the job until it successfully completes. The job must successfully complete for the output data sets to load properly into the Data Mart CA Datacom/AD repository.