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-17
Running the SPAM TACL Macros
Values are from 0 to 999 minutes. The default value is 0, which causes the
reports to compute the interval size such that the entire window (or BEGIN time
to end of window) is shown. Example:
INTERVAL 5, BEGIN 08:30
IOFACTOR physIO:cache-hit-CPU-cost-ratio
specifies how much more CPU cost a physical I/O (driver call minus cache hit)
incurs than a cache hit. Use this option with reports that attempt to apportion
Disc Process CPU time to the files or partitions accessed or to the programs
accessing the files or partitions.
Values are from 0.0 to 99.9. The default value is 2.0 (the same default used by
the Tandem Capacity Model (TCM) program). Example:
IOFACTOR 2.5
MINMSGS minimum-messages-received
specifies the minimum number of messages a process must receive in order
for PGOVIEW and PROFILE to show program resource consumptions and
wait times per message received. If the average number of messages received
by processes run from a given program file is below MINMSGS, the PGOVIEW
chart and PROFILE report instead show program resource consumptions and
wait times per second of the average lifetime of one of these processes.
Values are from 1 to 9999. The default value is 10. Example:
MINMSGS 15
NEEDLE access-selectivity-percentage
specifies the selectivity threshold. The unit of measure is records used as a
percentage of records accessed. This option is used with the HAYSTCK report,
which is intended to show openers of files (SQL/MP tables) whose accesses
exhibit low selectivity; that is, relatively small values for the records-used to
records-accessed ratio.
Values are from 0.0001 to 99.9999 percent. The default value is 1.0000
percent (one record used for every one hundred records accessed). HAYSTCK
shows only opens that exhibit a selectivity equal to or less than this
percentage. Example:
NEEDLE 0.0001 (one in a million)
PROGRAM partial-name
specifies a partial name of one or more programs, enabling you to examine the
activity against a particular program or set of programs for some reports, such
as PROFILE and PROGLIO. The partial name can be any contiguous string of