PMARPT17 contains one line for each task showing database statistics.
Sample report
REPORT NO. 17 CA, INC. mm/dd/yy PAGE 1 CA IDMS/PM nn.n volser DATABASE DETAIL REPORT DC SYSTEM VERSION #: 71 <-------------- YOUR COMPANY NAME --------------> DATA FROM: mm/dd/yy RECS CALC CALC VIA VIA SELECT UPDATE TASK VER TASK TASK CURR RECS PAGES PAGES PAGES RECS RECS RECS RECS FRAGS LOCKS LOCKS CODE NUM NUM TYPE OF RQSTD RQSTD READ WRITTEN NO WITH NO WITH STORED OF OF R/U OFLOW OFLOW OFLOW OFLOW R/U R/U QUED 0 18 ASSEM 3 7 1005 1002 0 0 0 0 0 0 0 0 CLOD 0 19 ASSEM 23 50 26 10 0 0 0 0 0 0 0 0 FACTOTUM 1 20 ASSEM 0 0 0 0 0 0 0 0 0 0 0 0 FACTOTUM 1 21 ASSEM 0 0 0 0 0 0 0 0 0 0 0 0 S 0 22 ASSEM 3 7 6 3 0 0 0 0 0 0 0 0 FACTOTUM 1 23 ASSEM 0 1 1 1 0 0 0 0 0 0 0 0 C 0 24 ASSEM 3 7 4 1 0 0 0 0 0 0 0 0 FACTOTUM 1 25 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 26 ASSEM 3 4 3 1 0 0 0 0 0 0 0 0 FACTOTUM 1 27 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 28 ASSEM 3 4 3 1 0 0 0 0 0 0 0 0 FACTOTUM 1 29 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 30 ASSEM 3 5 3 1 0 0 0 0 0 0 0 0 FACTOTUM 1 31 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 32 ASSEM 3 4 3 1 0 0 0 0 0 0 0 0 FACTOTUM 1 33 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 34 ASSEM 3 7 3 1 0 0 0 0 0 0 0 0 FACTOTUM 1 35 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 36 ASSEM 3 7 3 0 0 0 0 0 0 0 0 0 FACTOTUM 1 37 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 38 ASSEM 3 7 3 0 0 0 0 0 0 0 0 0 FACTOTUM 1 39 ASSEM 0 0 0 0 0 0 0 0 0 0 0 0 FACTOTUM 1 40 ASSEM 0 0 0 0 0 0 0 0 0 0 0 0 FACTOTUM 1 41 ASSEM 0 0 0 0 0 0 0 0 0 0 0 0 C 0 42 ASSEM 3 9 4 1 0 0 0 0 0 0 0 0 FACTOTUM 1 43 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 44 ASSEM 3 5 3 1 0 0 0 0 0 0 0 0 FACTOTUM 1 45 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 46 ASSEM 3 4 3 1 0 0 0 0 0 0 0 0 FACTOTUM 1 47 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 48 ASSEM 3 4 3 1 0 0 0 0 0 0 0 0 FACTOTUM 1 49 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 50 ASSEM 3 5 3 1 0 0 0 0 0 0 0 0 FACTOTUM 1 51 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 52 ASSEM 3 7 3 0 0 0 0 0 0 0 0 0 FACTOTUM 1 53 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 54 ASSEM 3 7 3 0 0 0 0 0 0 0 0 0 FACTOTUM 1 55 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 56 ASSEM 3 7 3 0 0 0 0 0 0 0 0 0 FACTOTUM 1 57 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 58 ASSEM 0 0 0 0 0 0 0 0 0 0 0 0 HELOT 0 59 SYSTM 0 0 0 2 0 0 0 0 0 0 0 0 FACTOTUM 1 60 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 61 ASSEM 0 0 0 0 0 0 0 0 0 0 0 0 FACTOTUM 1 62 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 63 ASSEM 0 0 0 0 0 0 0 0 0 0 0 0 FACTOTUM 1 64 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0 DCMT 0 65 ASSEM 0 0 0 0 0 0 0 0 0 0 0 0 FACTOTUM 1 66 ASSEM 2 2 2 0 0 0 0 0 0 0 0 0
PMARPT17 fields
|
Field |
Description |
|---|---|
|
Task Code |
Task code or CA ADS dialog name |
|
Ver Num |
Version number of the level-1 program executed for the task |
|
Task Num |
Sequential number assigned to the task at task initiation (also known as the task ID) |
|
Task Type |
Source language for the level-1 program for the task (ERUS for an external request unit) |
|
Recs Curr of R/U |
Number of records that became current of run unit as a result of FIND, STORE, or OBTAIN requests |
|
Recs Rqstd |
Number of records retrieved from the database as a result of processing requests issued by the run unit |
|
Pages Rqstd |
Number of pages requested by the DBMS for the run unit |
|
Pages Read |
Number of pages physically read on behalf of the run unit |
|
Pages Written |
Number of physical writes that occurred while the task was in control |
|
CALC Recs No Oflow |
Number of records stored using the CALC location mode that were stored on the target page |
|
CALC Recs With Oflow |
Number of records stored using the CALC location mode that were stored on a page other than the target page |
|
VIA Recs No Oflow |
Number of records stored using the VIA location mode that were stored on the target page |
|
VIA Recs With Oflow |
Number of records stored using the VIA location mode that were stored on a page other than the target page |
|
Frags Stored |
Number of record fragments stored |
|
Select Locks Of R/U |
Number of select locks held by the task |
|
Update Locks Of R/U |
Number of update locks held by the task |
|
Copyright © 2014 CA.
All rights reserved.
|
|