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). |
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 |
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 |
Note: 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 |
Note: 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. |
Note: 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.
More Information
|
Copyright © 2014 CA.
All rights reserved.
|
|