Implementing CIA Real-Time for CA Chorus for Security and Compliance Management › Implement the CIA Repository in DB2 › Define the CIA Repository for DB2

Define the CIA Repository for DB2

The CIADB2 job performs the tasks of defining the CIA application and repository to DB2. Within the job are individual job steps that do the following:

• Define the CIA database, table spaces, tables, and indexes that comprise the security repository.
• Define the CIA service functions
• Define the CIA stored procedures
• Bind the application packages that correspond to the service functions

Note: If you are an existing CIA user, the CIADB2 combines a number of separate jobs (CIADDL, CIAFUNC, CIAPROC, and CIABIND) that were run with previous CIA releases.

Follow these steps:

1. Verify that the DB2 subsystem into which the CIA repository will be installed is running.
2. Edit the CIADB2 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 and direct it to the target CIA DB2 subsystem where you want to define the repository.

3. Submit the job.

   The job runs and completes.

4. Verify the output of the CIADB2 job.

   The CIA application and repository are defined correctly in DB2.The DB2 data structures are defined.