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
Enform Query Source File (QPGROUPS)
Tandem Performance Data Collector (TPDC) Manual—526357-001
C-2
=========================== Default Category Criteria ================
!--------------------------------------------------------------------!
! !
! QPGROUPS !
! ======== !
! !
! ?Sources: QSERVDEF !
! !
!--------------------------------------------------------------------!
! !
! This (partial) !ENFORM query source file is intended to be used !
! to aid process categorization from MEASURE "PROCESS" data. !
! !
! Sections of this file are ?SOURCEd by the ENFORM query !
! FCATGRY. Together, these two files cause ENFORM to produce a !
! one-record file (CATEGORY) containing 20 repeating groups !
! (ugh); each group contains a process category description (up !
! to 24 characters) of, the total number of executions of, and !
! the total CPU microseconds consumed by, processes grouped !
! according to their functions. !
! !
! The following ?SECTIONs of this should NOT be altered: !
! !
! CNT1 1st part of frequently-executed code to !
! count the number of process entities !
! !
! CNT2 2nd part (matches closing parentheses) !
! !
! CPU1 1st part of frequently-executed code to !
! sum the CPU seconds consumed by process !
! entities !
! !
! CPU2 2nd part (matches closing parentheses) !
! !
! The remainder of the file consists of (up to) 20 ?SECTION !
! pairs, named DESCRnn and GROUPnn (where nn = 01 to 20): !
! !
! DESCRnn assigns a 24-character group description !
! !
! GROUPnn contains the partial components of the ENFORM !
! "where" clause necessary to identify a "group" !
! of process types (e.g. Disc Processes). NOTE: !
! The compound symbol ']' denotes "begins with"; !
! the compound symbol '>' denotes "contains". !
! !
! As supplied, the following 20 categories are defined: !
! !
! 01 Disc Processes !
! 02 Other NonStop (not disc processes, not TMF) !
! 03 TMF Subsystem !
! 04 SPOOLER Subsystem !
! 05 Command Interpreters (except SQLCI(2)) !
! 06 Editors/Formatters !
! 07 Compilers !
! 08 ENFORM, SQLCI and (FAST)SORT !
! 09 Utilities !
! 10 Batch Control !
! 11 SNAX High Level Support (HLS) !
! 12 PATHWAY: PATHCOMs !
! 13 PATHWAY: PATHCOMs !
! 14 PATHWAY: TCPs !
! 15 PATHWAY: User Servers (?SOURCEs QSERVDEF) !
! 16 PATHWAY: ENABLE Servers !
! 17 Performance: MEASURE !
! 18 Performance: Other Tools !
! 19 <unused> !
! 20 <unused> !
! !
!--------------------------------------------------------------------!