TPDC Manual (G06.24+)
Table Of Contents
- What’s New in This Manual
- About This Manual
- 1 TPDC Overview
- TPDC Components and Architecture
- Tandem Performance Data Collector (TPDC)
- Tandem Performance System File Label (TPSFL)
- Tandem Performance File Label (TPFL)
- Tandem Performance Load Measure (TPLM)
- Tandem Performance Load Data (TPLD)
- System Performance Analysis Using Measure (SPAM)
- Tandem Performance Deferred Processing (TPDP)
- Data Files (RWS, DWS, UWS)
- How TPDC Collects Data
- Example: Scheduling TPDC Data Collection
- TPDC Components and Architecture
- 2 Installing and Running TPDC
- 3 Using the Collected Data
- 4 Using the System Configuration Reports
- 5 Using the SPAM Performance Data Charts and Reports
- Overview of the Charts and Reports
- Performance Data Charts
- Acceleration Profiles of User Programs (AXLCHRT)
- Apportioned Program CPU Consumption (WKLOAD)
- Average CPU Utilization (ACUCHRT)
- Average Disc Utilization (ADUCHRT)
- Data Communications Line Overview (DATACOM)
- Disc Cache Performance (DCPCHRT)
- Disc File Block Splits Shares (BLKSPLT)
- Disc File I/O Activity Distribution (DFIODST)
- Disc File Overview (Alphabetic) (DFOATBL)
- Disc File Physical I/O Shares (DFPIOS)
- Disc File ‘Requests Blocked’ Shares (REQBLKD)
- Disc File System I/O Shares (DFSIOS)
- Disc I/Os per Second (DIOCHRT)
- Disc Response Time (DRTCHRT)
- EXPAND Communications Line Overview (EXPAND)
- Global Indicators (COVER)
- Logical Disc File I/O Wait Shares (LDFIOWT)
- SQL/MP Program Overview (SQLPROG)
- SQL/MP Statement Overview (SQLSTAT)
- Process Category Counts (PCOUNTS)
- Process/CPU Priority Distribution (PRIDIST)
- Program Disc File I/O Wait Shares (PGDIOWT)
- Program Logical File Open Shares (PGOPENS)
- Program Logical I/O Wait Shares (PGLIOWT)
- Program Overview (PGOVIEW)
- Program Spooler File I/O Wait Shares (PGSPLWT)
- Relative CPU Balance (RCBCHRT)
- Relative Disc Balance (RDBCHRT)
- TMF Overview (TMFVIEW)
- Performance Data Reports
- Busiest Disc Files (Logical I/O Wait Time, Overall) (IOWOVER)
- Busiest Disc Files (Logical I/Os, by Volume) (LIOBVOL)
- Busiest Disc Files (Physical I/Os, by Volume) (PIOBVOL)
- Busiest Disc Files (System I/Os, by Volume) (SIOBVOL)
- Busiest Processes (by CPU) (PBSYCPU)
- CPU Activity (CPUREPT)
- Disc Cache 1 (Activity, by Block Size) (CACHE1)
- Disc Process Activity (DPREPT)
- Disc Subsystem Activity (DSCREPT)
- EXPAND Network Line Activity (NETREPT)
- Global Indicators (COVER)
- Low Selectivity (Needle in a Haystack) SQL Table Access Report (HAYSTCK)
- Network System Activity (SYSREPT)
- New Process Creation Timeline (NEWPROC)
- PATHWAY System Processes (PATHWAY)
- Physical Disc I/O Activity (PDISCIO)
- Process Existence Timeline (PTIMLIN)
- Process Memory Utilization (by CPU) (PMEMCPU)
- Process Page Faults (by CPU) (PFLTCPU)
- Server Summary (from $RECEIVE File) (SERVICE)
- TMF Activity Report (TMFREPT)
- A Entity and Attribute Definitions
- B Cross-Reference of Enform Queries to Data Files
- C Enform Query Source File (QPGROUPS)
- Index

Using the SPAM Performance Data Charts and
Reports
Tandem Performance Data Collector (TPDC) Manual—526357-001
5-62
Disc Subsystem Activity (DSCREPT)
DISC SUBSYSTEM Activity Report for System \CSO (Release D20)
------------------------------
$Volume LDV RQ:sec IQlen IQmsec Blkd % (headings continued below)
======== === ------ ------ ------ ------
(1) (2) (3) (4) (5) (6)
<--- CACHE:RQ ----> <--------- BUSY % --------> <--- I/Os PER REQUEST ---->
Hit Miss Flt ABF PPID PCU Total Read Write Seek Total Read Write Seek
---- ---- ---- ---- ------ ---- ------ ------ ------ ------ ------ ------ ------ ------
(7) (8) (9) (10) (11) (12) (13) (14) (15) (16) (17) (18) (19) (20)
THIS REPORT SHOWS DISC SUBSYSTEM ACTIVITY OVER THE MEASUREMENT INTERVAL (WINDOW). FOR THE PURPOSES
OF THIS REPORT A DISC SUBSYSTEM IS COMPOSED OF DISC PROCESSES (INCLUDING DISC CACHE) AND THE
PHYSICAL DISC DEVICE(S) THAT COMPRISE A LOGICAL VOLUME; THE LEFT HALF OF THE REPORT SHOWS DISC
PROCESS AND DISC CACHE ACTIVITY, WHILE THE RIGHT HALF OF THEREPORT SHOWS PHYSICAL DISC ACTIVITY.
(1) The disc volume name. (7)-(10) (cont.)
(2) The Logical Device Number of the disc volume. (9) The average number of times per request that
cache tables indicated that a needed block was
(3) The average number of requests for service in cache, but the Memory Manager had 'stolen'
received per second. the underlying memory for another purpose,
aggregated over all cache block sizes. This
(4) The average number of requests for service typically indicates either too large a cache
on the the Disc Processes' 'internal' queue. size, or too little real memory for the CPU.
(5) The average time in milliseconds that (10) The average number of times per request that
requests for service spent in the Disc the Disc Process had to write to the TMF audit
Processes’ 'internal' queue. trail volume before it could write a 'dirty'
cache block and so free that block for another
(6) The percentage of requests for service that use, aggregated over all cache block sizes.
encountered record or file locks (and were This value should be close to zero.
therefore impeded from further forward
progress until locks were released). This (11) The <cpu>,<pin> of the primary Disc Process.
value tends to show a strong positive
correlation to both (4) and (5), above. (12) The Controller # and Unit # of the disc(s)
under control of the primary Disc Process.
(7) A group of columns showing the key Disc
thru Cache activities per request for service (13) The percentage of the window that the disc
(10) received by the Disc Processes: thru was busy, in total (13) and in each activity:
(16) reading (14), writing (15) and seeking (16).
(7) The average number of times per request
that a required block was found in cache (17) thru (20)
on a read or buffered write operation,
aggregated over all cache block sizes; The average number of I/O operations per
each ‘hit’ saves a disc I/O. request for service, in total (17) and in each
activity: reads (18), writes (19) and seeks
(8) The average number of times per request that (20).
a required block was not found in cache on
a read operation, aggregated over all cache
block sizes; each 'miss' causes a disc I/O.
Not all disc requests go through the Disc For mirrored volumes, there is a line in the
Cache (for example, writes to TMF audit right half of the report for each of the physical
trails bypass the cache). discs that comprise the volume; zero values are
suppressed.