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-16
Running the SPAM TACL Macros
BEGIN 13:30, INTERVAL 5
EXCLUDE activity-exclusion-threshold
enables you to set the threshold for the exclusion of low-activity entities from
the output of charts and reports. The reports exclude entities whose activity is
less than the threshold, letting you minimize the amount of data presented. The
unit of measure varies from report to report, but it is usually a percentage
utilization (as in Cpu Busy), a percentage of some global total (as in total
logical disk file I/Os), or a rate of events per second (as in logical I/Os per
second).
Each report shows its EXCLUDE value and unit of measure at the bottom of
every page. For a detailed list, see the file “DPARAMS” in the SPAM base
directory.
Valid values are from 0.00 to 99.99. The default is 0.1. Example:
EXCLUDE 0.01
FILE partial-name
specifies a partial name of one or more files, enabling you to examine the
activity against a particular file or set of files for some reports, such as
FILOPNS. The partial name can be any contiguous string of eight characters
(possibly including spaces) that can occur anywhere within the fully qualified
file name. If you specify fewer than eight characters, the partial name is
padded to the right with spaces. If your partial name includes spaces, you must
enclose it in quotes (“). Examples:
FILE $prod1 (same as $PROD1)
FILE “PROD DB“
FLAG transient-duration-percentage
specifies the percentage of the window or life for which the entity must have
existed before it is considered transient. The entity is flagged if it lived for less
than this percentage of the window or opening process’s life.
Valid values are from 1 to 99. The default value is 90 percent. Example:
FLAG 95
INTERVAL process-timeline-interval
specifies the interval size, in minutes, for the NEWPROC and PTIMLIN reports.
These reports show new process creations and process existence,
respectively, during intervals within the overall measurement window. These
reports show 16 equal-sized intervals within the window. To zoom in on a
shorter time period within the measurement window, use the INTERVAL
parameter in conjunction with the BEGIN parameter.