Adding 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. (Note: there is no BUFFER-related syntax provided here because this is heavily dependent on what is already in the DMCL. If the DMCL's DEFAULT BUFFER is not usable (due to page size), provide appropriate buffer assignments as documented at segment-specification and file-override-specification on the DMCL page).
   
   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