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-22
SPAM Examples
This example shows the usage of the TACL macro TPRODUCE to generate the report,
COVER.
1> TPRODUCE COVER
T8670D20 SPAM(18MAR99) - COPYRIGHT COMPAQ COMPUTER CORPORATION 1999
------------------------------------------------------------------------
TSHOW: Checking $GIA03.CBSPAM.GLOBINFO for TPDC Load ID ...
------------------------------------------------------------------------
TSHOW: Session PARAMeter settings are:
LID (Load ID) :02171507
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)
------------------------------------------------------------------------
TPRODUCE: Running ENFORM for file $GIA03.J8670D20.RCOVER to $Z735 ...
ENFORM - T9152C20 - (15JUN91) DATE - TIME : 3/04/99 - 12:02:56
COPYRIGHT COMPAQ COMPUTER CORPORATION 1979, 1983
MEASURE Load ID: 02171507
================ ========
System: \CSO (Release C30)
------- --------
Date: THU, 17 FEB '99
From: 15:07:15
To: 15:37:43 (Window = 1828.53 seconds)
CPUs: 4 (TXP 0, VLX 4, CLX 0, CYC 0)
TOTAL AVERAGE LOWEST HIGHEST
------- ------- ------- -------
Real Memory Pages 49152 12288 12288 12288
Estimated Free Pages 95616 23904 1 7850
Static Processes 373 93 72 124
Transient Processes 58 14 1 51
Dispatches/Second 276.7 69.2 21.7 141.0
Total CPU Busy 60.2% 15.0% 2.4% 36.3%
Process Busy 52.7% 13.2% 1.8% 33.2%
===================================================================COVER==
T8670D20 SPAM(18MAR99) 1
Interrupt Busy 7.5% 1.9% .6% 3.0%
CPU Queue Length - .2 .0 .6
Memory Queue Length - .0 .0 .0
Swaps/Second 1.5 .4 .0 1.4
Process Overhead .1% .0% .0% .1%
Send Busy .6% .1% .0% .3%
TMF Transactions/Second - - - -
TMF Transaction Time (msec) - - - -
Logical Disc I-O's/Second 36.3 - - -
Logical Disc I-O Time (msec) - 8.5 - -
Records Used/Accessed Ratio - - - -
Disc Cache Hits/Second 47.1 15.7 .0 26.6
Physical Disc I-O's/Second 13.5 4.5 .0 8.2
===================================================================COVER==
T8670D20 SPAM(18MAR94) 2
** END-OF-ENFORM-RUN **
------------------------------------------------------------------------
TPRODUCE: Report production complete (19 seconds)