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-12
Disc File Block Splits Shares (BLKSPLT)
Disc File Block Splits Shares (BLKSPLT)
This 74-column chart shows which disk files are experiencing the most block splits. It is
ordered by descending block splits (summed over all opens of any given file or
partition), so only the files experiencing block splits are shown. The chart displays:
•
File name
•
Number of block splits
•
Individual share of total block splits and a graph of this share
•
Cumulative share of total block splits
This chart uses the GLOBINFO and DOPENSUM entities.
Parameters used are:
•
LID—specifies the Measure Load ID
•
EXCLUDE—specifies a value under which to exclude the number of requests per
second
•
SECTION—specifies the report section number
The chart is sorted in descending order of total block splits.
Disc File I/O Activity Distribution (DFIODST)
This 74-column chart displays a table of DISCOPEN disk file I/O activity distribution
across volumes and CPUs. Intended as an aid to file balancing, it includes:
•
CPU number
•
A CPU’s contribution to systemwide cache hits/disk I/Os
•
Disk volume name
•
A volume’s contribution to the primary CPU’s cache hits/disk I/Os
•
Disk file/partition subvolume and file name
Disc File Block Split Shares for System \CSO (Release D20)
----------------------------
[Ttl = 301 Splits ( 0.1/Sec)]
Total <----Shr% = %-age of Total----> Cum.
$Volume .Subvol .Filename Splts Shr% 0 5 10 15 20 25 30 Shr%
-------------------------- ----- ==== +----+----+----+----+----+----+ ----
$LAB .NSS3 .DBPCB 235 78.1 |*****************************> 78.1
$LAB .NSS3 .DBNET 38 12.6 |************* | 90.7
$LAB .NSS3 .DBCPU 11 3.7 |**** | 94.3
+----+----+----+----+----+----+
0 5 10 15 20 25 30