Datacom Dynamic System Tables DST list

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

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

Resolution

The Datacom Dynamic System Tables (DST) can be found in the Datacom Core - 15.1 documentation section “Dynamic System Tables"

A list of tables as of October 2024 can be seen below. Refer to the documentation for any updates to the DST's

Directory (CXX) Related Tables:

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:
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
SQL_CONSOLE (SQX)\

SQL Sequence Table
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)

SQL Schema Information Tables (SIT):
SYSCONSTRDEP (CND)
SYSCONSTROBJ (CNO)
SYSCONSTRSRC (CNS)
SYSVIEWDEP (VWD)

Datacom Server Tables:
SRV_CLNTINFO (SRC)