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)
------------------------------------------------------------------------










