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-50
Busiest Disc Files (Logical I/Os, by Volume)
(LIOBVOL)
•
Average bytes per message sent
•
Selectivity percentage (records used divided by records accessed)
•
Number of disk reads per logical I/O
The report aggregates all opens of the same file into one report line. All counts are in
units per second.
This report 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 report is sorted by file, system, and name and descending total file busy time.
Busiest Disc Files (Logical I/Os, by Volume) (LIOBVOL)
This 132-column report shows the busiest disk files on each volume, in terms of total
logical I/O requests. The report includes:
•
File system name and file name
•
Total number of opens
•
File’s file busy (wait) time as percentage of volume total
Busiest Disc Files (Logical I/O Wait Time, Overall) Report for System \CSO (D20)
----------------------------------------------------------
$Volume .Subvol .Filename (headings continued below)
--------------------------
$LAB .NSS3 .DBPCB (data continued below)
$USERS .PNA .PNAQUEUE
$GPATS2 .SYS00 .DIRECTRY
$TUOMO .SYS00 .DIRECTRY
$LAB .NSS3 .DBNET
$DATA1 .SYS00 .DIRECTRY
$JACK2 .JFDSPAM .QPGROUPS
$SYSTEM .SYS00 .OSIMAGE
$JACK2 .GM930802.FLABEL
<-Of GLOBAL-> msecs Msgs Bytes D Reads
Total IOWait Cum've per <----------LOGICAL I/O's per SECOND----------> per per Select- per
Opens Share% Share% Log IO LTE Total Reads Updates Deletes Writes Info LogIO Msg ivity % Log I/O
----- ====== ------ ------ --- ----- ----- ------- ------- ------- ----- ----- ----- ------- -------
3 12.7% 12.7% 22 .99 .02 . . .97 . 1.00 156 - .01
1 4.3% 25.8% 8 .99 .99 . . . . 1.00 10 -
1 3.8% 29.6% 4 1.51 1.51 . . . . 1.00 243 - .08
1 3.3% 36.2% 5 1.11 1.11 . . . . 1.00 244 - .10
2 2.2% 56.4% 31 .12 . . . .12 . 1.00 168 - .11
1 2.1% 58.5% 5 .69 .69 . . . . 1.00 249 - .10
128 2.0% 60.4% 4 .78 .71 . . . .07 1.05 398 - .00
4 1.6% 65.5% 3 1.11 . . . . 1.11 1.00 148 -
1 1.3% 75.0% 109 .02 . . . .02 . 1.49 14666 -
---- ----- ----- ------- ------- ------- ------- -----
---- ----- ----- ------- ------- ------- ------- -----
160 75.0 20.34 18.04 . . 1.11 1.18 (totals include data not
used in this example)