DCMT DISPLAY STATISTICS Command

The DCMT DISPLAY STATISTICS command displays:
idmscu19
The DCMT DISPLAY STATISTICS command displays:
  • The interval at which statistics are written to the log file.
  • The interval at which statistics are written to the log file and rolled out.
  • Current DC/UCF system statistics.
  • Specific statistics on database page reads and writes for areas, buffers, and files.
  • The number of times a read request was fulfilled by a page that was already in the buffer. No I/O occurs for this type of read request.
DC/UCF gathers the statistics from active control blocks, not from the system log.
This article describes the following information:
 
 
Syntax
►►─── DCMT ─┬───────────────────┬─────────────────────────────────────────────► └─
broadcast-parms
─┘ ►─── Display STAtistics ─────────────────────────────────────────────────────► ►─┬─ INterval ───────────────────────────────────────────────────────┬──────►◄ ├─ ROLl ─────────────────────────────────────────────────────────┤ ├─ SYStem ─────────────────────────────────────────────────────────┤ ├─ ARea ─┬─
segment-name
.
area-name
─┬──────────┬──┬───────────┬──┬─┤ │ │ ├─ File ───┤ └─ MCAche ──┘ │ │ │ │ ├─ Buffer ─┤ │ │ │ │ └─ All ────┘ │ │ │ └─
area-star-name
───────────────────────┬───────────┬──┘ │ | └─ MCAche ──┘ | ├─ AReas ──┬────────┬──────────────────────────────────────────────┤ │ └─MCAche─┘ │ ├─ Buffer ─┬─
buffer-name
─┬────────┬─────┬───────────┬──────────┬─┤ │ │ ├─ ARea ─┤ └─ MCAche ──┘ │ │ │ │ ├─ File ─┤ │ │ │ │ └─ ALl ──┘ │ │ │ └─
buffer-star-name
──────────────┬───────────┬───────┘ │ | └─ MCAche ──┘ | ├─ Buffers ┬────────┬──────────────────────────────────────────────┤ │ └─MCAche─┘ │ ├─ File ─┬─
segment-name
.
file-name
─┬──────────┬──┬───────────┬──┬─┤ │ │ ├─ ARea ───┤ └─ MCAche ──┘ │ │ │ │ ├─ Buffer ─┤ │ │ │ │ └─ ALl ────┘ │ │ │ └─
file-star-name
──────────────────┬───────────┬───────┘ │ | └─ MCAche ──┘ | ├─ Files ──┬────────┬──────────────────────────────────────────────┤ │ └─MCAche─┘ │ └─ MQ ───┬────────────────────────┬────────────────────────────────┘ └ QUEues ─┬──────────────┤ └─ queue-name ─┘
Parameters
  • 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.
  • INterval
    Displays the current statistics interval, in seconds. If statistics are not collected at a specified interval, OFF is shown.
  • ROLl 
    Displays the time date stamp of the last performed interval roll and the issuer of the request - either RHDCSROL system task or the user by DCMT WRITE STATISTICS ROLL command, the time of day in twenty-four hour format (HH:MM) and day frequency at which system-wide statistics are written to the log and reset to zero.
  • SYStem
    Displays system statistics.
  • Area
    Displays database I/O statistics for a specified area.
    • segment-name
       
      The name of the segment with which the area is associated.
    • area-name
       
      The name of the area.
    • File
      Displays database I/O statistics for files associated with the specified area.
    • Buffer
      Displays database I/O statistics for buffers associated with the specified area.
    • All
      Displays database I/O statistics for files and buffers associated with the specified area.
    • area-star-name
       
      Displays database I/O statistics for all areas whose names begin with the same specified alphanumeric characters. 
      Area-star-name
       specifies any alphanumeric description that ends with an asterisk (*) to denote wild card characters.
    • MCAche
      Displays statistics for the number of pages in the cache buffer that are read, the number of times a page is found in the cache, how often the oldest cache buffer is reused to store a new page,  and the number of reused buffers that were never read.
    Examples
    In this example, CA IDMS displays statistics about all areas associated with segments that begin with EMP:
    dcmt d sta a emp*
    In this example, CA IDMS displays statistics about all areas in the EMPLOYEE segment with area names that begin with the letter H:
    dcmt d sta a employee.h*
    • Areas
      Displays database I/O statistics for all areas.
    • BUFfer
      Displays database I/O statistics for a specified database buffer.
      • buffer-name
         
        The name of a database buffer.
      • Area
        Displays database I/O statistics for all areas associated with the specified buffer.
      • File
        Displays database I/O statistics for all files associated with the specified buffer.
      • All
        Displays database I/O statistics for all files and areas associated with the specified buffer.
      • buffer-star-name
         
        Displays database I/O statistics for all buffers whose names begin with the same specified alphanumeric characters.
        Buffer-star-name
         specifies any alphanumeric description that ends with an asterisk (*) to denote wildcard characters. In this example, CA IDMS displays statistics about all buffers whose names begin with the letters RKN:
    dcmt d sta buf rkn*
    • Buffers
      Displays database I/O statistics for all database buffers. 
    • File
      Displays database I/O statistics for a specified database file.
      • segment-name
         
        The segment with which the file is associated.
      • file-name
         
        The name of the file.
      • Area
        Displays database I/O statistics for all areas associated with the specified file.
      • Buffer
        Displays database I/O statistics for the buffer associated with the specified file.
      • All
        Displays database I/O statistics for the area(s) and buffer associated with the specified file. 
      • file-star-name
         
        Displays database I/O statistics for all files whose names begin with the same specified alphanumeric characters.
        File-star-name
         specifies any alphanumeric description that ends with an asterisk (*) to denote wild card characters.
    In this example, CA IDMS displays statistics about all files that begin with the notation FILE1:
    dcmt d sta file file1*
    • Files
      Displays database I/O statistics for all files. 
    • MQ
      Displays MQ statistics for the system
    • MQ Queues
      Displays MQ statistics for the system and statistics for each queue that has been accessed by the system
    • MQ Queue queue-name
      Displays statistics for the named queue
      • queue-name
         
        The name of the queue.
    In this example, CA IDMS displays statistics for a named queue:
    dcmt d sta mq que SYSTEM.DEFAULT.LOCAL.QUEUE
    Usage
    Interval Statistics
     
    DCMT DISPLAY STATISTICS INTERVAL displays the statistics interval in seconds.
    Time Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following system time statistics:
    Field
     
    Value
     
    Current Time
    The current time of day, the year, and the day of the year
    Startup Time
    The most recent time (specified by time of day, year, and day of the year) the DC/UCF system was started
    Tot Sys Time
    Total system time This is the total amount of time spent in system execution mode (accurate to the nearest hundredths of a second).
    Tot User Time
    Total user time. This is the total amount of time spent in user execution mode (accurate to hundredths of a second).
    zIIP-Enabled Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following system statistics when zIIP support is enabled.
    Field
     
    Value
     
    zIIP on zIIP Time
    The CPU time consumed while physically executing on a zIIP processor.
    zIIP on CP Time
    The system mode CPU time consumed on a CP because zIIP is unavailable.
    Number of Swaps
    Count of swaps.
    A SWAP is the process of moving the CPU processing from a GP (General Processor) also referred to as (CP) to a zIIP specialty engine. The SWAP also occurs in the reverse process of moving CPU processing from the zIIP specialty Engine to the general processor. 
    For more information about enabling and using zIIP support, see DCMT VARY ZIIP.
    Task Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following task statistics:
    Field
     
    Value
     
    Processed
    Total number of tasks processed since DC/UCF startup
    System
    Total number of system tasks processed
    Abended
    Number of tasks abended
    Runaway
    Number of runaway tasks abended (that is, tasks abnormally terminated by DC/UCF because they exceeded the runaway task time)
    Max Tasks
    Maximum number of concurrently active user tasks allowed, as specified at system generation time by the MAXIMUM TASKS parameter of the SYSTEM statement
    Times at max
    Number of times the system has reached the maximum tasks limit
    Deadlocks
    Number of deadlocks detected since DC/UCF started up
    Dead Victims
    Number of tasks abended by the system to solve deadlock situation
    Database Transaction Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following database transaction statistics:
    Field
     
    Value
     
    Processed
    Total number of internal and online database transactions processed since DC/UCF startup
    Ext Proc
    Total number of external transactions (external request units) processed since DC/UCF startup
    Norm Cmp
    Total number of internal and online transactions that ended normally
    Ext Norm
    Total number of external transactions that ended normally
    Max Conc
    Maximum number of concurrently active internal and online transactions since DC/UCF startup
    Ext Conc
    Maximum number of concurrently active external transactions since DC/UCF startup
    Max Erus
    Maximum number of request units allowed
    Database Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following database statistics:
    Field
     
    Value
     
    Calls
    Number of calls to CA IDMS
    Buff Wait
    Number of times a page had to wait for space in the buffer
    Pages Writ
    Number of pages written
    Pages Rqst
    Number of pages requested
    Read
    Number of pages read
    Calc Noflo
    Number of CALC records stored on their target page
    Calc Ovflo
    Number of CALC records stored on another page due to overflow
    Frag Stord
    Number of record fragments stored
    Recs Requested
    Number of records requested and relocated
    Recs Cur R/U
    Number of records current of the run unit
    Via Noflo
    Number of Via records (CLUSTERED rows) stored on their target page
    Via Ovflo
    Number of Via records (CLUSTERED rows) stored on another page due to overflow
    Recs Reloc
    Number of records relocated
    Tot Locks
    Total number of locks that have already been acquired
    Index Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following index statistics:
    Field
     
    Value
     
    SR8 Splits
    Number of SR8 record splits
    SR8 Spawns
    Number of SR8 record spawns
    Orph Adopt
    Number of orphans adopted
    SR8 Stores
    Number of SR8 records stored
    SR8 Erases
    Number of SR8 records erased
    Ix Searches
    Number of indexes searched
    Lvls Srchd
    Number of index levels searched
    SR7 Stores
    Number of SR7 records stored
    SR7 Erases
    Number of SR7 records erased
    Min Levels
    Minimum number of index levels searched
    Max Levels
    Maximum number of index levels searched
    SQL Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following SQL statistics:
    Field
     
    Value
     
    Commands
    Number of SQL commands executed
    AM Recomp
    Number of access modules recompiled
    Tupls Fetched
    Number of rows fetched from SQL tables
    Rows Updated
    Number of rows updated in SQL tables
    Sorts
    Number of sorts performed on SQL tables
    Tuples Sorted
    Number of rows sorted from SQL tables
    Rows inserted
    Number of rows inserted in SQL tables
    Rows deleted
    Number of rows deleted from SQL tables
    Sort Min
    Minimum number of rows sorted from one SQL table
    Sort Max
    Maximum number of rows sorted from one SQL table
    Journal Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following journal statistics:
    Field
     
    Value
     
    Buff Waits
    Number of waits that have occurred for journal buffers
    User Putjrnl
    Number of times a user program has requested that a record be written to the journal file (for example, with a WRITE JOURNAL or #PUTJRNL command)
    Page Dist
    Distribution of number of pages per write to the journal
    Internal Performance Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following internal performance statistics for resource link elements (RLE), resource control elements (RCE), deadlock prevention elements (DPE), and the task control element stack (Stack):
    Field
     
    Value
     
    HWM
    Number of times the high-water mark has been reached for the element
    Sysgen Threshold
    Number of RLEs, RCEs, DPEs, and task control elements defined in the system generation SYSTEM statement
    Times Exceeded
    Number of times the above system generation threshold has been exceeded at runtime
    Storage Pool Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays storage pool statistics for all storage pools defined at system generation:
    Field
     
    Value
     
    Gets
    Number of #GETSTG requests issued
    PGFIXs
    Number of page fixes issued at runtime
    Pages Fxd
    Number of storage pages fixed
    Scan1
    Number of times that a request for storage was satisfied on the first scan of a storage pool
    Scan2
    Number of times that a request for storage was satisfied on the second scan of a storage pool
    Frees
    Number of #FREESTG requests issued
    PGFREEs
    Number of page frees issued
    Pages Freed
    Number of storage pages freed at runtime
    PGRLSEs
    Number of page releases issued
    Pages Relsd
    Number of storage pages released
    SOS Count
    Number of times storage pool 0 went short on storage (SOS), causing the system to become SOS
    Gets for type
    Number of #GETSTG requests issued for the different storage types.
     
    Program Pool Usage Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM provides a separate set of program pool usage statistics for nonreentrant, reentrant, and XA reentrant pools:
    Field
     
    Value
     
    Act Loads
    Total number of programs loaded into the pool
    Pages Load
    Pages allocated in the pool to satisfy the programs loaded in that pool
    Wait/Space
    Number of times that DC/UCF had to wait for space in a pool
     
    Scratch Area Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM provides the following scratch area statistics:
    Field
     
    Value
     
    Gets
    Number of GET requests issued
    Puts
    Number of PUT requests issued
    Dels
    Number of DELETE requests issued
    Queue Area Statistics for System
     
    DCMT DISPLAY STATISTICS SYSTEM displays the following queue area statistics:
    Field
     
    Value
     
    Gets
    Number of GET requests issued
    Puts
    Number of PUT requests issued
    Dels
    Number of DELETE requests issued
    Task AutoSt
    Number of tasks started as a result of reaching a queue threshold
    GET/SET TIME Statistics for System
     
    DCMT DISPLAY STATISTICS displays the following time area statistics:
    Field
     
    Value
     
    Gets
    Number of GET TIME requests
    Wait
    Number of SET TIME WAIT requests
    Post
    Number of SET TIME POST requests
    Canc
    Number of SET TIME CANCEL requests
    Started Tasks
    Number of SET TIME START TASK requests
     
    MQ Statistics 
     
    DCMT DISPLAY STATISTICS SYSTEM displays MQ statistics for the system and statistics for each queue that has been accessed by the system:
    Field
    Value
    Total MQI calls
    Number of calls to MQI 
    Total MQ calls
    Number of calls to IBM MQ
    MQOPENs
    Number of MQOPEN commands issued
    MQCLOSEs
    Number of MQCLOSE commands issued 
    MQPUTs
    Number of MQPUT and MQPUT1 commands issued 
    MQGETs
    Number of MQGET commands issued 
    Subtask HWM
    High-water mark for concurrent subtask use
    Subtask Threshold
    Number of utility subtasks available
    Subtask Times Exceeded 
    Number of times a subtask is unavailable
    When CA IDMS MQ queue statistics are requested, the following fields display:
    Field
    Value
    QUEUE
    Heading for queue name list
    The name of each queue is displayed followed by these statistics
    Queue MQOPENs
    Number of MQOPEN commands issued
    Queue CLOSEs
    Number of MQCLOSE commands issued 
    Queue MQPUTs
    Number of MQPUT and MQPUT1 commands issued 
    Queue MQGETs
    Number of MQGET commands issued 
     
    Statistics for a Specified Area
     
    DCMT DISPLAY STATISTICS AREA displays the following statistics for the specified area(s):
    Field
     
    Value
     
    AREA
    The name of the area
    Fnd-in-Buf
    The number of pages of the area that have been requested and found to be already present in the DB buffer
    Phy-Reads
    The number of pages read from disk
    Phy-writes
    The number of pages of the area that have been actually written
    Fnd-in-Cache
    The number of pages of the area requested for which no I/O was initiated because the page was already present in an ESA dataspace or in a shared cache
    When the 
    MCACHE
     option is used for 64-bit memory caching, the following fields are displayed:
    Field
     
    Value
     
    Cache_reads
    Number of reads issued to the cache.
    Fnd_in_Cache
    The number of pages requested that could not be found in a DB buffer, but are in an ESA dataspace or in a shared cache.
    Cbf-Reused
    Cache Buffer Reused:
    Shows how often the oldest cache buffer is reused to store a new page.
    Cbf-Unread
    Cache Buffer Unread: Shows the number of reused buffers that were never read. When a Cache Buffer is reused and no page in the cache buffer was read, the Cache Buffer Unread count is incremented.
    If you specify BUFFER, FILE, or ALL, you receive information on the associated buffer(s), file(s), or both. See the description of buffer information and/or file information for further documentation.
    Statistics for a Specified Buffer
     
    DCMT DISPLAY STATISTICS BUFFER displays the following statistics for the specified buffer(s):
    Field
     
    Value
     
    Buffer
    The name of the buffer
    Waits
    The number of times all buffers were locked when buffer access was requested
    Fnd-in-Buf
    The number of pages that have been requested and found to be already present in the buffer
    Phy-Reads
    The number of pages that have had to be read because they were not found in the buffer
    Fnd-in-Cache
    The number of pages requested that could not be found in a DB buffer, but are in an ESA dataspace or in a shared cache.
    Phy-Writes
    The number of pages of the pool that have been actually written
    If you specify AREA, FILE, or ALL, you receive information on the associated area(s), file(s), or both. See the description of area information and/or file information for further documentation.
     
    Statistics for a Specified File
     
    DCMT DISPLAY STATISTICS FILE displays the following statistics for the specified file(s):
    Field
     
    Value
     
    File
    The name of the file
    Fnd-in-Buf
    The number of pages of the file that have had to be read because they were not found in a buffer.
    Phy-Reads
    The number of pages of the file that have had to be read because they were not found in a buffer. Includes the value in the FND-IN-CACHE; for a specific file, you can compare the value in the FND-IN-CACHE to the number of physical reads to see how efficiently a cache is being used.
    Fnd-in-Cache
    The number of pages of the file requested for which no I/O was initiated because the page was already present in an ESA dataspace or in a shared cache.
    Phy-Writes
    The number of pages of the file that have been actually written.
     If you specify AREA, BUFFER, or ALL, receive information on the associated area(s), buffer(s), or both. See the description of area information and/or buffer information for further documentation.
    Examples
     
    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
     
    DCMT D STATISTICS SYSTEM 14:22:21.41 18/365 Current Time 00:00.650244 Tot System Time 14:20:52.62 18/365 Startup Time 00:00.002290 Tot User Time 00:00:00.032274 zIIP on zIIP Time 00:00:00.000000 zIIP on CP Time 8,004 Number of Swaps TASKS: 134 Processed 0 Abended 69 Max Tasks 116 System 0 Runaway 0 Times At Max 0 Deadlocks 0 Dead Victims TRANS: 46 Processed 37 Norm Cmp 18 Max Conc 5 Ext Proc 4 Ext Norm 1 Ext Conc 25 Max Erus 0 Dist Proc 0 Dist Norm 0 Dist Conc DATABASE: 1106 Calls 2453 Pages Rqst 881 Recs Rqst 0 Buff Wait 2089 Pages Read 365 Recs Cur R/U 0 Page Writ 0 Calc Noflo 0 Via Noflo 189 Tot Locks 0 Calc Ovflo 0 Via Ovflo 0 Frag Stord 0 Recs Reloc INDEX: 0 SR8 Splits 0 SR8 Stores 0 SR7 Stores 0 SR8 Spawns 0 SR8 Erases 0 SR7 Erases 0 Orph Adopt 0 Ix Searches 0 Min Level 0 Lvls Srchd 0 Max Level SQL: 0 Commands 0 Tupls Fetched 0 Rows Inserted 0 AM Recomp 3 Rows Updated 0 Rows Deleted 0 Sorts 0 Sort Min 0 Tuples Sorted 0 Sort Max JOURNAL: 0 Buff Waits 0 User Putjrnl Page 0 0-10 0 11-20 0 21-30 0 31-40 0 41-50 Dist 0 51-60 0 61-70 0 71-80 0 81-90 0 91-100 INTERNAL: RLEs RCEs DPEs Stack 510 440 412 1061 HWM 4000 3000 1500 2400 Sysgen Threshold 0 0 0 Times Exceeded STORAGE: 2115 Gets 1852 Frees Gets for type 0 PGFIXs 0 PGFREEs 399 DB 0 Pages Fxd 0 Pages Freed 19 SHK 1416 Scan 1 0 PGRLSEs 0 SHR 702 Scan 2 0 Pages Relsd 1,051 SYS 3 USK 0 SOS COUNT 647 USR PROGRAM: Act Loads Pages Load Wait/Space Non-Reent 0 0 0 Reent 30 844 0 XA Non-Reent 0 0 0 XA Reent 151 24698 0 SCRATCH: 67 Gets 117 Puts 67 Dels QUEUE: 7 Gets 0 Puts 0 Dels 0 Task AutoSt TIME: 1773 Gets 21 Post 1 Started Tasks 0 Wait 17 Canc USERS: 1 Signed on 6 HWM MQ: 22 Total MQI calls 20 Total MQ calls 10 MQOPENs 4 MQCLOSEs 4 MQPUTs 0 MQGETs Subtasks 4 HWM 4 Threshold 6 Times Exceeded
     
    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 ALL MCACHE
    DISPLAY STATISTICS AREA DBCR.BRNCHTEL ALL MCACHE ---------- Area ------------ Cache-Reads Fnd-in-Cache Cbf-reused Cbf-Unread DBCR.BRNCHTEL 1 1 0 0 ---------- File ------------ Cache-Reads Fnd-in-Cache Cbf-reused Cbf-Unread DBCR.BRANCHA 1 1 0 0 DBCR.BRANCHB 0 0 0 0 DBCR.BRANCHC 0 0 0 0 DBCR.BRANCHD 0 0 0 0 ---------- Buffer ---------- Cache-Reads Fnd-in-Cache Cbf-reused Cbf-Unread DEFAULT_BUFFER 1 1 0 0
     
    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:
     
    DCMT DISPLAY STATISTICS MQ QUEUES
     
    DISPLAY STATISTICS MQ QUEUES MQ: 7 Total MQI calls 6 Total MQ calls 1 MQOPENs 1 MQCLOSEs 1 MQPUTs 2 MQGETs Subtasks 1 HWM 4 Threshold 0 Times Exceeded Queue MQT2.WORK.QUEUE 1 MQOPENs 1 MQCLOSEs 1 MQPUTs 2 MQGETs