Previous Topic: DCMT DISPLAY STATISTICS Command ParametersNext Topic: DCMT DISPLAY STATISTICS Command Usage


Example: DCMT DISPLAY STATISTICS Command

DCMT DISPLAY STATISTICS INTERVAL

DISPLAY STATISTICS INTERVAL STATISTICS INTERVAL IS 21600

DCMT DISPLAY STATISTICS ROLL

DISPLAY STATISTICS ROLL *** Display Statistics Interval Roll details *** Last Statistics Roll 2010-08-23-02.45.00.812033 Last Issued By SYSTEM TASK Interval Roll Time 02:45 Day Frequency 7

DCMT DISPLAY STATISTICS SYSTEM

D STAT SYS 05:39:10.90 10/209 Current Time 00:00:02.737832 Tot System Time 03:30:05.12 10/209 Startup Time 00:00:00.085707 Tot User Time 00:00:00.739173 zIIP on zIIP Time 00:00:00.001095 zIIP on CP Time TASKS: 356 Processed 53 Abended 72 Max Tasks 208 System 0 Runaway 0 Times At Max 0 Deadlocks 0 Dead Victims TRANS: 138 Processed 122 Norm Cmp 14 Max Conc 14 Ext Proc 14 Ext Norm 1 Ext Conc 25 Max Erus 0 Dist Proc 0 Dist Norm 0 Dist Conc DATABASE: 37323 Calls 26993 Pages Rqst 38753 Recs Rqst 0 Buff Wait 3148 Pages Read 15586 Recs Cur R/U 683 Page Writ 138 Calc Noflo 663 Via Noflo 33131 Tot Locks 57 Calc Ovflo 67 Via Ovflo 0 Frag Stord 0 Recs Reloc INDEX: 5 SR8 Splits 199 SR8 Stores 12 SR7 Stores 0 SR8 Spawns 199 SR8 Erases 12 SR7 Erases 0 Orph Adopt 708 Ix Searches 1 Min Level 1187 Lvls Srchd 2 Max Level

PAGE 00001 - NEXT PAGE:

SQL: 523 Commands 353 Tupls Fetched 41 Rows Inserted 0 AM Recomp 3 Rows Updated 0 Rows Deleted 27 Sorts 1 Sort Min 97 Tuples Sorted 6 Sort Max JOURNAL: 0 Buff Waits 0 User Putjrnl Page 34 0-10 16 11-20 40 21-30 18 31-40 17 41-50 Dist 3 51-60 17 61-70 13 71-80 2 81-90 157 91-100 INTERNAL: RLEs RCEs DPEs Stack 559 515 400 1067 HWM 4000 3000 1500 2400 Sysgen Threshold 0 0 0 Times Exceeded STORAGE: 41569 Gets 40805 Frees Gets for type 0 PGFIXs 0 PGFREEs 6,711 DB 0 Pages Fxd 0 Pages Freed 22 SHK 33875 Scan 1 0 PGRLSEs 0 SHR 7694 Scan 2 0 Pages Relsd 25,652 SYS 23 USK 0 SOS COUNT 9,161 USR PROGRAM: Act Loads Pages Load Wait/Space

PAGE 00002 - NEXT PAGE:

Non-Reent 0 0 0 Reent 29 855 0 XA Non-Reent 0 0 0 XA Reent 180 23775 0 SCRATCH: 350 Gets 380 Puts 316 Dels QUEUE: 266 Gets 0 Puts 0 Dels 0 Task AutoSt TIME: 11739 Gets 2603 Post 4 Started Tasks 1 Wait 2601 Canc

USERS: 0 Signed on 5 HWM V214 ENTER NEXT TASK CODE: CA IDMS release 18.0 tape GJI00B node SYSQA14

DCMT DISPLAY STATISTICS AREAS

DISPLAY STATISTICS AREAS ---------- Area ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes AEDB.AE-AREA 0 1 0 1 AEDB.AE-INDEX-AREA 0 1 0 1 AEDB.AE-AREA2 0 1 0 1 AEDB.AE-INDEX-AREA2 0 1 0 1 AEDB.AE-AREA3 0 1 0 1 AEDB.AE-AREA4 0 1 0 1 AEDB.AETEST-AREA 0 1 0 1 AEDB.AEQC-REC-REGION 0 1 0 1 AEDB.AEQC-PIX-REGION 0 1 0 1 AEDB.AEQC-A1IX-REGION 0 1 0 1 AEDB.AEQC-A2IX-REGION 0 1 0 1 AEDB.AEQC-A3IX-REGION 0 1 0 1 AEDB.AEQC-A4IX-REGION 0 1 0 1 AEDB.AEQC-A5IX-REGION 0 1 0 1 AEDICT.DDLDML 17 5 0 1 AEDICT.DDLDCLOD 0 3 0 1 ASFDICT.DDLDML 14 5 0 1 ASFDICT.DDLDCLOD 0 3 0 1 ASFDICT.IDMSR-AREA 0 1 0 1 ASFDICT.IDMSR-AREA2 0 1 0 1 CATSYS.DDLCAT 2 3 0 1 PAGE 001 - NEXT PAGE:

DCMT DISPLAY STATISTICS AREA area-id

DISPLAY STATISTICS AREA EMPDICT.DDLDML ---------- Area ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes EMPDICT.DDLDML 4 3 0 1

DCMT DISPLAY STATISTICS AREA area-id FILE

DISPLAY STATISTICS AREA EMPDICT.DDLDML FILE ---------- Area ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes EMPDICT.DDLDML 4 3 0 1 ---------- File ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes EMPDICT.EMPDICT 4 3 0 1

DCMT DISPLAY STATISTICS AREA area-id BUFFER

DISPLAY STATISTICS AREA EMPDICT.DDLDML BUFFER ---------- Area ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes EMPDICT.DDLDML 4 3 0 1 ----- Buffer ----- Waits Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes DEFAULT_BUFFER 0 951 90 0 21

DCMT DISPLAY STATISTICS AREA area-id ALL

DISPLAY STATISTICS AREA EMPDICT.DDLDML ALL ---------- Area ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes EMPDICT.DDLDML 4 3 0 1 ---------- File ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes EMPDICT.EMPDICT 4 3 0 1 ----- Buffer ----- Waits Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes DEFAULT_BUFFER 0 951 90 0 21

DCMT DISPLAY STATISTICS BUFFERS

DISPLAY STATISTICS BUFFERS ----- Buffer ----- Waits Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes EDB_BUFFER 0 27 10 0 2 EGEN_BUFFER 0 21 10 0 2 DEFAULT_BUFFER 0 951 90 0 21 BUFFER_4276 0 29 30 0 12 SCRATCH_BUFFER 0 1580 1004 0 4 LOG_BUFFER 0 0 0 0 0 AE_BUFFER 0 17 22 0 16 LOD_BUFFER 0 0 12 0 4

DCMT DISPLAY STATISTICS BUFFER buffer-name

DISPLAY STATISTICS BUFFER LOG_BUFFER ----- Buffer ----- Waits Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes LOG_BUFFER 0 0 0 0 0

DCMT DISPLAY STATISTICS BUFFER buffer-name AREA

DISPLAY STATISTICS BUFFER SCRATCH_BUFFER AREA ----- Buffer ----- Waits Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes SCRATCH_BUFFER 0 1580 1004 0 4 ---------- Area ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes SYSDEF.DDLDCRUN 1580 1003 0 3 SYSDEF.DDLDCSCR 0 1 0 1 SYSLSCR.DDLOCSCR 0 0 0 0

DCMT DISPLAY STATISTICS BUFFER buffer-name FILE

DISPLAY STATISTICS BUFFER SCRATCH_BUFFER FILE ----- Buffer ----- Waits Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes SCRATCH_BUFFER 0 1580 1004 0 4 ---------- File ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes SYSDEF.DCRUN 1580 1003 0 3 SYSDEF.DCSCR 0 1 0 1 SYSLSCR.DCLSCR 0 0 0 0

DCMT DISPLAY STATISTICS BUFFER buffer-name ALL

DISPLAY STATISTICS BUFFER SCRATCH_BUFFER ALL ----- Buffer ----- Waits Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes SCRATCH_BUFFER 0 1580 1004 0 4 ---------- Area ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes SYSDEF.DDLDCRUN 1580 1003 0 3 SYSDEF.DDLDCSCR 0 1 0 1 SYSLSCR.DDLOCSCR 0 0 0 0 ---------- File ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes SYSDEF.DCRUN 1580 1003 0 3 SYSDEF.DCSCR 0 1 0 1 SYSLSCR.DCLSCR 0 0 0 0

DCMT DISPLAY STATISTICS FILES

DISPLAY STATISTICS FILES ---------- File ----------- Fnd-in-Buf Phy-Reads Fnd-in-Cache Phy-Writes AEDB.CAEDB1 0 2 0 2 AEDB.CAEDB2 0 2 0 2 AEDB.CAEDB3 0 1 0 1 AEDB.CAEDB4 0 1 0 1 AEDB.AETEST 0 1 0 1 AEDB.AEQDB 0 7 0 7 AEDICT.AEDICT 17 5 0 1 AEDICT.AEDLOD 0 3 0 1 ASFDICT.ASFDML 14 5 0 1 ASFDICT.ASFLOD 0 3 0 1 ASFDICT.ASFDEFN 0 1 0 1 ASFDICT.ASFDATA 0 1 0 1 CATSYS.DCCAT 2 3 0 1 CATSYS.DCCATL 0 3 0 1 CATSYS.DCCATX 0 1 0 1 EGENDB.EGENDEMO 0 1 0 1 EGENDICT.EGENDICT 21 7 0 1 EGENDICT.EGENLOD 0 3 0 1 EMPDEMO.EMPDEMO 0 1 0 1 EMPDEMO.INSDEMO 0 1 0 1 EMPDEMO.ORGDEMO 0 1 0 1 PAGE 001 - NEXT PAGE: