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-23
Producing SPAM Reports
This example shows the usage of the TACL macro, THELP.
Producing SPAM Reports
Use the TACL macros TBUILD and TPRODUCE to build Enform command files and
generate 80-column charts and 132-column reports. When using TGATHER, TBUILD,
or TPRODUCE to execute any of the compiled reports, you can establish values for
several options that modify how the compiled Enform queries behave (for example, by
excluding, flagging, or matching various measured entities). If you do not specify any of
these options, the Enform reports use default values.
The TBUILD routine uses the XREFRPTS file in your SPAM work subvolume to build
the command files that are read by TPRODUCE to produce charts or reports.
You can customize the XREFRPTS file (by using TEDIT) to:
•
Change the order of appearance of individual charts or reports
•
Add individual charts or reports to remove them from the built-in report set
•
Create your own customized report set
The beginning of the XREFRPTS file describes its structure and provides information
on how to customize it.
If you want to customize XREFRPTS after you have already used TGATHER on
TPDC-collected data, do so and then run this command to rebuild the command files
that TPRODUCE will use.
1> THELP
T8670D20 SPAM(18MAR99) - COPYRIGHT COMPAQ COMPUTER CORPORATION 1999
THELP provides help information on the SPAM TACL routines:
THELP <subject>
where <subject> is the name of one of the following TACL routines:
TINSTALL - Readies SPAM for use in your own subvolume,
TGATHER - Gathers and aggregates/correlates raw TPDC data,
TPRODUCE - Produces "canned" charts or reports, a single
chart or report or a customized report set,
TBUILD - Builds EDIT files to produce "canned" charts or reports
(invoked by TGATHER),
TSHOW - Shows session PARAMeter settings (invoked by TPRODUCE),
The typical routine sequence when using SPAM is:
+<-----------------------------------------------+
(once) v (once for each TPDC data) (report set) ^
TINSTALL ------------> TGATHER -----------> TPRODUCE ------>+
^ (more reports) v
+----------------+