Previous Topic: Install CA IDMS Server from CA IDMS Installation PAX FileNext Topic: Create an SQL Schema to Access Network CA IDMS-Data

How to Use SQL Web Connect › Create an SQL Catalog and Demo Database

Create an SQL Catalog and Demo Database

To use SQL Web Connect, an SQL Catalog needs to be available for your system.

Note: If you have created an SQL Catalog for your system at an earlier point, for example, for use with CA IDMS Visual DBA, you can skip this step.

When creating the SQL Catalog, you can also create and populate the SQL version of the Employee Skills Demo Database on one or more of your CVs. Creating a Demo Database lets you verify the validity of the SQL Web Connect functionality using non-production native SQL data. You are free to run SELECT, DROP, UPDATE & INSERT commands against this database without fear of corrupting sensitive data. Alternatively, you can create an SQL Schema, which allows you to access your network CA IDMS-data using SQL.

Follow these steps:

  1. Select either CAISAG or CA Chorus Software Manager (CA CSM) to create the SQL Catalog and, optionally, the Demo Database. If you select to use CAISAG, continue with step 2. If you select to use CA CSM (the recommended method), continue with step 3.
  2. Create the SQL Catalog and Demo Database using CAISAG.

    Several VARBLIST configuration variables assist you in the creation of an SQL Catalog and Demo Database on your system. Use the appropriate variables depending on whether you are running a 'Base', 'Upgrade' or 'Add-On' configuration:

    1. Use the following variables for a ‘Base’ configuration of CA IDMS:
      • SYSSQL = YES—Governs the creation of System SQL catalog.
      • SQLDEMO = YES—Governs the creation of the SQL Demo Database.
    2. Use the following variables for an ‘Upgrade’ configuration of CA IDMS:
      • UPGSYSQL = YES—Governs the creation of the System SQL catalog.
      • UPGQDEMO =YES—Governs the creation of the SQL Demo Database.
    3. If you have already upgraded your CA IDMS system, but would like to create an SQL Catalog, SQL Demo Database, or both ‘after the fact’, perform an ‘Add-On’ installation to accomplish this task. Use the following variables for an ‘Add-On’ configuration of CA IDMS:
      • BEGINMEM = SQL—Sets the prefix for generated members to ‘SQL’.
      • ADDSYSQL = YES—Governs the creation of System SQL catalog.
      • ADDQDEMO = YES—Governs the creation of the SQL Demo Database.

      When the CAISAG job is run, several new SQL-prefixed members are added into your CAISAG configuration library. The following jobs contain the steps necessary to add the SQL catalog and Demo Database to your system for an ‘Add-On’ installation:

      • SQL05—This job allocates the SQL catalog and Demo Database files.
      • SQL08—This job builds the new SQL catalog.
      • SQL10—This job formats and populates the new SQL catalog.
      • SQL15—This job builds, formats, and populates the new SQL Demo Database.

      Note: For more information about modifying the VARBLIST member, see the SQL Web Connect VARBLIST Variables section.

  3. Create the SQL Catalog and Demo Database using CA Chorus Software Manager (CA CSM). The process of adding the SQL catalog and Demo Database is described within the CA CSM interface itself.

    When using CA CSM, you have the same options/variables available for adding the SQL catalog and SQL Demo Database as described in the preceding step for CAISAG.

    Note: CA CSM refers to an ‘Add-On installation’ as an ‘Update installation’ (or ‘Update configuration’).

Important! The addition of the SQL Catalog, SQL Demo Database, or both requires updates to both the global DMLC and Database name Table (DBTB) of your CV. These updates are performed automatically in the job steps that are generated by both CAISAG and CSM. Backups of both the global DMCL and DBTB are also performed during these job steps.

Note: Specify ‘NO’ for the CA IDMS SQL Option if you do not have a license for it. Specifying 'NO' creates an RHDCPINT module without SQL selected and assembles the IDMSCINT macro with SQL=NO. New configuration variables (detailed above) allow you to select whether to install the SYSSQL catalog component and the SQL Demo Database. These two choices are independent of your product selection. This process allows you to install the SYSSQL catalog component and the SQL Demo Database even if you do not have a license for the CA IDMS SQL Option. The SYSSQL catalog component is a prerequisite for the SQL Demo Database. The SYSSQL database uses 600 tracks (40 CYL) and the SQL Demo Database uses 25 tracks (<2 CYL).