Datacom Dynamic System Tables DST list

book

Article ID: 48924

calendar_today

Updated On:

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



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

Environment

z/OS
z/VSE
 

Resolution

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