Implementing CIA Real-Time for CA Chorus for Security and Compliance Management › Load the Security Information into a CA Datacom/AD Repository

Load the Security Information into a CA Datacom/AD Repository

After the CIA application and repository is defined to CA Datacom/AD and the security information is unloaded with the CIAUNLD job, the CIALOADC job converts the unloaded security information from DB2 load format into CA Datacom/AD load format and separates the converted records into individual data sets by table as required by the CA Datacom/AD load process. It then executes the CA Datacom/AD DBUTLTY program to load the security information into the CIA repository tables.

The CIALOADC job consists of the following steps:

• DELETE. Deletes existing CA Datacom/AD load format data sets.
• CONVERT. Executes the CIADCCNV conversion utility to convert the unload data set created by the CIAUNLD job into the appropriate CA Datacom/AD load format data sets.
• CLEARDB. Deletes any information currently in the CIA repository tables.
• LOAD. Executes the CA Datacom/AD DBUTLTY program to load the security information into the CIA repository tables.

  Note: The CLEARDB step of this job deletes all existing data in the current CIA repository tables. If you wish to add new data to an existing CIA repository, remove the CLEARDB step from the job before execution.

Follow these steps:

1. Edit the CIALOADC job in one of the following libraries:
   • CA ACF2 - CAI.CAX1JCL0
   • CA Top Secret - CAI.CAK0JCL0

   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. Adjust the space allocations within the CONVERT step based on the storage requirements estimated for each of the CA Datacom/AD UNLOAD data sets . For more information, see Estimate the Storage Requirements for CA Datacom/AD Load Format Data Sets.
3. The CLEARDB step of this job deletes all existing data in the current CIA repository tables. If you are adding new data to an existing CIA repository, remove the CLEARDB step from the job before execution
4. Submit the job.

   The job executes and completes

5. Verify the output of the CIALOADC.

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

   Note: The CIA load data conversion utility executed by the CONVERT step returns the following codes:

   • 0 - Data conversion process was successful.
   • 12 - Data conversion process failed. A diagnostic message was issued.

Note: Each time you run the Unload utility, run the conversion utility to replicate the most current information in the CIA repository.