DCMT DISPLAY DBTABLE Command

DCMT DISPLAY DBTABLE displays the database name table associated with the current DC/UCF system and lists each group defined in the table and its status.
idmscu19
DCMT DISPLAY DBTABLE displays the database name table associated with the current DC/UCF system and lists each group defined in the table and its status.
This article describes the following information:
Syntax
►►─ DCMT ─┬───────────────────┬─ Display DBTable ───────────────────────────►◄           └─ 
broadcast-parms
 ─┘
Parameter
  • broadcast-parms
    Indicates to execute the DCMT command on all or a list of data sharing group members.
    For more information about broadcasting and
    broadcast-parms
    syntax, see the section How to Broadcast System Tasks.
Usage
Information displayed is for the current DC/UCF system, and includes:
  • DBTABLE name
  • Name of the subschema associated with the DBTABLE
  • For each database defined in the DBTABLE:
    • Indication of whether requests for subschemas not found in the table are allowed (DEFAULT) or disallowed (ALWAYS)
    • Subschema name mapping
  • For each segment defined in a DBNAME: the number of times a BIND RUN UNIT was executed
  • DBGROUP name and startup status
Example
DCMT DISPLAY DBTABLE
      DISPLAY DBTABLE  *** DBTABLE RnnnDBTB                 COMPILED yy-mm-dd AT 05.18.48 ***  DBNAME *DEFAULT MATCH ON SUBSCHEMA IS OPTIONAL      SUBSCHEMA IDMSNWK? MAPS TO IDMSNWK? USING DBNAME SYSDICT      SUBSCHEMA IDMSCAT? MAPS TO IDMSCAT? USING DBNAME SYSDICT      SUBSCHEMA EMPSS??  MAPS TO EMPSS??  USING DBNAME EMPDEMO  DBNAME DBCR     MATCH ON SUBSCHEMA IS OPTIONAL          SEGMENT CATSYS                  0 BIND count          SEGMENT DBCR                    0 BIND count          SEGMENT SYSDICT                 0 BIND count          SEGMENT SYSMSG                  0 BIND count  DBNAME EMPDEMO  MATCH ON SUBSCHEMA IS OPTIONAL          SEGMENT EMPDEMO                69 BIND count  DBNAME SYSDICT  MATCH ON SUBSCHEMA IS OPTIONAL          SEGMENT APPLDICT              722 BIND count          SEGMENT SYSMSG                310 BIND count          SEGMENT SYSSQL                398 BIND count  DBNAME SYSDIRL  MATCH ON SUBSCHEMA IS OPTIONAL          SEGMENT SYSDIRL                45 BIND count          SEGMENT SYSMSG                 12 BIND count  DBNAME SYSTEM   MATCH ON SUBSCHEMA IS OPTIONAL          SEGMENT CATSYS                  0 BIND count          SEGMENT SYSMSG                  0 BIND count          SEGMENT SYSTEM                 37 BIND count  DBGROUP DCRGROUP ENABLED
More Information
  • For more information about database name tables, see the
    Navigational DML Administrating section
    .
  • For more information about defining database name tables to a system, see documentation of the system generation DBNAME statement in the
    Administrating section
    .