Datacom Dynamic System Tables DST list

Document ID : KB000048924
Last Modified Date : 03/05/2018
Show Technical Document Details
Question:

Where is the list of CA Datacom Dynamic System Tables (DST) and where are they documented? 

Environment:
z/OS
z/VSE
 
Answer:

Full documentation for the CA Datacom Dynamic System Tables (DST) can be found in CA Datacom Core - 15.1 section “Dynamic System Tables"
https://docops.ca.com/ca-datacom/15-1/en/reference/system-tables-reference/dynamic-system-tables

Here is the list of the Dynamic System Tables (DST).:

Directory (CXX) Related Tables

The following Dynamic System Tables (DST) provide access the Directory (CXX) related data.

DIR_AREA (DRA)
DIR_COLUMN (DRC)
DIR_DATABASE (DRB)
DIR_DATASET (DRZ)
DIR_DIRECTORY (DRD)
DIR_ELEMENT (DRE)
DIR_INDEX (DRI)
DIR_KEY (DRK)
DIR_KEY_FIELD (DRF)
DIR_PART_COLUMNS (DRP)
DIR_TABLE (DRT)
DIR_VOLUMES (DRV)

Multi-User Facility Related Tables​

System Statistical Information

The following tables exist to provide data equivalent to the PXX system statistics.

MUF_AREA_STATS (MFA)
MUF_SYSTEMS_STATS (MSS)
MUF_TABLE_STATS (MFT)

Startup Option Information

MUF_ACCESS (MFZ)
MUF_ACCOUNTING (MFY)
MUF_CDC (MCD)
MUF_CDC_BASE_TABLE (MCT)
MUF_CDCL (MCL)
MUF_CONFIG (MCF)
MUF_COVEREDVIRTUAL (MFC)
MUF_OPTIONS (MFO)
MUF_PRODUCTS (MFP)
MUF_RC_DUMP_OPT (MDO)
MUF-SYSOUT (MFG)
MUF_XCF (MFX)

Other Information

MUF_ACCESS_AREA (MFN)
MUF_ACTIVE_TASKS (MFQ)
MUF_BUF_USE (MBU)
MUF_CBS (MCB)
MUF_CBS_OLD_SETS (MCO)
MUF-DATA_SHARING (MFD)
MUF_IDENTITY (MFI)
MUF_INTERNAL_STATS (MFV)
MUF_LOCKS_VALUE (MFK)
MUF_LOGGING (MFL)
MUF_MEM_DETAIL (MMD)
MUF_MEM_SUMMARY (MMS)
MUF_ML_DUMPS_PREV (MFF)
MUF_ML_DUMPS_PXX (MFE)
MUF_OPEN_BASES (MFB)
MUF_RATES (MFR)
MUF_RETURN_CODES (MFU)
MUF_SMP_STATS (MFW)
MUF_SMP_TASK (MFM)
MUF_SRB_ZIIP (MZI)
MUF_TCB_OR_SRB (MTC)

SQL Tables​

SQL Maintenance Table

This DST provides a way of issuing maintenance commands to Dynamic System Tables.

SQL_CONSOLE (SQX)

SQL Sequence Table

This DST provides a way of generating a unique ascending sequence number.

SQL_X_SEQUENCE (SQE)

SQL Status Tables

SQL_MISC_STATS (SQM)
SQL_PROC_DETAIL (SQZ) 15
SQL_SQLCODES (SQQ)
SQL_STATUS (SQS)
SQL_STATUS_CURRENT (SQC)
SQL_STATUS_PLAN (SQP)
SQL_STATUS_SEGMENT (SQG)
SQL_STATUS_FRONT (SQF)
SQL_STATUS_URT (SQU)

SQL Cache Tables

SQLSC_FACILITY (SCF)
SQLSC_PLAN (SCP)
SQLSC_ENTRY (SCE)
SQLSC_VERSION (SCV)
SQLSC_METRICS (SCM)

Schema Information Tables (SIT)

SYSCONSTRDEP (CND)
SYSCONSTROBJ (CNO)
SYSCONSTRSRC (CNS)
SYSVIEWDEP (VWD)

CA Datacom Server Tables - SRV_CLNTINFO (SRC)

Additional Information:
For full details, refer to  CA Datacom Core - 15.1 section “Dynamic System Tables" and its sub-sections
https://docops.ca.com/ca-datacom/15-1/en/reference/system-tables-reference/dynamic-system-tables