Options for cataloging a Datacom/DB database definition to the Directory (CXX)

Products

• Datacom
• Datacom/DB

Issue/Introduction

With Datacom/DB, the definitions for various database entities - Database, Area, Table, Field, Element and Key - are maintained in the Datadictionary system database. Once these entities have been defined, it is necessary to catalog them to the Directory file (CXX) so that they can be used by application programs. This article provides three ways to perform the catalog function.

Environment

Release: All supported releases.

Resolution

1. In DDOL online, issue the command: 
   => CATALOG DATABASE  name STATUS PROD 
   - or - 
   => CATALOG BAS name STA PROD
2. In Batch, run program DDUPDATE with this input:
   //SYSIN    DD  *
-USR DATACOM-INSTALL,NEWUSER
-UPD DATABASE,name(PROD)
1000 CATALOG
-END
/*
3. In Batch, run program DDCFBLD with this input:
   //SYSIN    DD  *
-USR DATACOM-INSTALL,NEWUSER
-CXX CATALOG,name(PROD)
/*

The online command is the easiest to issue, and will process right away assuming the database is already closed. The command can be issued directly from the command line or via the DDOL panels.

The next easiest command is to use the DDUPDATE utility in batch, because this is the most familiar program to those performing DBA roles. Many sites will already have JCL and PROCs defined to use this batch utility. It could be as simple as changing the database name in the input cards.

Finally, batch utility DDCFBLD also performs this CATALOG function, but it is not as commonly used outside making changes to the Datadictionary entities themselves.

Additional Information

For documentation, see Catalog a DATABASE Structure , DDUPDATE 1000 CATALOG Transaction and DDCFBLD -CXX CATALOG.