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

Installing and Running TPDC
Tandem Performance Data Collector (TPDC) Manual—526357-001
2-2
Task 2: Build a Dictionary for Enform
where Componentname can be one of:
TPDC TPSFL TPLM TPLD TPDP
and where options represents any of the options available from the component.
You can also move the component object files to $SYSTEM.SYSTEM.*. This approach
lets you execute the components by only having to specify the component name (such
as TPDC). TPDC, TPFL, TPSFL, and TPDP need to reside in the same volume and
subvolume. If you move the object files, resecure them by repeating Step 4.
Task 2: Build a Dictionary for Enform
To use Enform with the TPDC, SPAM, and Measure entities for your own queries (in
addition to the ones we provide), you need to build a dictionary:
1. Volume to the subvolume of your TPDC component files.
2. Build the dictionary by entering:
DDL/IN TPDCDDLS,OUT $S.#TPDC/DICT !
DDL/IN SPAMDDLS,OUT $S.#SPAM/DICT
DDL/IN $SYSTEM.SYSnn.MEASDDLS,OUT $S.#MEAS/DICT
These steps create a set of dictionary files that include descriptions of the TPDC,
SPAM, and Measure entities. If you will not use Enform, you do not need to perform
this task.
Task 3: Set Up SPAM
The SPAM component of the TPDC product produces a variety of useful performance
reports generated using Enform on the data collected by TPDC. The TPDC distribution
subvolume includes:
•
Additional DDL definitions for custom data files, CUSTDDLS.
•
Customizable sections of some Enform source queries, which you can edit to meet
your needs before you use the package on Measure data from any specific
installation:
See Appendix C, Enform Query Source File (QPGROUPS)
•
Precompiled Enform queries. Many of these queries produce a page of descriptive
notes whenever you run them.
QFCATEGORY Find query
QFSERVER Find query
QVERSION Common source
QGROUPS CATEGORY definition
QSERVDEF SERVER definition