Previous Topic: The Load Process for DB2Next Topic: Compliance Information Analysis Reports

Load the Security Information › The Load Process for DB2 › 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.

Follow these steps:

  1. Edit the CIALOAD job in CIA.CAK0JCL0, changing it to conform to your installation standards and directing it to the target DB2 subsystem where the repository is defined.

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

    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.

    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.