PMARPT36 contains one page of detailed wait statistics per task execution.
Note: To minimize output, always run this report with explicit selection criteria.
Sample report
REPORT NO. 36 CA, INC. mm/dd/yy PAGE 1 CA IDMS/PM nn.n volser TASKWAIT DETAIL REPORT DC SYSTEM VERSION #: 72 <-------------- YOUR COMPANY NAME --------------> DATA FROM: mm/dd/yy TASK: DBCRUPD TASKID: 277 START TIME: 5:36:56 --DBIO READ -- --JOURNAL READ -- --SCRATCH READ -- --LOG READ -- WAITS 10 80 WAIT TIME .2762 .5240 AVG TIME .0276 .0066 HIGHEST TIME .0956 .0126 --DBIO WRITE-- --JOURNAL WRITE-- --SCRATCH WRITE-- --LOG WRITE-- WAITS 1 2 WAIT TIME .0009 .0140 AVG TIME .0009 .0070 HIGHEST TIME .0009 .0122 --DOS PRIOR IO-- --JOURNAL BUFFER-- --SCR SINGLE THRD-- --LOG SINGLE THRD-- WAITS 3 1 WAIT TIME .3338 .0053 AVG TIME .1113 .0053 HIGHEST TIME .2613 .0053 --DB BUFFER -- --PGM LOADS -- --QUEUE READ -- --LOG FULL -- WAITS WAIT TIME AVG TIME HIGHEST TIME --DBKEYS -- --LOADER SNGL THRD-- --QUEUE WRITE-- --EXTERNAL RU-- WAITS 1 WAIT TIME 1.5239 AVG TIME 1.5239 HIGHEST TIME 1.5239 --AREA ACCESS-- --DDS WRITES -- --TP READS-- --OTHER EXTRNL-- WAITS WAIT TIME AVG TIME HIGHEST TIME --STORAGE POOL -- --CHECKUSER -- --TP WRITES-- --OTHER INTRNL-- WAITS WAIT TIME AVG TIME HIGHEST TIME --PROGRAM POOL -- --DBGROUP -- --SHARED CACHE -- WAITS 8 WAIT TIME .0051 AVG TIME .0006 HIGHEST TIME .0006 DBKey Wait Record(s) for this TaskID Area PgGrp DBKey-Page Line Holder Type Hold.TskID DBCR.BRNCHTEL 15 684538 1 DBCRUPD TASK 274
PMARPT36 fields
|
Field |
Description |
|---|---|
|
Task |
Task code or CA ADS dialog name |
|
Taskid |
Sequential number assigned to the task at task initiation (also known as the task ID) |
|
Start Time |
Time the task was initiated (hh:mm:ss) |
|
DBIO Read |
Waits, wait time, average wait time, and highest wait time for database reads performed by or on behalf of the task |
|
Journal Read |
Waits, wait time, average wait time, and highest wait time for journal reads performed by or on behalf of the task (usually for rollback) |
|
Scratch Read |
Waits, wait time, average wait time, and highest wait time for scratch area reads performed by or on behalf of the task |
|
Log Read |
Waits, wait time, average wait time, and highest wait time for log area reads performed by or on behalf of the task |
|
DBIO Write |
Waits, wait time, average wait time, and highest wait time for database writes performed by or on behalf of the task |
|
Journal Write |
Waits, wait time, average wait time, and highest wait time for journal writes performed by or on behalf of the task |
|
Scratch Write |
Waits, wait time, average wait time, and highest wait time for scratch area writes performed by or on behalf of the task |
|
Log Write |
Waits, wait time, average wait time, and highest wait time for log area writes performed by or on behalf of the task |
|
DOS Prior IO |
Waits, wait time, average wait time, and highest wait time for prior I/O to complete (z/VSE only) |
|
Journal Buffer |
Waits, wait time, average wait time, and highest wait time because of full journal buffer (can indicate too few pages assigned to journal buffer) |
|
Scr Singl Thrd |
Waits, wait time, average wait time, and highest wait time for the scratch manager to finish single-threaded processing |
|
Log Single Thrd |
Waits, wait time, average wait time, and highest wait time for the log to finish single-threaded processing (if happening because of task or systems snaps, isolate and correct) |
|
DB Buffer |
Waits, wait time, average wait time, and highest wait time for database buffers |
|
Pgm Loads |
Waits, wait time, average wait time, and highest wait time for programs to be loaded by or on behalf of the task |
|
Queue Read |
Waits, wait time, average wait time, and highest wait time for queue area reads performed by or on behalf of the task |
|
Log Full |
Waits, wait time, average wait time, and highest wait time because log either full or being unloaded (frequent waits can indicate a problem with the log) |
|
DBkeys |
Waits, wait time, average wait time, and highest wait time for db-key waits (consistently high numbers can indicate a problem). Details on DBkeys are shown just behind all wait types. |
|
Loader Sngl Thrd |
Waits, wait time, average wait time, and highest wait time for the loader to finish single-threaded processing |
|
Queue Write |
Waits, wait time, average wait time, and highest wait time for queue writes issued by or on behalf of the task |
|
External RU |
Waits, wait time, average wait time, and highest wait time for external request units |
|
Area Access |
Waits, wait time, average wait time, and highest wait time for access to an area (check usage mode in this and other concurrently running programs) |
|
DDS Writes |
Waits, wait time, average wait time, and highest wait time for DDS I/O issued by or on behalf of the task |
|
TP Reads |
Waits, wait time, average wait time, and highest wait time for terminal writes |
|
Other Extrnl |
Waits, wait time, average wait time, and highest wait time for other meaningful external wait types, including the ICE, LRE, and user ECBs |
|
Storage Pool |
Waits, wait time, average wait time, and highest wait time to acquire storage for the task |
|
Checkuser |
Waits, wait time, average wait time, and highest wait time for an available check user subtask (z/OS batch external run units only) |
|
TP Writes |
Waits, wait time, average wait time, and highest wait time for terminal writes |
|
Other Intrnl |
Waits, wait time, average wait time, and highest wait time for other meaningful internal wait types, including ENQUEUE, DEQUEUE, LTE, PDE, and TCE |
|
Program Pool |
Waits, wait time, average wait time, and highest wait time for access to a program or reentrant pool |
|
DBGroup |
Waits, wait time, average wait time, and highest wait time for a request issued from a front-end CV that want to start a database session, to get an answer from a back-end CV that volunteers to service the request |
|
Shared Cache |
Waits, wait time, average wait time, and highest wait time for a shared cache from the Coupling Facility |
If waits on DBKeys occur, details about the DBKeys are shown.
|
Field |
Description |
|---|---|
|
Area |
The DBKey's area name. |
|
PgGrp |
The DBKey's page group. |
|
DBKey-Page |
The DBKey's page number. |
|
Line |
The DBKey's line index. |
|
Holder |
The name of the holder of the DBKey lock. |
|
Type |
The type (TASK, LTE, or DDS) of the Holder field. |
|
Hold.TskID |
The task ID of the holder of the DBKey lock. |
|
Copyright © 2014 CA.
All rights reserved.
|
|