How to add a new SQL catalog segment to an existing dictionary

Products

• IDMS

Issue/Introduction

This document describes how to add an SQL catalog segment to an existing dictionary.

Environment

Release : All supported releases
Component: IDMS SQL Option

Resolution

Note: if you are adding more than one catalog segment to the same CV at the same time (for example, when performing an add-on configuration for the SQL Option), you may perform steps 1-3, 5-6 and 8-10 together for all of the new catalogs, and perform steps 4 and 7 only once.

1.  Using SEGMENT.TXT in the attached .zip file as a sample, determine appropriate syntax for the segment and save it in, for example, your.idms.SRCLIB(TESTSQL).
2.  Using OCF or a CV-mode IDMSBCF batch job, add the segment definition to the SYSTEM catalog.

//SYSIPT   DD *
CONNECT TO SYSTEM;
//         DD DISP=SHR,DSN=your.idms.SRCLIB(TESTSQL)

3.  Include the segment in the DMCL and in the dictionary dbname.

CONNECT TO SYSTEM;
ALTER
DMCL CVnnDMCL
    INCLUDE SEGMENT TESTSQL;
ALTER
DBNAME CVnnDBTB.TESTDICT
    INCLUDE SEGMENT TESTSQL;

4.  Generate and link the DMCL and DBTABLE.
5.  Using ALLOCATE.TXT in the attached .zip file as a sample, allocate the three physical datasets according to the page size and number of pages chosen.
6.  Using a local-mode IDMSBCF batch job, format the new catalog.

//SYSIPT   DD *
CONNECT TO SYSTEM;
FORMAT SEGMENT TESTSQL;

7.  Cycle the CV.
8.  Using a CV-mode IDMSBCF batch job, load the necessary SQL entities.

//SYSIPT   DD *
CONNECT TO TESTDICT;
//         DD DISP=SHR,DSN=smpe.idms.CAGJSRC(TABLEDDL)
//         DD DISP=SHR,DSN=smpe.idms.CAGJSRC(VIEWDDL)
//         DD DISP=SHR,DSN=smpe.idms.CAGJSRC(VDB5V18X)  <== only if using Visual DBA

9.  Perform an UPDATE STATISTICS for the new catalog area.

CONNECT TO TESTDICT;
UPDATE STATISTICS FOR AREA TESTSQL.DDLCAT;

10.  Add the source definition of the new segment to the catalog.

//SYSIPT   DD *
CONNECT TO TESTDICT;
//         DD DISP=SHR,DSN=your.idms.SRCLIB(TESTSQL)

Additional Information

Defining New Dictionaries