DCMT DISPLAY DATABASE Command

DCMT DISPLAY DATABASE displays database information associated with your DC/UCF system. You can also use the keywords DB and DATA BASE (DAta base) as synonyms for DATABASE.
idmscu19
DCMT DISPLAY DATABASE displays database information associated with your DC/UCF system. You can also use the keywords DB and DATA BASE (DAta base) as synonyms for DATABASE.
This command displays the same information displayed by 
all
 of the following commands (each discussed as separate alphabetic entries in this section):
  • DCMT DISPLAY AREA
  • DCMT DISPLAY BUFFER
  • DCMT DISPLAY CHANGE TRACKING
  • DCMT DISPLAY FILE
  • DCMT DISPLAY JOURNAL
  • DCMT DISPLAY TRANSACTION
DCMT DISPLAY DATABASE also displays the time and date the DMCL was generated.
Syntax
►►─── DCMT ─┬───────────────────┬─────────────────────────────────────────────► └─
broadcast-parms
─┘ ►─── Display ─┬─ DATABase ──┬────────────────────────────────────────────────►◄ ├─ DB ────────┤ └─ DAta base ─┘
Parameters
  •  
    broadcast-parms
    Indicates to execute the DCMT command on all or a list of data sharing group members.
Example
 
DCMT DISPLAY DATABASE
 
D DATABASE Task / LTE Trans-ID Pri Orig Module SS/AM St Stat Date:Time 2 13871 253 LOC RHDCRUAL IDMSNWK7 RW H 2007-08-03-10.25.31.8359 2 13872 253 LOC RHDCRUAL IDMSNWK7 RW A 2007-08-03-10.25.31.8363 3 13874 253 LOC RHDCRUAL IDMSNWKL RW A 2007-08-03-10.25.31.8390 3 13875 253 LOC RHDCRUAL IDMSNWKL RW A 2007-08-03-10.25.31.8714 4 13877 253 LOC RHDCRUAL IDMSNWK6 RO A 2007-08-03-10.25.31.8754 4 13878 253 LOC RHDCRUAL IDMSNWK6 RO A 2007-08-03-10.25.31.8755 5 13879 253 LOC RHDCRUAL IDMSSECU RO A 2007-08-03-10.25.31.8783 5 13880 253 LOC RHDCRUAL IDMSSECU RO A 2007-08-03-10.25.31.9021 6 13881 253 LOC RHDCRUAL IDMSNWK8 RO A 2007-08-03-10.25.31.9054 6 13882 253 LOC RHDCRUAL IDMSNWK8 RO A 2007-08-03-10.25.31.9402 7 13883 253 LOC RHDCRUAL IDMSSECS RO A 2007-08-03-10.25.31.9440 7 13884 253 LOC RHDCRUAL IDMSSECS RO A 2007-08-03-10.25.31.9823 8 13885 253 LOC RHDCLGSD IDMSNWK9 RO A 2007-08-03-10.25.31.9860 9 13886 253 LOC RHDCLGSD IDMSNWK9 RO A 2007-08-03-10.25.32.3585 10 13887 253 LOC RHDCLGSD IDMSNWK9 RO A 2007-08-03-10.25.32.3614 ---------- Area ----------- Lock Lo-Page Hi-Page #Ret #Upd #Tret #Ntfy APPLDICT.DDLDML Upd 60001 62000 0 0 0 0 Stamp: 2005-09-02-09.17.48.016148 Pg grp: 0 NoShare NoICVI NoPerm APPLDICT.DDLDCLOD Upd 70001 70500 0 2 0 0 Stamp: 2005-09-02-09.17.48.076602 Pg grp: 0 NoShare NoICVI NoPerm
CATSYS.DDLCAT Upd 1 800 0 0 0 0 Stamp: 2005-09-02-09.17.48.119428 Pg grp: 0 NoShare NoICVI NoPerm CATSYS.DDLCATX Upd 801 900 0 0 0 0 Stamp: 2005-09-02-09.17.48.122000 Pg grp: 0 NoShare NoICVI NoPerm CATSYS.DDLCATLOD Upd 901 950 0 0 0 0 Stamp: 2005-09-02-09.17.48.135827 Pg grp: 0 NoShare NoICVI NoPerm EMPDEMO.EMP-DEMO-REGION Ret 75001 75100 0 0 0 0 Stamp: 2005-09-02-09.17.48.275820 Pg grp: 0 NoShare NoICVI NoPerm EMPDEMO.INS-DEMO-REGION Ret 75101 75150 0 0 0 0 Stamp: 2005-09-02-09.17.48.279585 Pg grp: 0 NoShare NoICVI NoPerm EMPDEMO.ORG-DEMO-REGION Ret 75151 75200 0 0 0 0 Stamp: 2005-09-02-09.17.48.284697 Pg grp: 0 NoShare NoICVI NoPerm PROJSEG.PROJAREA Ret 77401 77450 0 0 0 0 Stamp: 2005-09-02-09.17.48.314472 Pg grp: 0 NoShare NoICVI NoPerm SYSLOC.DDLOCSCR Ofl 55001 58000 0 0 0 0 Stamp: 2005-09-02-09.17.51.682263 Pg grp: 0 NoShare NoICVI NoPerm SYSMSG.DDLDCMSG Ret 10001 13000 2 0 0 0 Stamp: 2005-09-02-09.17.51.842801 Pg grp: 0 NoShare NoICVI NoPerm SYSSQL.DDLCAT Ret 20001 22000 0 0 0 0 Stamp: 2005-09-02-09.17.51.921426 Pg grp: 0 NoShare NoICVI NoPerm SYSSQL.DDLCATLOD Ret 25001 25500 0 0 0 0 Stamp: 2005-09-02-09.17.51.977031 Pg grp: 0 NoShare NoICVI NoPerm SYSSQL.DDLCATX Ret 28001 28500 0 0 0 0 Stamp: 2005-09-02-09.17.52.072560 Pg grp: 0 NoShare NoICVI NoPerm SYSTEM.DDLDML Ret 1001 2000 4 0 0 0 Stamp: 2005-09-02-09.17.52.259765 Pg grp: 0 NoShare NoICVI NoPerm SYSTEM.DDLDCLOD Ret 3001 3100 0 0 0 0 Stamp: 2005-09-02-09.17.52.282452 Pg grp: 0 NoShare NoICVI NoPerm SYSTEM.DDLDCLOG Ret 30001 34000 3 0 0 0 Stamp: 2005-09-02-09.17.52.326821 Pg grp: 0 NoShare NoICVI NoPerm SYSTEM.DDLDCRUN Upd 40001 41000 0 2 0 0 Stamp: 2005-09-02-09.17.52.343245 Pg grp: 0 Share ICVI NoPerm
SYSTEM.DDLDCSCR N/av 50001 53000 0 0 0 0 Stamp: 2005-09-02-09.17.52.430493 Pg grp: 0 NoShare NoICVI NoPerm SYSUSER.DDLSEC Ret 48001 48500 2 0 0 0 Stamp: 2005-09-02-09.17.52.646727 Pg grp: 0 NoShare NoICVI NoPerm --- Data Buffer -- Size In-use Max Getstg Prfetch-Min Prefetch REO2-BUFFER 4276 Not Open 0 OPSYS DBCR_BRCH_BUFFER 4000 Not Open 0 OPSYS DBCR_ACCT_BUFFER 2932 Not Open 0 OPSYS LOG_BUFFER 4276 Not Open 0 OPSYS SCR_BUFFER 2676 Not Open 0 OPSYS DEFAULT_BUFFER 4276 30 60 OPSYS 500 Not-Allowd - Journal Buffer - Size # In-Use Waits DB Ckpt JNL_BUFFER 2004 128 0 0 1 # of Recoveries I/O's in Buffer 0 0 0 Waits on Prior IO Forced IO: Deadlock Split 0 0 0 -------- Data File -------- Mode Stat Pg-Size Fl-Type M-Cache S-Cache DD-Name APPLDICT.DICTDB Upd 0 4276 non-VSAM Yes No DICTDB Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 VOLSER: CULL05 DSname: (DMCL).. DBDC.SYSTEM72.APPLDICT.DDLDML DISP=SHR APPLDICT.DLODDB Upd 0 4276 non-VSAM No No DLODDB Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 VOLSER: CULL05 DSname: (DMCL).. DBDC.SYSTEM72.APPLDICT.DDLDCLOD DISP=SHR CATSYS.DCCAT Upd 0 4276 non-VSAM No No DCCAT Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 VOLSER: CULL05 DSname: (DMCL).. DBDC.SYSTEM72.CATSYS.DCCAT DISP=SHR CATSYS.DCCATL Upd 0 4276 non-VSAM No No DCCATL Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 VOLSER: CULL05 DSname: (DMCL).. DBDC.SYSTEM72.CATSYS.DCCATLOD DISP=SHR CATSYS.DCCATX Upd 0 4276 non-VSAM No No DCCATX Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 VOLSER: CULL05 DSname: (DMCL).. DBDC.SYSTEM72.CATSYS.DCCATX DISP=SHR EMPDEMO.EMPDEMO Clos 0 4276 non-VSAM No No EMPDEMO Pre-fetch: Not-Allowed (DMCL) UNALLOCATED DSname: (DMCL).. DBDC.SYSTEM72.EMPDEMO.EMPDEMO DISP=SHR EMPDEMO.INSDEMO Clos 0 4276 non-VSAM No No INSDEMO Pre-fetch: Not-Allowed (DMCL) UNALLOCATED DSname: (DMCL).. DBDC.SYSTEM72.EMPDEMO.INSDEMO DISP=SHR
EMPDEMO.ORGDEMO Clos 0 4276 non-VSAM No No ORGDEMO Pre-fetch: Not-Allowed (DMCL) UNALLOCATED DSname: (DMCL).. DBDC.SYSTEM72.EMPDEMO.ORGDEMO DISP=SHR PROJSEG.PROJDEMO Clos 0 4276 non-VSAM No No PROJDEMO Pre-fetch: Not-Allowed (DMCL) UNALLOCATED DSname: (DMCL).. DBDC.SYSTEM72.PROJSEG.PROJDEMO DISP=SHR SYSLOC.DCLSCR Clos 0 2676 non-VSAM No No DCLSCR Pre-fetch: Not-Allowed (DMCL) UNALLOCATED SYSMSG.DCMSG Ret 0 4276 non-VSAM No No DCMSG Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 VOLSER: CULL06 DSname: (DMCL).. DBDC.SQL.DDLDCMSG DISP=SHR SYSSQL.SQLDD Clos 0 4276 non-VSAM No No SQLDD Pre-fetch: Not-Allowed (DMCL) UNALLOCATED DSname: (DMCL).. DBDC.SYSTEM72.SYSSQL.DDLCAT DISP=SHR SYSSQL.SQLXDD Clos 0 4276 non-VSAM No No SQLXDD Pre-fetch: Not-Allowed (DMCL) UNALLOCATED DSname: (DMCL).. DBDC.SYSTEM72.SYSSQL.DDLCATX DISP=SHR SYSSQL.SQLLOD Clos 0 4276 non-VSAM No No SQLLOD Pre-fetch: Not-Allowed (DMCL) UNALLO CATED DSname: (DMCL).. DBDC.SYSTEM72.SYSSQL.DDLCATL DISP=SHR SYSTEM.DCDML Ret 0 4276 non-VSAM No No DCDML Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 VOLSER: CULL05 DSname: (DMCL).. DBDC.SYSTEM72.SYSTEM.DDLDML DISP=SHR SYSTEM.DCLOD Clos 0 4276 non-VSAM No No DCLOD Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 UNALLOCATED DSname: (DMCL).. DBDC.SYSTEM72.SYSTEM.DDLDCLOD DISP=SHR SYSTEM.DCLOG Upd 0 4276 non-VSAM No No DCLOG Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 VOLSER: CULL05 DSname: (DMCL).. DBDC.SYSTEM72.SYSTEM.DDLDCLOG DISP=SHR SYSTEM.DCRUN Upd 0 2676 non-VSAM No Yes DCRUN Pre-fetch: Not-Allowed (DMCL) Pages per Track 17 VOLSER: CULL06 DSname: (DMCL).. DBDC.SYSTEM72.SYSTEM.DDLDCRUN DISP=SHR Cache-name: IDMSCACHE00002 SYSTEM.DCSCR Clos 0 2676 non-VSAM No No DCSCR Pre-fetch: Not-Allowed (DMCL) UNALLOCATED DSname: (DMCL).. DBDC.SYSTEM72.SYSTEM.DDLDCSCR DISP=SHR
SYSUSER.SECDD Ret 0 4276 non-VSAM No No SECDD Pre-fetch: Not-Allowed (DMCL) Pages per Track 11 VOLSER: CULL05 DSname: (DMCL).. DBDC.SYSTEM72.SYSUSER.DDLSEC DISP=SHR ------ Journal File ------- MODE Stat Pg-Size Fl-Type M-Cache S-Cache DD-Name J1JRNL Upd 0 2004 non-VSAM No No J1JRNL Pages per Track 21 VOLSER: CULL05 DSname: (JCL)... DBDC.SYSTEM72.J1JRNL DISP=SHR J2JRNL Upd 0 2004 non-VSAM No No J 2JRNL Pages per Track 21 VOLSER: CULL05 DSname: (JCL)... DBDC.SYSTEM72.J2JRNL DISP=SHR J3JRNL Upd 0 2004 non-VSAM No No J3JRNL Pages per Track 21 VOLSER: CULL05 DSname: (JCL)... DBDC.SYSTEM72.J3JRNL DISP=SHR J4JRNL Upd 0 2004 non-VSAM No No J4JRNL Pages per Track 21 VOLSER: CULL05 DSname: (JCL)... DBDC.SYSTEM72.J4JRNL DISP=SHR SYSJRNL Clos 0 8000 non-VSAM No No SYSJRNL Disk Journal Segno LoRBN HiRBN NxRBN Ful Act Rcv Arc Stat DsRBN DsINTV Tql J1JRNL 1 8 5000 3854 NO YES NO NO 0 4373 520 4 J2JRNL 0 8 5000 ****** NO NO NO NO 0 J3JRNL 0 8 5000 ****** NO NO NO NO 0 J4JRNL 0 8 5000 ****** NO NO NO NO 0 Change Tracking - Status Delete PageCnt Target-FileCnt Actual-FileCnt Not used
 
More Information
 
For more information about broadcasting and 
broadcast-parms
 syntax, see the section How to Broadcast System Tasks.
For more information about creating and generating the DMCL load module, see documentation of the CREATE DMCL and GENERATE DMCL statements in the 
Database Administration documentation
.