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-35
Logical Disc File I/O Wait Shares (LDFIOWT)
•
Timeouts and escalations
•
Individual shares of total file busy time and a graph of this share
•
Cumulative share of total file busy time
This chart uses the GLOBINFO and FILESUM 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
The chart is sorted in descending order of file busy time.
Logical Disc File I/O Wait Shares for System \CSO (Release D20)
---------------------------------
[Total = 172 msec/Sec]
LogIOs <-Shr% = %-age of Total--> Cum.
$Volume .Subvol .Filename /Secnd LTE Shr% 0 5 10 15 20 25 Shr%
-------------------------- ------ --- ==== +----+----+----+----+----+ ----
$LAB .NSS3 .DBPCB ! 1.0 12.7 |************* | 12.7
$JACK .SYS00 .DIRECTRY 1.5 4.4 |**** | 17.1
$GPATS1 .SYS00 .DIRECTRY 1.1 4.4 |**** | 21.5
$USERS .PNA .PNAQUEUE! 1.0 4.3 |**** | 25.8
$GPATS2 .SYS00 .DIRECTRY 1.5 3.8 |**** | 29.5
$DATA .SYS00 .DIRECTRY 1.1 3.4 |*** | 32.9
$TUOMO .SYS00 .DIRECTRY 1.1 3.3 |*** | 36.2
$USERS .SYS00 .DIRECTRY 1.0 3.1 |*** | 39.3
$DATA2 .SYS00 .DIRECTRY! .7 2.9 |*** | 42.2
$IMAGE .SYS00 .DIRECTRY 1.0 2.6 |*** | 44.8
$JACK2 .SYS00 .DIRECTRY .8 2.5 |** | 47.3
$WORK .SYS00 .DIRECTRY .9 2.3 |** | 49.6
$TUBDV1 .SYS00 .DIRECTRY .8 2.3 |** | 51.9
$DATA3 .SYS00 .DIRECTRY! .5 2.3 |** | 54.2
$LAB .NSS3 .DBNET ! .1 2.2 |** | 56.4
$DATA1 .SYS00 .DIRECTRY .7 2.1 |** | 58.4
$JACK2 .JFDSPAM .QPGROUPS .8 2.0 |** | 60.4
$GPADV1 .SYS00 .DIRECTRY .5 1.8 |** | 62.1
$GIAO2 .SYS00 .DIRECTRY! .3 1.7 |** | 63.8
$SYSTEM .SYS00 .OSIMAGE 1.1 1.6 |** | 65.5
$DATA4 .SYS00 .DIRECTRY .5 1.6 |** | 67.1
$SYSTEM .SYS00 .DIRECTRY .5 1.5 |* | 68.5
$MWR3 .SYS00 .DIRECTRY .5 1.3 |* | 69.9
$TOOLS .SYS00 .DIRECTRY .4 1.3 |* | 71.1
$TUBTS1 .SYS00 .DIRECTRY .4 1.3 |* | 72.4
$MWR2 .SYS00 .DIRECTRY .4 1.3 |* | 73.7
$JACK2 .GM930802.FLABEL ! .0 1.3 |* | 74.9
+----+----+----+----+----+
0 5 10 15 20 25
NOTE: An exclamation point (!) following a File Name indicates
that accesses to the file are experiencing an average
wait time per logical I/O that is greater than the
overall system average of 7.2 milliseconds.
LTE: L = Lock waits, T = Timeouts or cancels, E = (lock) Escalations.