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-60
Disc Process Activity (DPREPT)
DISC PROCESS Activity Report for System \CSO (Release D20)
----------------------------
$Volume LDV PC:BC (headings continued below)
======== === -----
(1) (2) (3)
<---MILLISECONDS/REQUEST---> <--------RESOURCE BUSY (%)-------->
<--PER SEC-->
Rqsts/ <Q/SERVICE(MSECS)> <Disc Process(es)> <Disc Process(es)> <---Discs---> Swap Free
Second ExtrnlIntrnl Total Primry Backup Total Discs Primry Backup Total Primry Mirror I/Os I/Os
------ ------ ------ ----- ------ ------ ----- ----- ------ ------ ----- ------ ------ ---- ----
(4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16) (17) (18)
THIS REPORT SHOWS THE OVERALL ACTIVITY OF (9) The average number of CPU milliseconds
DISC PROCESSES DURING THE MEASUREMENT consumed by the backup Disc Process(es) per
INTERVAL (WINDOW). IT ALSO INCLUDES SOME request for service.
MINIMAL INFORMATION ON THE ASSOCIATED
PHYSICAL DISCS. (10) The sum of (8) and (9).
THE REPORT SHOWS ONLY DISC PROCESSES (11) The average number of DISC milliseconds
THAT RECEIVED AT LEAST 0.10 REQUESTS FOR consumed per request for service. The reported
SERVICE PER SECOND. value takes into account whether the volume is
mirrored or unmirrored and, for mirrored volumes,
attempts to account for serial versus parallel
(1) The disc volume name. writes. If controller path switches occurred
during the measurement window, this latter
(2) The Logical Device Number of the disc volume. adjustment may not be accurate.
(3) The Disc Process' primary and backup CPU (12) The percentage of the measurement window that the
numbers. primary Disc Processes were using their CPU.
(4) The average number of requests for (13) The percentage of the measurement window that the
service received per second. backup Disc Processes were using their CPU.
(5) The average time, in milliseconds, that (14) The sum of (12) and (13).
requests for service spent in the Disc
Process' EXTERNAL queue (i.e. before a (15) The percentage of the measurement window that the
Disc Process read the request). primary disc drive was busy seeking, reading or
writing.
(6) The average time, in milliseconds, that
requests for service spent in the Disc (16) The percentage of the measurement window that the
Process' INTERNAL queue, after having mirror disc drive (if any) was busy seeking,
been read from the external queue; this reading or writing.
time includes both queueing and service
times. (17) The average number of I/O transfers per second
that were carried out on behalf of the Memory
Internal queueing of requests may be Manager processes in the system. These values may
caused by such things as: contention for be greater than the values reported in the CPU
the CPU, contention for Disc Cache report 'swaps per second' column, since a Disc
semaphores, contention for the I/O Channel, Process may perform more than one I/O transfer per
I/O Controller(s) or the physical disc(s), 'swap' operation performed by a Memory Manager
or application-level contention for locked process.
records or files. It may also be caused
by requests that are not expected to (18) The average number of I/O operations per second to
complete rapidly; for example, CONTROL-27 the Disc Free Space table. This table must be
(write notification) requests on a file to accessed and updated whenever space is allocated
which writes, updates or deletes are done or deallocated on the volume.
infrequently.
(7) The sum of (5) and (6). Thus, this is the
average 'response time' experienced by a
request for service.
(8) The average number of CPU milliseconds
consumed by the primary Disc Process(es)
per request for service.