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 SPAM Performance Data Charts and
Reports
Tandem Performance Data Collector (TPDC) Manual—526357-001
5-43
Program Overview (PGOVIEW)
This chart uses the GLOBINFO and PROGSUM entities.
Parameters used are:
•
LID—specifies the Measure Load ID
•
EXCLUDE—specifies a value under which to exclude the number of requests per
second
•
SECTION—specifies the report section number
•
MINMSGS—specifies a value under which the messages received per process are
counted per second instead of per message received, to separate servers from
batch processes
The chart is sorted in program file-name order.
Note. This report might cover HP NonStop Kernel process pairs. It attempts to allow for this
fact by considering and reporting “messages received” to be (MESSAGES-RECEIVED -
CHECKPOINTS). This information should be accurate for programs that use the standard
NonStop Kernel Checkpointing facility, because one CHECKPOINT by the primary process
equals one MESSAGE-RECEIVED by the backup process. This compensation does not work
for process pairs that implement fault-tolerance using “hot” backups and regular I/O to keep
their backups current because the CHECKPOINTS counter is zero for such programs.
Program Overview for System \WMC (Release C30)
----------------
Msgs Avg <AVERAGE per MSG RCVD (or SECOND)>
Rcvd Rcv <----------Milliseconds---------->
per Queue CPU CPU Memory I/O
Program File Name Second msecs Total Busy Wait Wait Wait
-----------------======== ------ ----- ------ ------ ------ ------ ------
$SYSTEM .SYSTEM .PATHMON .01 - 2s 0s 0s - 1s
$DATA10 .SYSTEM .PERUSE .00 - 11s 0s 3s 0s 7s
$SYSTEM .SYSTEM .PSPOOL .00 - 37s 5s 20s 0s 11s
$SYSTEM .SYS01OBJ.PWLOG 1.45 4 40 14 4 - 22
$SYSTEM .SYS15 .RESTORE - - 1130s 48s 348s - 734s
$SYSTEM .SYSTEM .RJESV .80 1 8 2 2 1 5
$SYSTEM .SYSTEM .SPOOL 2.53 6 18 8 9 0 1
$SYSTEM .SYSTEM .SQLCI .04 - 914s 4s 5s 8s 897s
$SYSTEM .SYSTEM .SQLCI2 .28 1 293 15 17 1 260
$SYSTEM .SYSTEM .SQLCOMP .14 12 2473 412 1177 123 761
$SYSTEM .SYS15 .TACL .55 4 196 50 60 35 49
$DATA1 .TAPES .TAPESMON .03 2 34150 53 98 - 33999
$SYSTEM .TDS .TDPAXL - - 43s 21s 18s 0s 4s
$DATA10 .SYSTEM .TEDIT .01 - 35s 13s 8s 2s 12s
$SYSTEM .SYS15 .TMFCTLG .01 2374 5549 915 1729 - 2905
$SYSTEM .SYS15 .TMFDR .00 - 793s 53s 259s 1s 480s
------
------
72.42