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-23
Disc File Physical I/O Shares (DFPIOS)
Disc File Physical I/O Shares (DFPIOS)
This 74-column chart provides an overview of disk file physical I/O count distribution. It
is ordered by descending total physical I/Os (summed over all opens of any given
logical disk file or partition) so the files for which applications cause the most physical
I/Os are at the top of the list. The chart displays:
•
File name
•
Physical I/Os per second
•
Flags for nonzero requests blocked, block splits, and remote I/Os
•
Individual share of total physical I/Os and a graph of this share
•
Cumulative share of total physical I/Os
Disc File Overview (System I/Os) Table for System \CSO (Release D20)
--------------------------------------
Total <---I/Os PER SECOND---> Cach Lock ms /
$Volume .Subvol .Filename T Opens Logical System Physcal Hit% Wait% L.IO
-------------------------- - ----- ------- ======= ------- ---- ----- ----
$LAB .NSS3 .DBPCB K 3 .99 3.28 .48 85% 22
$GPATS2 .SYS00 .DIRECTRY K 1 1.51 1.63 .11 93% 4
$JACK .SYS00 .DIRECTRY K 1 1.47 1.60 .14 92% 5
$DATA .SYS00 .DIRECTRY K 1 1.13 1.25 .11 91% 5
$TUOMO .SYS00 .DIRECTRY K 1 1.11 1.23 .12 91% 5
$GPATS1 .SYS00 .DIRECTRY K 1 1.09 1.22 .13 89% 7
$IMAGE .SYS00 .DIRECTRY K 1 1.04 1.10 .06 95% 4
$USERS .SYS00 .DIRECTRY K 1 1.00 1.10 .09 91% 5
$WORK .SYS00 .DIRECTRY K 1 .88 .96 .07 92% 5
$JACK2 .SYS00 .DIRECTRY K 1 .83 .91 .08 91% 5
$TUBDV1 .SYS00 .DIRECTRY K 1 .80 .88 .08 91% 5
$DATA1 .SYS00 .DIRECTRY K 1 .69 .76 .07 91% 5
$DATA2 .SYS00 .DIRECTRY K 1 .68 .75 .07 91% 7
$JACK2 .JFDSPAM .QPGROUPS 128 .78 .71 .00 100% 4
$DATA3 .SYS00 .DIRECTRY K 1 .54 .59 .05 91% 7
$DATA4 .SYS00 .DIRECTRY K 1 .53 .59 .05 91% 5
$SYSTEM .SYS00 .DIRECTRY K 1 .53 .59 .05 91% 5
$GPADV1 .SYS00 .DIRECTRY K 1 .48 .53 .05 91% 6
$MWR3 .SYS00 .DIRECTRY K 1 .45 .50 .04 91% 5
$TOOLS .SYS00 .DIRECTRY K 1 .45 .49 .04 92% 5
$TUBTS1 .SYS00 .DIRECTRY K 1 .44 .48 .04 91% 5
$MWR2 .SYS00 .DIRECTRY K 1 .42 .46 .04 92% 5
$LAB .NSS3 .DBNET K 2 .12 .44 .18 60% 31
$GPADV2 .SYS00 .DIRECTRY K 1 .30 .34 .04 89% 6
$GIAO2 .SYS00 .DIRECTRY K 1 .26 .33 .08 77% 12
$MWR1 .SYS00 .DIRECTRY K 1 .24 .27 .02 92% 5
$USERS .SAFE .GUARD K 3 .08 .17 .00 99% 6
$LAB .NSS3 .DBCPU K 3 .07 .16 .08 48% 20
$JACK2 .SAFE .GUARD K 2 .06 .13 .00 100% 4
$JACK2 .SPAMD20 .DICTOBL K 3 .11 .11 .01 95% 10
$USERS .T9683AAA.NSSMON 30 .11 .11 .01 94% 8
$SYSTEM .ZSYH .ZZEV0001 E 3 .10 .11 .00 97% 4
----- ------- ------- -------
----- ------- ------- -------
200 19.30 23.76 2.39
T: E = Entry-sequenced, K = Key-sequenced, R = Relative, _ = Unstructured.