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

book

Article ID: 36093

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- 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 

CA Datacom/DB version 14.02 Datadictionary Batch Reference Guide 

 

CA Datacom/DB version 15.00 Datadictionary Online Reference Guide 

CA Datacom/DB version 15.00 Datadictionary Batch Reference Guide 

 

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

Environment

Release:
Component: DB