Previous Topic: Installing the CA Common Services Easytrieve ComponentNext Topic: Implement the CIA Repository in CA Datacom

Configuring the CIA Repository › Install the CA Pan/SQL Interface

Install the CA Pan/SQL Interface

CA Pan/SQL is required only for the compliance reports.

The CA Common Services CA Easytrieve component calls CA Pan/SQL when the reports are run. Before running the compliance reports distributed with the CIA feature, install the CA Pan/SQL interface, which has been supplied on a separate tape from your security product. For complete information about how to install CA Pan/SQL, see CA Pan/SQL Getting Started.

Update member OMSMCMD2 in the Pan/SQL CAIMAC library, and set MAXCUR=40.

Note: If you have CA Pan/SQL already installed, and MAXCUR is set to at least 40, then you can skip this step.

To set MAXCUR=40

For new installs:

  1. Verify that member OMSMCMD2 has been updated to say MAXCUR=40.
  2. Run job IJ3STGE1 from the CA Pan/SQL INSTALL.JCL library.

    Note: For additional information about customizing CA Pan/SQL, see CA Pan/SQL Getting Started.

If CA Pan/SQL is already installed:

  1. Update member OMSMCMD2 to say MAXCUR=40.
  2. Run job IJ3STGE1 from the CA Pan/SQL INSTALL.JCL library.

    Note: For DB2 users, DB2 SYSADM authority is required to run IJ3STGE1.

  3. Run job CB2ACMDL from the CA Pan/SQL INSTALL.JCL library.

For more information, see Software Requirements.