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-68
Network System Activity (SYSREPT)
Network System Activity (SYSREPT)
This 132-column report shows Expand intersystem message and packet traffic. It
includes:
•
Total number of links (message exchanges) between systems
•
Links per second
•
Average time waiting for message acknowledgment
•
Packets per second between systems (sent, received, and so on)
•
Average number of packets per message
This report uses the SYSTEM entity.
Low Selectivity (Needle in a Haystack) SQL Table Access Report for System \P20ET (C30)
--------------------------------------------------------------
<---AVERAGE PER SECOND OVER-->
<---WINDOW---> <----OPEN---->
(headings continued below)
<-------TABLE NAME-------> <-[HH:MM]-> Select- Records Disc Records Disc
Filename $Volume .Subvol From To ivity(%) Accessd Reads Accessd Reads
======== ----------------- ===== ----- -------- ------- ------ ------- ------
(Local )
(data continued below)
AS $DATA06 .OPAPDAT 14:00 15:00 .2850% 65.8 .0 65.9 .0
$DATA06 .OPAPDAT 14:00 15:00 .6110% 25.0 .0 25.0 .0
$DATA06 .OPAPDAT 14:00 15:00 .5503% 59.8 .0 59.8 .0
$DATA06 .OPAPDAT 14:00 15:00 .3138% 95.5 .0 95.5 .0
$DATA06 .OPAPDAT 14:00 15:00 .4791% 58.9 .0 58.9 .0
$DATA06 .OPAPDAT 14:00 15:00 .6616% 47.0 .0 47.1 .0
FACDEPT $DATA02 .OPAPDAT 14:00 15:00 .0807% 27.2 .1 27.2 .1
$DATA02 .OPAPDAT 14:00 15:00 .0741% 18.3 .1 18.4 .1
MS $DATA07 .OPAPDAT 14:00 15:00 1.7995% 60.9 .0 61.0 .0
$DATA07 .OPAPDAT 14:00 15:00 3.4062% 1503.5 .0 1504.5 .0
USTREXCP $DATA19 .OPAPDAT 14:00 15:00 21.7 .7 21.7 .7
$DATA19 .OPAPDAT 14:00 15:00 20.4 .7 20.4 .7
------- ------
------- ------
2004.0 1.6
Sec
per
<-------------OPENING PROCESS--------------> Log
Procss PID Pri Program File Name I/O
------ ------ --- -------------------------- ----
$F042 4,150 150 $USER01 .OPAPOBJ .OPAS042A
$B042 0,170 150 $USER01 .OPAPOBJ .OPAS042A
$A042 5,145 150 $USER01 .OPAPOBJ .OPAS042A
$E042 3,156 150 $USER01 .OPAPOBJ .OPAS042A
$C042 1,158 150 $USER01 .OPAPOBJ .OPAS042A
$D042 2,173 150 $USER01 .OPAPOBJ .OPAS042A
$A033 1,153 150 $USER01 .OPAPOBJ .OPAS033A 0
$B033 2,166 150 $USER01 .OPAPOBJ .OPAS033A 0
$A312 5,156 150 $USER01 .OPAPOBJ .OPAS312A
$B312 0,197 150 $USER01 .OPAPOBJ .OPAS312A
$B250 3,187 150 $USER01 .OPAPOBJ .OPAS250A 2
$A250 2,199 150 $USER01 .OPAPOBJ .OPAS250A 2