Previous Topic: DCMT DISPLAY DATABASE Command ParametersNext Topic: DCMT DISPLAY DATA SHARING Command


Example: DCMT DISPLAY DATABASE Command

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