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-14
Disc File I/O Activity Distribution (DFIODST)
page 1
Disc File I/O Activity Distribution for System \CSO (Release D20)
-----------------------------------
__________________________________________________________________________
| CPU's | | VOLUME's | | FILE's |ESTIMATED
| % of | | % of | | % of |UTILIZATN
| TOTAL | | CPU | | VOLUME | SHIFT
Cpu Chit DIOs $Volume Chits DIOs Subvol .Filename Chits DIOs Cpu Disc
--- ====+==== -------- =====+===== ----------------- =====+===== ---- ----
This report shows the estimated effects of disc file (or
partition) I/O activity on CPUs and disc drives.
The report presents the 'CPU -> Disc -> File' hierarchy, with
the most 'active' entity at each level shown first. That is,
the first CPU shown is that with the highest sum of Cache Hits
and Disc I/Os (its percentages of the system-wide totals of
each of these values is shown). The first Disc Volume shown
for each CPU is that with the highest sum of Cache Hits and
Disc I/Os within its CPU (its percentage of the CPU's totals
of each of these values is also shown). The first File (or
Partition) shown for each Disc Volume is that with the highest
total 'Driver Calls' on the Volume (again, its percentage of
the Volume's totals of Cache Hits and [Driver Calls minus
Cache Hits] is also shown). Progressively less active Files
or Partitions on the Volume are then shown, followed by
progressively less active Volumes within the CPU, followed by
progressively less active CPUs.
'Estimated Utilization Shift' represents the estimated amounts
by which the utilizations of the Disc Volume's primary CPU
(Cpu) and primary drive (Disc) would drop if the file or
partition were moved entirely off its current Disc Volume to
a Volume primaried in a different CPU. If the Volume is
mirrored, the mirror drive's utilization would normally be
expected to drop by an amount similar to the primary drive's.
These are 'absolute' values; that is, a 'Cpu' value of (for
example) 12.7 means that the CPU utilization would drop from
(for example) 52.7% to 40.0% if the file were moved.
The utilizations of the primary CPU and drive(s) to which the
file or partition is moved could normally be expected to
increase by similar amounts, if work were to continue to be
processed at the same rate following the move. Such, of
course, may not be the case.
The CPU utilization shift is estimated on the assumption that
a physical I/O (Driver Call minus Cache Hit) is 2.0 times as
CPU-costly as a Cache Hit. You can change this assumption by
specifying the TPRODUCE <option> 'IOFACTOR <value>' when you
run this query. The default value for IOFACTOR is 2.0, the
same default as is used by the Tandem Capacity Model (TCM).