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 Collected Data
Tandem Performance Data Collector (TPDC) Manual—526357-001
3-20
SPAM Examples
This example is the result of a TGATHER run.
1> TGATHER 940307 1035
T8670D20 SPAM(18MAR99) - COPYRIGHT COMPAQ COMPUTER CORPORATION 2000
TGATHER: Base = \CSO.$GIA03.J8670D20, Work = \CSO.$GIA03.CBSPAM; OK?(y/n)Y
------------------------------------------------------------------------
TGATHER: Running \CSO.$GIA03.J8670D20.SPAM ...
TGATHER: SPAM complete (5 seconds)
------------------------------------------------------------------------
TGATHER: Data gathering complete (10 seconds); invoking TBUILD ...
------------------------------------------------------------------------
T8670D20 SPAM(18MAR94) - COPYRIGHT COMPAQ COMPUTER CORPORATION 2000
TBUILD: Base = \CSO.$GIA03.J8670D20, Work = \CSO.$GIA03.CBSPAM; OK? (y/n)Y
------------------------------------------------------------------------
TBUILD: Checking \CSO.$GIA03.CBSPAM.XREFRPTS to build command files ...
THE FOLLOWING OUTPUTS CAN BE TPRODUCE-D:
----------------------------------------
80-column CHARTS - Pseudo-graphic charts of overall activity/balance
COVER PCOUNTS RCBCHRT ACUCHRT RDBCHRT DRTCHRT
ADUCHRT DIOCHRT DCPCHRT TMFVIEW EXPAND DATACOM
WKLOAD SQLPROG SQLSTAT PGOVIEW PGOPENS PGLIOWT
PGDIOWT PGSPLWT LDFIOWT DFSIOS DFPIOS BLKSPLT
REQBLKD DFOATBL DFOSTBL DPMEMRY DFIODST PRIDIST
132-column REPORTS - Detailed reports on measured entities
COVER PTIMLIN NEWPROC PATHWAY PROFILE SERVICE
CPUREPT DPREPT DSCREPT PDISCIO CACHE1 TMFREPT
SYSREPT NETREPT PBSYCPU PMEMCPU PFLTCPU IOWOVER
LIOBVOL SIOBVOL PIOBVOL SQLDETL
------------------------------------------------------------------------
T8670D20 SPAM(18MAR99) - COPYRIGHT COMPAQ COMPUTER CORPORATION 1994
------------------------------------------------------------------------
TSHOW: Checking \CSO.$GIA03.CBSPAM.GLOBINFO for TPDC Load ID ...
------------------------------------------------------------------------
TSHOW: Session PARAMeter settings are:
LID (Load ID) :03020951
AUDIT (TMF Audit Trail Volume Name) :Default ($AUDIT)
BEGIN (Process Timeline Begin Time) :Default (Window Start)
EXCLUDE (Entity Exclusion Threshold) :Default (0.10)
FILE (Specific File Name) :Default (all)
FLAG (Transient Entity Flag) :Default (90%)
INTERVAL (Process Timeline Interval) :Default (computed)
IOFACTOR (PhysIO:Cache Hit CPU Cost) :Default (2.0 times)
MINMSGS (Minimum Messages Received) :Default (10)
NEEDLE (SQL Table Selectivity) :Default (1.0000%)
PROGRAM (Specific Program File Name) :Default (all)
SHOWRCV (Show $RECEIVE in File lists) :Default (0 - false)
------------------------------------------------------------------------