Verifying access to CA IDMS data

Edit online

To verify access to CA IDMS data, you can optionally install a set of maps to the sample database EMPDEMO and run queries using the installed maps.

Before you begin

The CA IDMS sample database EMPDEMO must be installed in the central version you plan to access.

About this task

You can customize and run the provided IVP job AVZISIV1 to install maps to the EMPDEMO database and network schema maps to the SYSTEM database.

The following maps are installed for verification testing using the sample EMPDEMO database:

Table 1. CA IDMS EMPDEMO database maps
Map Description
EMPSS01_EMPLOYEE Enables SQL access to EMPLOYEE record.
EMPSS01_OFFICE Enables SQL access to the OFFICE record.
EMPSS01_DEPARTMENT Enables SQL access to the DEPARTMENT record.
EMPSS01_OFFICE_EMPLOYEE Enables SQL access to the OFFICE-EMPLOYEE set for joining the EMPSS01_OFFICE and EMPSS01_EMPLOYEE tables.
EMPSS01_DEPT_EMPLOYEE Enables SQL access to the DEPT-EMPLOYEE set for joining the EMPSS01_DEPARTMENT and EMPSS01_EMPLOYEE tables.

The network schema maps can be used for verification purposes if the EMPDEMO database is not installed in your central version. These maps access records and sets in the CA IDMS network schema IDMSNTWK, providing SQL access to application metadata. The following table provides a subset of the installed network schema maps that can be used for verification purposes:

Table 2. CA IDMS network schema IDMSNTWK maps
Map Description
IDMSNWKA_S_010 Enables SQL access to the S-010 network schema record. S-010 records describe application schemas defined to your IDMS central version.
IDMSNWKA_SS_026 Enables SQL access to the SS-026 network schema record. SS-026 records describe application subschemas defined to your IDMS central version.
IDMSNWKA_SSR_032 Enables SQL access to the SSR-032 network schema record. SSR-32 records describe application subschema records defined to your IDMS central version.
IDMSNWKA_S_SS Enables SQL access to the S-SS set for joining the IDMSNWKA_S_010 and IDMSNWKA_SS_026 tables.
IDMSNWKA_SS_SSR Enables SQL access to the SS-SSR set for joining the IDMSNWKA_SS_026 and IDMSNWKA_SSR_032 tables.

Procedure

  1. Locate the AVZISIV1 member in the hlq.SAVZCNTL data set.
  2. Modify the JCL according to the instructions provided in the AVZISIV1 member.
  3. Submit the job.
  4. If the server is active, use the following instructions to refresh maps and make the maps available for use:
    1. From the Primary Option Menu, specify option D, Data Mapping, and press Enter.
    2. From the Data Mapping Facility menu, specify option 3, Map Refresh, and press Enter.

Results

AVZISIV1 installs CA IDMS EMPDEMO and network schema maps into the server map data set.