Previous Topic: The Load Process for DB2Next Topic: Allocate the CIA Real-Time Output Data Sets

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 DB2

Load the Security Information into DB2

After the DB2 repository has been defined to DB2 and the security information has been unloaded to the UNLOAD data set, the security information can be loaded into the DB2 repository. The IBM DB2 LOAD utility is used to insert the security information into the DB2 database.

The CIALOAD job executes a series of steps to load security information into the repository in the target DB2 subsystem.

Important! This job replaces all existing data in the CIA repository. If you want to load additional data from additional systems after you have loaded one system, use the CIALOADA job for each subsequent load, so the existing CIA data is retained in the Repository.

Follow these steps:

  1. Edit the CIALOAD job (or CIALOADA job, if you want to add additional data to the repository) in one of the following libraries:

    Modify the job to conform to your installation standards directing it to the target DB2 subsystem where the repository is defined. Follow the instructions in the Notes and Customization sections of the job to customize the job for your environment.

    Note: The DB2 LOAD utility requires DFSORT. If DFSORT is not your default sort program, add a STEPLIB to the CIALOAD and CIALOADA jobs to specify the correct libraries where DFSORT resides.

  2. Submit the job.

    The job runs and completes.

  3. Verify the output of the CIALOAD job (or CIALOADA job).

    The security information is loaded.

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