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

Entity and Attribute Definitions
Tandem Performance Data Collector (TPDC) Manual—526357-001
A-4
PPD Data Collection A NonStop Kernel-derived entity that identifies
process pair directory (PPD) named processes
running a process pair.
PROCESS
Data Collection PROCESS counters and linkages. The PROCESS
entity contains information about one or more
processes.
PROCNME
Data Collection An ASCII name entity that identifies processes.
PROGFILE
SPAM Contains logical file data for programs, where a
program is an aggregate of all processes running
from the same program code file.
PROGLIO
SPAM Contains aggregated FILE data for each
PROGSIO
SPAM Contains DISCOPEN data for each program,
where a program is the aggregate of all processes
running from the same program code file.
PROGSQL
SPAM Contains SQLSTMT data for all SQL statements
executed by all copies of the program.
PROGSUM
SPAM Contains aggregated summary data for programs,
where a program is the aggregate of all processes
running from the same program code file.
RUNNME
Data Collection An ASCII name entity that identifies SQL object
files.
SERVER
SPAM Contains data about server processes.
SQLPROC
Data Collection SQLPROC counters and linkages. The SQLPROC
entity contains information about one or more SQL
processes.
SQLSTMT
Data Collection SQLSTMT counters and linkages. The SQLSTMT
entity contains information about all SQL
statements within an SQL process.
SQLSUM
SPAM Contains aggregated SQL statement data for each
program name, run unit, and statement index
combination.
SQLTOTAL
SPAM Contains TOTAL counts from SLQSTMT entities.
SVNET
Measure-Derived I/O activity on ServerNet addressable controllers
(NonStop S-series servers only) interprocessor
communication (IPC). ServerNet Cluster and
remote interprocessor communication.
SYSTEM
Data Collection Expand counters and linkages for this node. The
SYSTEM entity contains information about network
traffic through Expand line handlers.
Table A-1. TPDC Entities (page 4 of 5)
Entity
TPDC Entity
Type Description