How to find the keys for a CA Datacom table

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

There is often a need to see the keys associated with a table, along with the fields in that key. The information is readily available from CA SYSVIEW, and from a CXX (Directory) report or a Datadictionary report.

Environment

Release: DBCISF00200-15.1-Datacom-Database-Option for CICS Services
Component:

Resolution

To see the definition for a key in CA SYSVIEW, the easiest method is to:

1. Issue the ASID mufname command to set the focus on this MUF;
2. Issue the DCKEYS ### command for the DBID you are interested in reviewing;
3. Beside the key you want to see, enter the FIE line command. This will present the DCKEYFLD listing of that key.

To see the field definition for all the keys in a DBID, you can

1. Issue the ASID mufname command to set the focus on this MUF;
2. Issue the DCKEYFLD ### command for the DBID. This will present the DCKEYFLD screen, showing all the tables and keys in the DBID, along with the fields that make up each key.

 

For a CXX report, you can run a DBUTLTY step using the CXX report function:                              

//SYSIN    DD *
  REPORT AREA=CXX,DBID=###
/*

The CXX report will list all the keys (with their fields) for a table following each table's detailed information.

 

For the Datadictionary report, you can use the DDUTILTY program with this input:

//SYSIN     DD *                      
-USR DATACOM-INSTALL,NEWUSER            
-DEF PATH,PATH1                          
-DEF TRACE,TABLE.KEY,$INTERNAL          
-END                                    
-RPT START,TABLE,<your table name>(PROD),PATH1      
-RPT INDENT                              
-RPT NEST,KEY                            
-RPT FIELD                              
-RPT NESTEND                            
-END                                    
/*                                       

This will list only the particular table you want, using the full table occurrence name, not the short ID. It will list all the keys for that table, along with the definition of the fields that make up that key.

Additional Information

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

***