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

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

Introduction:

With CA Datacom/DB, the definitions for the various database entities – Databases, Areas, Tables, Element, Keys, and Fields – are maintained in the Datadictionary database. Once these entities are defined, it is necessary to catalog them to the Directory (CXX) so they can be used by application programs.

There are three methods listed here (in order of their ease of use) to perform this catalog function. All three assume that the database is closed in the Multi-User Facility if it already exists.

Instructions: 

1. Online, you can issue the command: 
   => CATALOG DATABASE SCD-ACTIVITY-DB STATUS PROD 
   - or - 
   => CATALOG BAS SCD-ACTIVITY-DB STA PROD
2. In Batch, you can run program DDUPDATE with this input:
   //SYSIN    DD  *
   -USR DATACOM-INSTALL,NEWUSER
   -UPD DATABASE,SCD-ACTIVITY-DB(PROD)
   1000 CATALOG
   -END
   /*
   
3. In Batch, you can run program DDCFBLD with this input:
   //SYSIN    DD  *
   -USR DATACOM-INSTALL,NEWUSER
   -CXX CATALOG,DATABASE,SCD-ACTIVITY-DB(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 you can fill the names out on the DDOL panel, which you can get to in one of three ways:

• Select the CATALOG option on the DB Structure Functions Menu and fill in the following prompter panel.
• Use the CATALOG command.
• Type the CAT margin command in the line number of the DATABASE on an indented structure or an index display, enter the PROCESS command (press PF4) to obtain a filled in CATALOG prompter panel, and press PF9 (APPLY).

The next easiest command is to use the DDUPDATE program in batch, because this is the most familiar program to those performing DBA roles. Many firms will already have JCL and procs defined to use this program, and it could be as simple as entering the -UPD DATABASE..., 1000 CATALOG and -END functions into the input stream.

Finally, the DDCFBLD program will also perform these same functions, but it is not as commonly used outside of making changes to the Datadictionary entities themselves.

Additional Information:

For more information about using the above Datadictionary functions, please refer to the following Guides for your version:

CA Datacom/DB version 14.02 Datadictionary Online Reference Guide 

• Section DBMAINT Mode - DATACOM/DB Structure Maintenance > Catalog a DATABASE Structure

CA Datacom/DB version 14.02 Datadictionary Batch Reference Guide 

• Section DDCFBLD - Cataloging CA Datacom Datadictionary Definitions 
• Section DDUPDATE - Updating Datadictionary > 1000 CATALOG Transaction 

 

CA Datacom/DB version 15.00 Datadictionary Online Reference Guide 

• Section DBMAINT Mode - DATACOM/DB Structure > Catalog a DATABASE Structure Maintenance

CA Datacom/DB version 15.00 Datadictionary Batch Reference Guide 

• Section DDCFBLD - Cataloging CA Datacom Datadictionary Definitions 
• Section DDUPDATE - Updating Datadictionary > 1000 CATALOG Transaction 

 

As always, please contact CA Technologies support for CA Datacom if you have further questions.

Environment

Release:
Component: DB