Tandem Performance Data Collector (TPDC) Manual Abstract The Tandem Performance Data Collector (TPDC) is a host-based performance data collection and relationship product for HP NonStop™ servers. TPDC significantly reduces the expertise and manpower required to collect performance data. It provides an all-in-one approach to collection and integration of performance information. Product Version TPDC D20 Supported Release Version Updates (RVUs) This manual supports H06.
Document History Part Number Product Version Published 425647-001 TPDC D20 August 2000 425647-002 TPDC D20 December 2002 526357-001 TPDC D20 May 2003 529899-001 TPDC D20 June 2005 529899-002 TPDC D20 June 2005
Tandem Performance Data Collector (TPDC) Manual Index Figures What’s New in This Manual v Manual Information v New and Changed Information v About This Manual vii Audience vii Related Manuals vii Manual Organization viii Notation Conventions viii 1.
2. Installing and Running TPDC Contents 2. Installing and Running TPDC Installing TPDC 2-1 Task 1: Install the TPDC Product Files 2-1 Task 2: Build a Dictionary for Enform 2-2 Running TPDC (Data Collection) 2-3 TPDC Output Files 2-5 Running Deferred Processing (TPDP) 2-5 3.
A. Entity and Attribute Definitions Contents A. Entity and Attribute Definitions B. Cross-Reference of Enform Queries to Data Files C. Enform Query Source File (QPGROUPS) Index Figures Figure 1-1. Figure 3-1. Figure 3-2. Figure 3-3. TPDC Architecture 1-2 Tandem Performance System File Label (TPSFL) Architecture 3-2 Tandem Performance Load Measure (TPLM) Architecture 3-5 Tandem Performance Load Data (TPLD) Architecture 3-9 Tables Table 3-1. Table 3-2. Table 3-3. Table 4-1. Table A-1.
Contents Tandem Performance Data Collector (TPDC) Manual— 529899-002 iv
What’s New in This Manual Manual Information Tandem Performance Data Collector (TPDC) Manual Abstract The Tandem Performance Data Collector (TPDC) is a host-based performance data collection and relationship product for HP NonStop™ servers. TPDC significantly reduces the expertise and manpower required to collect performance data. It provides an all-in-one approach to collection and integration of performance information.
What’s New in This Manual New and Changed Information Tandem Performance Data Collector (TPDC) Manual—529899-002 vi
About This Manual This manual describes how to install and use the Tandem Performance Data Collector (TPDC). TPDC is a host-based performance collection and relationship product that significantly reduces the expertise and time needed to collect performance data. TPDC integrates and normalizes data from Measure and other sources and creates a single consolidated data file for subsequent reporting and analysis. You can use TPDC in conjunction with Enform or other HP products such as GPA and Flow Map.
Manual Organization About This Manual Manual Organization Section/Appendix Contents Section 1, TPDC Overview Provides an overview of how TPDC collects data, and describes TPDC’s functions and components. Section 2, Installing and Running TPDC Describes how to install and run TPDC, and tells about the TPDC output files. Section 3, Using the Collected Data Describes how TPDC’s components operate with data collection entities and how it generates reports.
General Syntax Notation About This Manual lowercase italic letters. Lowercase italic letters indicate variable items that you supply. Items not enclosed in brackets are required. For example: file-name computer type. Computer type letters within text indicate C and Open System Services (OSS) keywords and reserved words. Type these items exactly as shown. Items not enclosed in brackets are required. For example: myfile.c italic computer type.
General Syntax Notation About This Manual An ellipsis immediately following a single syntax item indicates that you can repeat that syntax item any number of times. For example: "s-char…" Punctuation. Parentheses, commas, semicolons, and other symbols not previously described must be typed as shown. For example: error := NEXTFILENAME ( file-name ) ; LISTOPENS SU $process-name.
Notation for Messages About This Manual !o:i. In procedure calls, the !o:i notation follows an output buffer parameter that has a corresponding input parameter specifying the maximum length of the output buffer in bytes. For example: error := FILE_GETINFO_ ( filenum , [ filename:maxlen ] ) ; !i !o:i Notation for Messages This list summarizes the notation conventions for the presentation of displayed messages in this manual. Bold Text. Bold text in an example indicates user input typed at the terminal.
Notation for Management Programming Interfaces About This Manual either vertically, with aligned braces on each side of the list, or horizontally, enclosed in a pair of braces and separated by vertical lines. For example: obj-type obj-name state changed to state, caused by { Object | Operator | Service } process-name State changed from old-objstate to objstate { Operator Request. } { Unknown. } | Vertical Line.
Change Bar Notation About This Manual Change Bar Notation Change bars are used to indicate substantive differences between this manual and its preceding version. Change bars are vertical rules placed in the right margin of changed portions of text, figures, tables, examples, and so on. Change bars highlight new or revised information. For example: The message types specified in the REPORT clause are different in the COBOL environment and the Common Run-Time Environment (CRE).
Change Bar Notation About This Manual Tandem Performance Data Collector (TPDC) Manual—529899-002 xiv
1 TPDC Overview The Tandem Performance Data Collector (TPDC) is an HP host-based performance data collection and relationship product for HP NonStop systems. TPDC significantly reduces the expertise and manpower required to collect performance data. It provides an all-in-one approach to collection and integration of performance information. One of the challenges in performance analysis is making sure that you have all the data necessary to perform the analysis successfully.
TPDC Components and Architecture TPDC Overview TPDC Components and Architecture TPDC has six major components: TPDC Collects performance data and creates the consolidated performance data file. TPSFL Interrogates all disk directories on a system and records label information. TPFL Obtains label information from TPSFL data files and disk directories. TPLM Loads the consolidated data and creates Measure entities. TPLD Loads the consolidated data and creates TPDC entity files.
TPDC Overview Tandem Performance Data Collector (TPDC) Tandem Performance Data Collector (TPDC) The TPDC main component collects performance data and creates the consolidated performance data file. The unstructured consolidated performance data file contains all the data you need for subsequent analysis and reporting.
TPDC Overview Tandem Performance Load Data (TPLD) Tandem Performance Load Data (TPLD) The TPLD component loads the consolidated data file and creates component TPDC entity data files, from which you can generate optional reports using Enform and other programs. Tandem Performance Deferred Processing (TPDP) The TPDP component can be run at any time to generate consolidated performance data (UWS) files based on data you have collected and retained on disk using TPDC.
TPDC Overview How TPDC Collects Data How TPDC Collects Data To serve as a useful tool throughout the performance data collection cycle, TPDC: 1. Determines the hardware and software configurations of the system to be measured 2. Organizes measurements based on the system hardware and software configuration 3. Starts the measurements 4. Calculates an efficient sampling interval for devices and processors 5. Samples and records information on NonStop entities 6.
TPDC Overview Before the Measurement Before the Measurement TPDC facilitates correct configuration of measurements by determining the hardware and software of the system to be configured and organizing the measurements based on that hardware and software configuration.
TPDC Overview After the Measurement Period After the Measurement Period After retrieving data from the Measure measurements, TPDC integrates it, normalizes it, and relates it to data from other sources. TPDC then creates a single, consolidated data (UWS) file for subsequent analysis and reporting.
TPDC Overview • • Example: Scheduling TPDC Data Collection Pathway system process activity Detailed server process activity (estimated service times and utilizations, logical I/O activity, and physical I/O activity) Example: Scheduling TPDC Data Collection This example describes a regular routine for TPDC data collection that has minimal impact on system resources: 1. At midnight, run TPSFL to create current system file information.
2 Installing and Running TPDC Topic Page Installing TPDC 2-1 Running TPDC (Data Collection) 2-3 Running Deferred Processing (TPDP) 2-5 Installing TPDC You use DSM/SCM to move the TPDC product files from the site update tape (SUT) to your disk. For more information about DSM/SCM, see the DSM/SCM User’s Guide. TPDC installation does not require a system generation (SYSGEN) and has minimal impact on the system. Task 1: Install the TPDC Product Files 1. Run DSM/SCM to install TPDC.
Installing and Running TPDC Task 2: Build a Dictionary for Enform where Componentname can be one of: TPDC TPSFL TPLM TPLD TPDP and where options represents any of the options available from the component. You can also move the component object files to $SYSTEM.SYSTEM.*. This approach lets you execute the components by only having to specify the component name (such as TPDC). TPDC, TPFL, TPSFL, and TPDP need to reside in the same volume and subvolume.
Installing and Running TPDC Running TPDC (Data Collection) Running TPDC (Data Collection) When you run TPDC, you can specify nine parameters: • • • Duration (in minutes) of the measurement to be taken Whether to retain the raw Measure data files after the creation of the TPDC consolidated data file Whether to generate the configuration reports, defer processing, or collect data in intervals TPDC / NAME [processname] [,OUT outfile ][,NOWAIT] / [nnnn ] [,RETAIN ] [,REPORTS ] [,NOFILE ] [,NODISCOPEN ] [,N
Installing and Running TPDC Running TPDC (Data Collection) REPORTS specifies that the listed system environment reports on the configuration of the measured system be produced.
Installing and Running TPDC TPDC Output Files DEFER enables the RETAIN option and causes TPDC to immediately terminate after the creation of the DWS file without any post-processing to create the UWS file. This option is useful to minimize processor usage by TPDC while collecting data. If you use this option, you can later run TPDP to generate a UWS file. See Running Deferred Processing (TPDP) on page 2-5.
Installing and Running TPDC Running Deferred Processing (TPDP) Using the DEFER option lets you postpone using system time to process the collected data until a less processor-intensive time on your system. You must run TPDP on the same system on which TPDC collected the data. If a UWS file is already on the system, TPDP overwrites it with the new UWS file it creates.
Installing and Running TPDC Running Deferred Processing (TPDP) the raw Measure data files and DWS file, so you can never process the data again using TPDP.
Installing and Running TPDC Running Deferred Processing (TPDP) Tandem Performance Data Collector (TPDC) Manual—529899-002 2 -8
3 Using the Collected Data Topic Page Extracting System File Label Information (TPSFL) 3-2 Creating Measure Entities for GPA and Other Programs (TPLM) 3-5 Creating TPDC Entities for Enform and Other Programs (TPLD) 3-9 Entity Relationships 3-12 This section also contains tables of data collection entities and their relationships and lists reports that you can obtain. Data used by TPDC is kept in files with special file types. Table 3-1.
Using the Collected Data Extracting System File Label Information (TPSFL) Extracting System File Label Information (TPSFL) TPDC invokes the Tandem Performance System File Label (TPSFL) program once each day to extract file label information about all disk files on a system. It stores this information in files suitable for use with all languages and query facilities available on an HP NonStop system. Figure 3-1. Tandem Performance System File Label (TPSFL) Architecture Disk Directories $volume.sys00.
Using the Collected Data Running TPSFL Prior to opening the directory on a given disk, the device is again checked for accessibility. No external sorts or programs are invoked during TPSFL execution. Each time you execute TPSFL, it creates the reports that you specify. Execution Timing Estimates On an HP NonStop S70000 system, 11 volumes and a total of 24,806 files were processed in under 60 seconds.
Using the Collected Data • TPSFL Output Files Disk report VALIDATE indicates that the subvolume specified by the subvol option is a partial subvolume name that you are using to limit the search of file labels. subvol specifies one to eight valid characters of a partial or full subvolume name. Label information is collected only from subvolumes that begin with this subvolume specification.
Using the Collected Data Creating Measure Entities for GPA and Other Programs (TPLM) Creating Measure Entities for GPA and Other Programs (TPLM) TPDC’s Load Measure (TPLM) component loads the consolidated data and creates Measure entities, from which you can generate optional reports using GPA and other programs. Table 3-2 summarizes the TPDC Measure-derived entities. For the attributes of each entity, see Appendix A, Entity and Attribute Definitions. Figure 3-2.
Using the Collected Data Entities OUT outfile names the spooler collector or existing disk file to which your output is to be directed. For a spooler collector (DEVICETYPE 0, SUBTYPE 31), level-3 spooling will be used. For a disk file, it can be entry-sequenced or an EDIT file (type 101). If you do not specify an outfile, all the output is directed to your terminal. NOWAIT returns control to your TACL now, rather than when the process completes.
Using the Collected Data Entities Table 3-2. Measure-Derived Entities Measure Entity TPDC Entity Entity Description CLUSTER CLUSTER Fiber Optic Extension (FOX) ring measurement counters and linkages. The CLUSTER entity contains information about the number of FOX (fiber optic link) messages sent and received by all processes on the measured system. CONTROLLER CONTRL Controller counters and linkages (Dxx). CPU CPU CPU measurement counters and linkages.
Using the Collected Data Entities Table 3-2. Measure-Derived Entities Measure Entity TPDC Entity Entity Description OSSNS OSSNS OSSNS counters and linkages. The OSSNS entity provides information about the operation and performance of OSS Name Server processes. PROCESS PROCESS PROCESS counters and linkages. The PROCESS entity contains information about one or more processes.
Using the Collected Data Creating TPDC Entities for Enform and Other Programs (TPLD) Creating TPDC Entities for Enform and Other Programs (TPLD) The Tandem Performance Load Data (TPLD) component loads the consolidated data file and creates component TPDC entity data files, from which you can generate optional reports using Enform and other programs. Appendix A, Entity and Attribute Definitions, shows the attributes of each entity. Figure 3-3.
Using the Collected Data Entities OUT outfile names the spooler collector or existing disk file to which your output is directed. For a spooler collector (DEVICETYPE 0, SUBTYPE 31), level-3 spooling will be used. For a disk file, it can be entry-sequenced or an EDIT file (type 101). If you do not specify an outfile, all the output is directed to your terminal. NOWAIT returns control to your TACL now, rather than when the process completes.
Using the Collected Data Entities Table 3-3. Data Collection Entities (page 2 of 2) Entity Entity Description KCCB A NonStop operating system-derived entity that identifies the Kernel Common Control Block (KCCB) used by the Monitor and the Memory Manager. LABEL A disk directory entity that provides file label information for files accessed during measurement. LDEV A NonStop operating system-derived entity that provides logical device information.
Using the Collected Data Entity Relationships Entity Relationships Entries within each TPDC entity are assigned a unique artificial 32-bit identification. These identifiers have “-LINK” as the final portion of their name to indicate that the attribute or data field is a linkage or relationship. TPDC’s data collection entities come from these sources: • • • • Twenty are derived from Measure entities.
Using the Collected Data File Name Spaces value of 10 is the opener of this DISCOPEN. Varying degrees of linking exist between entities. PROCESS is linked to ten entities. File Name Spaces To conserve space, all file names are projected out to three entities: • • • FLABNAME LDEVNAME TPDCNAME The linkage to FLABNAME-LINK is the replacement.
Using the Collected Data Tandem Performance Data Collector (TPDC) Manual—529899-002 3- 14 TIME Fields
4 Using the System Configuration Reports The TPDC System Configuration reports provide detailed information on the hardware and software configuration of the systems on which you are collecting data.
Using the System Configuration Reports Device Distribution Report Device Distribution Report The Device Distribution report summarizes the devices on the system, providing a high-level view of how the system is configured with respect to I/O devices. The possible device types are described in the System Procedure Calls Reference Manual. The Device Distribution report displays the count of each device type on the system being measured and gives a brief description of the device type.
Using the System Configuration Reports Disk Report Disk Report The Disk report gives a detailed account of the disks on the measured system, including the paths to the devices and their status. The report also details the processes controlling the devices and the space characteristics of the devices. This report is similar to the output of the PUP LISTDEV DISC command. The same codes are used for the path status.
Using the System Configuration Reports Disk Report Table 4-1. Device State Codes Code State Description blank Up/read and write The device is logically accessible to user processes. For an optical disk volume, read and write access is allowed. D Down The device is no longer logically accessible to user processes. F Format A format is in progress on a disk of subtype 16 or greater.
Using the System Configuration Reports File Label Report CH displays the backup channel connection (0 through 3). (D-series only; for G-series, GP displays the primary group number instead.) CTLR displays the backup controller number in octal. (D-series only; for G-series, MOD displays the module number instead.) UN displays the backup unit number (0 through 7). (D-series only; for G-series, SLOT displays the slot number instead.) TOT MB displays the storage capacity of disk in 1,000,000-byte increments.
Using the System Configuration Reports File Label Report VOLUME-> $TOOLS REC BLK NO PRI SEC MAX SUBVOL FILENAME END OF FILE LEN LEN EXT EXT EXT EXT ----------------- ----------- ---- ---- ---- ---- ---- ---SAFE .GUARD 327,680 990 4096 16 32 32 16 TOOLBOX .BOXBASE 376,832 4096 4096 46 4 4 256 TOOLBOX .BOXMISC 49,152 4096 4096 6 4 4 256 TOOLBOX .BOXPRS 176,128 4096 4096 22 4 4 256 TOOLBOX .BOXRLSE 40,960 4096 4096 5 4 4 256 TOOLBOX .BOXSTQ 61,440 4096 4096 8 4 4 256 TOOLBOX .
Using the System Configuration Reports Logical Device Report NO EXT displays the current number of disc extents occupied by this file. PRI EXT displays the primary extent in 2048 byte pages. SEC EXT displays the secondary extent in 2048 byte pages. MAX EXT displays the maximum number of extents this file is authorized to have. FT displays the file type of this file (0 - unstructured, 1 - entry-sequenced, 2 - relative, 3 - key-sequenced). F CDE displays the file code of this file.
Using the System Configuration Reports Logical Device -----------------------DEVICE LDEV DEV SUB NAME NUM TYPE TYPE -------- ----- ---- ---?0 0 1 0 $Z0 5 1 2 $SYSTEM 6 3 10 $TUBTS1 31 3 10 $TAPE 32 4 4 $OSP 3 6 4 $TERM0 33 6 4 $TERM1 34 6 4 $SSCP 50 13 5 $TMP 2 21 0 $IPB 58 27 0 $ZNUP 4 28 0 $ZA000 61 50 1 $ZA001 62 50 1 $LAN1 53 56 0 $SNA01 51 58 1 $SNA02 52 58 1 $NCP 1 62 0 $SUBPAS 54 63 0 $SUBNOP 55 63 0 $SUBXXX 56 63 0 $LHSUPP 57 63 5 $LXD00 59 63 3 $LXFOR 60 63 3 $LHSUP 165 63 5 Logical Device Report
Using the System Configuration Reports Logical Device Report CTLR displays the primary controller number in octal. UNIT displays the primary unit number (0 through 7). CPU displays the number of the backup CPU being measured. PIN displays the process identification number of the backup process being measured. CH displays the backup channel connection (0 through 3). CTLR displays the backup controller number in octal. UNIT displays the backup unit number (0 through 7).
Using the System Configuration Reports Node Report Node Report The Node report provides high-level characteristics of the node measured by TPDC: • • • • Name and number of the HP NonStop operating system node Current system image Date of the system image NonStop operating system software RVU The NODE entity provides all the information on this report. NODE ENTITY INFORMATION NODE NAME : NODE NUMBER : IMAGE NAME : SYSGEN DATE : NONSTOP KERNEL RELEASE: \CSO 240 $SYSTEM.SYS00.
Using the System Configuration Reports Process Pair Directory Report Process Pair Directory Report The Process Pair Directory report shows: • • • All named process pairs that were executing at the beginning of the measurement The creator process CPU number and process identification number (PIN) The name of the creator process if it is a named process This report identifies the named processes that existed when the measurement period began. These processes are the primary source of process creations.
Using the System Configuration Reports System Generation Values Report DCT NUM displays the destination control table number in the process pair directory. PRIMARY PID displays the primary process identification number (PID) in the process pair directory. BACKUP PPID displays the backup primary process identification number (PID) in the process pair directory. SYSTEM NAME displays the system name of the creator process. PROCESS NAME displays the process name of the creator process.
Using the System Configuration Reports Guidelines MEMORY PAGES displays the number of physical pages (two kilobytes) installed on this processor. PCBS SGEN displays the process control blocks (PCBs) generated in the measured system. LCBS SGEN displays the link control blocks (LCBs) generated in the measured system. TLES SGEN displays the number of timer list elements (TLEs) generated in the measured system. BPTS SGEN displays the number of breakpoints generated in the measured system.
Using the System Configuration Reports Volume Label Report should be in effect. On development systems, it could limit the number of concurrent debugging sessions. Volume Label Report The Volume Label report provides a one-line entry for each active logical disk volume on the system. The LABEL entity provides all the information in this report.
Using the System Configuration Reports Volume Label Report OBJ COUNT displays the number of object programs (file code 100) on this volume. EDIT COUNT displays the number of EDIT files (file code 101) on this volume. UNS COUNT displays the number of unstructured files (file code 0) on this volume. ESEQ COUNT displays the number of entry-sequenced files (file type 1) on this volume. REL COUNT displays the number of relative files (file type 2) on this volume.
Using the System Configuration Reports Tandem Performance Data Collector (TPDC) Manual— 529899-002 4- 16 Volume Label Report
A Entity and Attribute Definitions Table A-1 gives an alphabetical overview of all the entities used by TPDC and indicates the entity type as used by TPDC. Following this table, each entity is listed and defined by its attribute identification. For more information, see the DDL records in your distribution subvolume. Table A-1. TPDC Entities (page 1 of 5) Entity TPDC Entity Type ALTK Data Collection A disk directory entity that provides information about alternate key files.
Entity and Attribute Definitions Table A-1. TPDC Entities (page 2 of 5) Entity TPDC Entity Type DISCOPEN Measure-Derived DISCOPEN counters and linkages. The DISCOPEN entity contains information about which programs are accessing which files, including program usage and process activity (physical file access). DISK Measure-Derived Derived from the Measure DISC entity; contains information about disk counters and linkages. DISKFILE Measure-Derived DISKFILE summary counters and linkages (D20).
Entity and Attribute Definitions Table A-1. TPDC Entities (page 3 of 5) Entity TPDC Entity Type LDEVNME Data Collection An ASCII name entity that identifies logical devices. LDEVNUM Data Collection A NonStop operating system-derived entity that provides logical device number information. LDISC Measure-Derived Derived from the Measure DISC entity, contains information about logical disk counters and linkages. LINE Measure-Derived LINE counters and linkages.
Entity and Attribute Definitions Table A-1. TPDC Entities (page 4 of 5) Entity TPDC Entity Type PIDNUM Data Collection An entity that provides process IDs from PROCESS and SQLPROC. PPD Data Collection A NonStop operating system-derived entity that identifies process pair directory (PPD) named processes running a process pair. PROCESS Data Collection PROCESS counters and linkages. The PROCESS entity contains information about one or more processes.
Entity and Attribute Definitions Table A-1. TPDC Entities (page 5 of 5) Entity TPDC Entity Type SYSTEM Data Collection Expand counters and linkages for this node. The SYSTEM entity contains information about network traffic through Expand line handlers. TERMINAL Data Collection TERMINAL counters and linkages. The TERMINAL entity contains information about the terminal I/O. TIME Data Collection A time management entity that gives execution information and LCT and GMT base times.
Entity and Attribute Definitions ALTK (continued) flabnme-link Identification field for FLABNME altkey-number Alternate key number altfile-number Alternate key file number system-number System number keytag-value Key tag value altkey-offset Alternate key offset in record altkey-length Alternate key length in bytes altkey-null-value Alternate key null value for no updates null-altk Flag for null values unique-altk Flag for unique alternate keys update-altk Flag for update status insert
Entity and Attribute Definitions CATEGORY (continued) prefix-id Identification field for load prefix interval-id Identification field for load interval ptype Process type pdesc Process description pcount Process count pbusy-time Process busy time CLUSTER Attribute Identification Definition cluster-link Identification field for CLUSTER messages-sent Measure field - messages sent sent-bytes Measure field - bytes sent returned-bytes Measure field - bytes returned messages-received Measu
Entity and Attribute Definitions CONTROL (continued) channel Measure field - channel ctrl Measure field - controller ctrl-type Measure field - controller type io-qlen-max Measure field - maximum I/O queue length CPU Attribute Identification Definition cpu-link Identification field for CPU memory-pages Measure field - memory pages cpu-qtime Measure field - CPU queue time mem-qtime Measure field - memory queue time cpu-busy-time Measure field - CPU busy time intr-busy-time Measure field
Entity and Attribute Definitions CPU (continued) page-scans Measure field - memory manager scans for a page starting-free-mem Measure field - free frames at the start of measurement ending-free-mem Measure field - free frames at the end of measurement starting-ucme Measure field - UCME frames at the start of measurement ending-ucme Measure field - UCME frames at the end of measurement starting-uds.
Entity and Attribute Definitions CPUX Attribute Identification Definition cpux-sequence Identification field for CPUX loadid Identification field for LOAD load-id Redefines LOAD prefix-id Identification field for load prefix interval-id Identification field for load interval cpu-num CPU number from-timestamp Measure field - from time to timestamp Measure field - to time delta-time Measure field - elapsed time system-name Measure field - name of system os-version Measure field - opera
Entity and Attribute Definitions CPUX (continued) accel-busy-time Measure field - accelerator busy time tns-busy-time Measure field - transaction busy time comp-traps Measure field - compatibility traps DEVICE Attribute Identification Definition device-link Identification field for DEVICE read-busy-time Measure field - read busy time write-busy-time Measure field - write busy time input-bytes Measure field - input bytes output-bytes Measure field - output bytes requests Measure field - n
Entity and Attribute Definitions DEVTYPES Attribute Identification Definition devtypes Identification for DEVTYPES DGLOBAL Attribute Identification Definition dglobal Identification field for DGLOBAL loadid Identification field for LOAD load-id Redefines LOADID prefix-id Identification field for load prefix interval-id Identification field for load interval system-name Name of the system os-version Operating system version letter Operating system version letter number Operating syste
Entity and Attribute Definitions DGLOBAL (continued) lo-cache-forces Low cache forces hi-cache-forces High cache forces total-swaps Total number of page swaps lo-swaps Low number of page swaps hi-swaps High number of page swaps total-frees Total free space lo-frees Low free space hi-fres High free space total-reqs-blkd Total requests blocked lo-reqs-blkd Low requests blocked hi-requests-blkd High requests blocked total-messages Total messages total-qtime Total queue and service tim
Entity and Attribute Definitions DISCINFO Attribute Identification Definition discinfo-sequence Identification field for DISCINFO loadid Identification field for LOAD load-id Redefines LOADID prefix-id Identification for load prefix interval-id Identification for load interval system-name Name of system os-version Operating system version letter Operating system version letter number Operating system version number ldev Logical device volume-name Name of volume from-timestamp From
Entity and Attribute Definitions DISCINFO (continued) b-messages Backup messages total-qtime Total queue and service time req-time Internal queue and service time recv-qtime External queue and service time total-ready-time Total DP ready time p-ready-time Primary DP ready time b-ready-time Backup DP ready time total-cpu-busy-time Total DP CPU busy time p-cpu-busy-time Total primary DP CPU busy time b-cpu-busy-time Total backup DP CPU busy time total-pages-qtime Total DP memory pages qu
Entity and Attribute Definitions DISCINFO (continued) m-output-bytes Output bytes in mirror drive m-read-busy-time Mirror read busy time, including apportioned seeks m-write busy-time Mirror write busy time, including apportioned seeks DISCOPEN Attribute Identification Definition discopen-link Identification field for DISCOPEN lockwait-time Measure field- lock wait time max-lockwait-time Measure field- maximum lockwait time block-splits Measure field- block splits cache-hits Measure field-
Entity and Attribute Definitions DISCOPEN (continued) MID Measure-field - unique identifier for OSS files pathid Measure field - internal representation of OSS file crvsn Measure field - creation volume sequence number DISK Attribute Identification Definition disk-link Identification field for DISK cap Capacity in 2048-byte units free Beginning of measurement number of free-space fragments frag Beginning of measurement size, in pages, of the largest freespace fragment end-free End of measu
Entity and Attribute Definitions DISK (continued) disk-path Disk path array (8) entries current-path Current path flag (*) inactive valid-path Valid path flag (0/1) channel Channel address of device controller Controller address of device dev-unit Device unit number dev-state Device state (See PUP Reference Manual.
Entity and Attribute Definitions DISKFILE (continued) starting-eof Measure field- starting end-of-file ending-eof Measure field- ending end-of-file transient-opens Measure field-transient opens driver-input-calls Measure field- driver input calls driver-output-calls Measure field- driver output calls cache-read-hits Measure field- cache read hits cache-write-hits Measure field- cache write hits cache-write-cleans Measure field- cache write cleans requests Measure field- number of requests
Entity and Attribute Definitions DISKFILE (continued) oss-block-write-bytes Measure field - bytes written by DP2 for OSS file manager oss-cache-callbacks Measure field- cache callbacks sent by DP2 to the OSS file manager oss-callback-writes Measure field - OSS-BLOCK-WRITES received by DP2 DPENSUM Attribute Identification Definition dopensum Identification field for DOPENSUM dopen-key Key for disk open loadid Identification field for LOAD load-id Redefines LOAD prefix-id Identification fiel
Entity and Attribute Definitions DPENSUM (continued) drtotal Sum of next two counters drins Driver input counts drouts Driver output counts cache-counts Cache counts chtotal Sum of next two counters crhits Cache read hits cwhits Cache write hits splits Block splits stalls Stalls physicals Driver counts plus cache counts EXLINE Attribute Identification Definition exline-sequence Identification field for EXLINE loadid Identification field for LOAD load-id Redefines LOAD prefix-id
Entity and Attribute Definitions EXLINE (continued) 12out-bytes Level-2 output bytes din4-bytes Level-4 input data bytes dout4-bytes Level-4 output bytes cin4-bytes Level-4 input bytes cout4-bytes Level-4 output bytes u64-bytes Unit 64 bytes u128-bytes Unit 128 bytes u256-bytes Unit 256 bytes u512-bytes Unit 512 bytes u1024-bytes Unit 1024 bytes u2048-bytes Unit 2048 bytes u4096-bytes Unit 4096 bytes o4095-bytes Unit 4095 bytes FILE Attribute Identification Definition file-link
Entity and Attribute Definitions FILE (continued) timetpl-link Identification for TIMETPL device-type Measure field- device type file-type Measure field-file type message-bytes-f Measure field - 64-bit version of message-bytes device-name Measure field - disk device name opener-device-name Measure field - disk device name of opener program dbio-reads Measure field - direct bulk I/O read operations dbio-writes Measure field - direct bulk I/O write operations dbio-read-bytes Measure field -
Entity and Attribute Definitions FILESUM (continued) filename File name opens File opens logical-counts Logical I/O counts by all openers of the file busy-time Busy time I/O counts by file openers reads Read I/O counts by file openers writes Write I/O counts by file openers updates Update I/O counts by file openers deletes Delete I/O counts by file openers infos Information I/O counts by file openers logicals Sum of five previous counter newer-counts Newer counts of file openers recor
Entity and Attribute Definitions GLOBINFO (continued) interval-id Identification field for INTERVAL system-name Name of system os-version Operating system version letter Operating system letter number Operating system number from-timestamp From time to-timestamp To time delta-time Elapsed time hybrid-system Data if more than one CPU time is found allow-seconds-used Value of ALLOW when TGATHER is run collect-name-used Name of COLLECT when TGATHER is run total-cpus Total of following C
Entity and Attribute Definitions GLOBINFO (continued) lo-mem-pages Low memory pages hi-mem-pages High memory pages total-memman-pages Total memory manager pages lo-memman-pages Low memory manager pages hi-memman-pages High memory manager pages total-est-free-pages Total estimated free pages lo-est-free-pages Low estimated free pages hi-est-free-pages High estimated free pages total-dispatches Total number of dispatches lo-dispatches Low number of dispatches hi-dispatches High number of
Entity and Attribute Definitions GLOBINFO (continued) hi-static-pcbs High static process control blocks with a life greater than or equal to 90% of CPUs total-transient-pcbs Total transient process control blocks with a life less than or equal to 90% of CPUs lo-transient-pcbs Low transient process control blocks with a life less than or equal to 90% of CPUs hi-transient-pcbs High transient process control blocks with a life less than or equal to 90% of CPUs os-cpu-busy-time Operating system CPU bu
Entity and Attribute Definitions KCCB Attribute Identification Definition cpu-num CPU number of data source sample-id Sample identification number delta-base-time Milliseconds from measurement start cme-events Correctable memory errors iocycles Number of cycles for I/O pages clock-calls Number of times a page frame searched clock-free Number of page free calls clock-replaces Number of page replacements clock-cycles Number of scans of page table clock-failures Number of failure to find
Entity and Attribute Definitions KCCB (continued) cpu-idle-pct Percentage of CPU idle time cpu-intr-pct Percentage of CPU interrupt time freepages Pages of memory available currlocks Pages of memory currently locked iocurr Current I/O pages in use iofails Failures to allocate I/O pages segments-allocated Number of segments allocated free-pages Current number of nonallocated memory pages current-locked-memory Current virtual memory locked in physical memory in pages scans-mmgr-call The av
Entity and Attribute Definitions LABEL (continued) filetype HP file type rec-length Record length block-length Block length pri-extent Primary extent in 2048-byte pages sec-extent Secondary extent in 2048-byte pages current-extents Number of extents in use max-extents Maximum number of extents allowed key-length Key length key-offset Key offset key-levels Key levels part-number Number of partitions including root altkey-number Number of alternate keys altfile-number Number of alter
Entity and Attribute Definitions LDEV Attribute Identification Definition ldev-link Identification field for LDEV ldevnme-link Identification field for LDEVNME disk-link Identification field for DISK device-number Logical device number device-type Device type sub Device subtype pcpu Primary CPU number pchn Primary channel number pctl Primary controller number punit Primary unit number ppin Primary PIN bcpu Backup CPU number bchn Backup channel number bctl Backup controller numb
Entity and Attribute Definitions LDEVNME (continued) device-name Synonym for ldevnme-nme exclusion TPDC application field category TPDC application field LDEVNUM Attribute Identification Definition LDEVNUM-LINK Identification field for LDEVNUM ldevnme-link Identification field for LDEVNME ldev-link Identification field for LDEV ldevnum-number Logical device number 32 bits device-number Logical device number 16 bits LDISC Attribute Identification Definition ldisc-link Identification fie
Entity and Attribute Definitions LINE (continued) input-data-bytes Measure field - number of input data bytes output-bytes Measure field - number of output bytes output-data-bytes Measure field - number of output data bytes reads Measure field - number of reads requests Measure field - number of requests retries Measure field - number of retries transactions Measure field - number of transactions writes Measure field - number of writes ldevnme-link Identification field for LDEVNME timetpl
Entity and Attribute Definitions MACHINE (continued) hist-timer-lists Timer lists interrupts hist-std-io Standard I/O interrupts hist-dispatch Dispatch interrupts hist-other Other interrupts hist-successful Successful expedited messages hist-unsuccessful Unsuccessful expedited messages hist-stolen Stolen expedited messages hist-busy-pct Percentage CPU busy time hist-idle-pct Percentage idle time hist-intr-pct Percentage idle time hist-highlocks Highest lock memory page count hist-max-
Entity and Attribute Definitions MACHINE (continued) mavg-highlocks Average measurement highest lock memory page count mavg-max-seg-used Average measurement highest segment used mavg-iomax Average measurement highest I/O maximum mavg-iofails Average measurement number of I/O fails cpu-type CPU type pages Number of memory pages pcbs Number of the PCBs generated mpool Amount of mappool spool Amount of syspool lcbs Number of LCBs generated tles Number of TLEs bpts Number of breakpoints
Entity and Attribute Definitions NETLINE (continued) cin4-bytes Measure field - level-4 input controller bytes cout4-bytes Measure field - level-4 output controller bytes din4-bytes Measure field - level-4 input data bytes dout4-bytes Measure field - level-4 output data bytes 12in-bytes Measure field - level-2 input bytes 12out-bytes Measure field - level-2 output bytes o4095-bytes Measure field - unit 4-95 bytes reads Measure field - number of reads requests Measure field - number of requ
Entity and Attribute Definitions NODE (continued) osi-hours Operating system image create hours osi-minutes Operating system image create minutes osi-seconds Operating system image create seconds node-number Node number of system device-num Device number of system sys-id-number System identification number 1-255 release-letter NonStop operating system identifying letter release-version NonStop operating system identifying number cpu-count Number of processors in system cpu-int-array 16-a
Entity and Attribute Definitions OPDISK Attribute Identification Definition opdisk-link Identification field for OPDISK read-busy-time Measure field- read busy time request-qtime Measure field- request queue time seek-busy-time Measure field- seek busy time write-busy-time Measure field- write busy time iput-bytes Measure field- number of input bytes output-bytes Measure field- number of output bytes requests Measure field- number of requests reads Measure field- number of reads seeks
Entity and Attribute Definitions OSSCPU (continued) fs-direct-writes Measure field - OSS file-system noncached write requests fs-direct-write-bytes Measure field - total bytes written by OSS file system cachedirect-writes fs-cache-reads Measure field - reads from the OSS file-system cache fs-cache-read-bytes Measure field - bytes read from OSS file system cache-cachereads fs-cache-writes Measure field - writes to the OSS file-system cache fs-cache-write-bytes Measure field - bytes written in OSS
Entity and Attribute Definitions OSSCPU (continued) ps-gettime-reqs Measure field - gettime requests received by an OSS pipe server process from an OSS NS ps-settime-reqs Measure field - settime requests received by an OSS pipe server process from an OSS NS lcl Measure field - CPU-remote pipe server requests ps-proxy-reads Measure field - proxy reads by an OSS pipe server ps-proxy-writes Measure field - proxy writes by an OSS pipe server ps-proxy-read-bytes Measure field - proxy read bytes read
Entity and Attribute Definitions OSSNS Attribute Identification Definition ossns-link Identification field for OSSNS timetpl-link Identification field for TIMETPL cpu-num CPU number pin Process identification number process-name Name server process name program-file-name.
Entity and Attribute Definitions OSSNS (continued) ls-msg-qtime Measure field - time for completion of LS messages ls-msg-qlen-max Measure field - max concurrent LS messages outstanding gettime-reqs Measure field - gettime requests sent settime-reqs Measure field - settime requests sent PART Attribute Identification Definition part-link Identification field for PART mainfile-link Identification field for FLABNME flabnme-link Identification field for FLABNME part-number Partition number sy
Entity and Attribute Definitions PDISC device-qbusy-time Measure field - busy time if any kind of request is queued input-bytes-f Measure field - 64-bit version of input-bytes output-bytes-f Measure field - 64-bit version of output-bytes PGMTOTAL Attribute Identification Definition pgmtotal-sequence Identification field for PGMTOTAL loadid Identification field for LOAD load-id Redefines LOADID prefix-id Identification field for load prefix interval-id Identification field for load interval
Entity and Attribute Definitions PGMTOTAL (continued) comp-traps TNS/R compatibility traps program-accelerated TNS/R programs accelerated file-counters The following fields are file counters: total-receive-busy-time Total receive busy time all-file-totals Totals of all files (next 6 fields) tot-opens Total opens tot-file-busy-time Total file busy time tot-logical-ios Total logical I/Os tot-messages Total messages tot-message-bytes Total message bytes tot-timeouts-or-cancels Total timeo
Entity and Attribute Definitions PGMTOTAL (continued) lpf-message-bytes Number of logical process file message bytes lpf-timeouts-or-cancels Number of logical process file timeouts or cancels logical-other-file-totals Logical other file counters follow: lof-opens Number of logical other file opens lof-file-busy-time Logical other file busy time lof-logical-ios Number of logical other file logical I/Os lof-messages Number of logical other file messages lof-message-bytes Number of logical othe
Entity and Attribute Definitions PPD (continued) crsys Creator system ID number crcpu Creator CPU number crpin Creator PIN crname Creator name PROCESS Attribute Identification Definition process-link Identification field for PROCESS pcbs-inuse-qtime Measure field- process control blocks in use queue time mem-qtime Measure field- memory queue time pres-pages-qtime Measure field- present pages queue time recv-qtime Measure field- receive queue time accel-busy-time Measure field- accelera
Entity and Attribute Definitions PROCESS (continued) flabnme-link Identification field for FLABNME gname-link Identification field for GNAME pidnum-link Identification field for PIDNUM procnme-link Identification field for PROCNME timetpl-link Identification field for TIMETPL usernme-link Identification field for USERNME interrupt-time-apportion TPDC application field max-lcbs-inuse Measure field- maximum link control blocks in use priority Measure field- priority program-accelerated Mea
Entity and Attribute Definitions PROCESS (continued) abs-segs-end Measure field - items on the queue at end msgs-sent-qtime Measure field - time that messages were outstanding msgs-sent-qlen-max Measure field - max number of items on the queue sent-cbytes Measure field - protocol control bytes sent returned-cbytes Measure field - protocol control bytes returned received-cbytes Measure field - protocol control bytes received reply-cbytes Measure field - protocol control bytes sent in reply oss
Entity and Attribute Definitions PROGFILE Attribute Identification Definition progfile Identification field for PROGFILE load-program-id Identification field for LOAD PROGRAM load-id Identification field for LOAD prefix-id Identification field for load prefix interval-id Identification field for load interval program-file-name Name of program file volume Program volume name subvol Program subvolume name filename Program file name file-id File identification file-system-name File syst
Entity and Attribute Definitions PROGFILE (continued) message-bytes Number of logical file message bytes lock-waits Number of logical file lock waits timeouts-or-cancels Number of logical file timeouts or cancels escalations Number of logical file escalations filler Filler field PROGLIO Attribute Identification Definition proglio-sequence Identification field for PROGLIO loadid Identification field for LOAD load-id Redefines LOADID prefix-id Identification field for load prefix interval
Entity and Attribute Definitions PROGLIO (continued) ldf-output-logical-ios Number of logical disk file output I/Os ldf-reads Number of logical disk file reads ldf-writes Number of logical disk file writes ldf-updates Number of logical disk file updates ldf-deletes Number of logical disk file deletes ldf-info-calls Number of logical disk file information calls ldf-records-used Number of logical disk file records used ldf-records-accessed Number of logical disk file records accessed ldf-disc
Entity and Attribute Definitions PROGLIO (continued) lof-reads Number of logical other file reads lof-writes Number of logical other file writes lof-writereads Number of logical other file writereads lof-info-calls Number of logical other file information calls lof-messages Number of logical other file messages lof-message-bytes Number of logical other file message bytes lof-timeouts-or-cancels Number of logical other file timeouts received-bytes Number of bytes received reply-bytes Number
Entity and Attribute Definitions PROGSIO (continued) cache-write-hits Number of cache write hits total-physical-ios Total physical I/Os input-physical-ios Number of input physical I/Os output-physical-ios Number of output physical I/Os block-splits Number of block splits requests-blocked Number of requests blocked PROGSQL Attribute Identification Definition progsql-sequence Identification field for PROGSQL loadid Identification field for LOAD load-id Redefines LOADID prefix-id Identifi
Entity and Attribute Definitions PROGSUM Attribute Identification Definition progsum-sequence Identification field for PROGSUM loadid Identification field for LOAD load-id Redefines LOADID prefix-id Identification field for load prefix interval-id Identification field for load interval program-file-name Name of program file volume Program file volume subvol Program file subvolumefile filename Program file file name total-processes Total processes sum-delta-times Sum of elapsed times
Entity and Attribute Definitions PROGSUM (continued) comp-traps Number of TNS/R compatibility traps program-accelerated Number of TNS/R programs accelerated file-counters These fields are file counters: total-receive-busy-time Total receive busy time all-file-totals Totals of all files (next six fields) tot-opens Total opens tot-file-busy-time Total file busy time tot-logical-ios Total logical I/Os tot-messages Total messages tot-messages-bytes Total message bytes tot-timeouts-or-cancel
Entity and Attribute Definitions PROGSUM (continued) lpf-messages Number of logical process file messages lpf-message-bytes Number of logical process file message bytes lpf-timeouts-or-cancels Number of logical process file timeouts or cancels logical-other-file-totals Logical other file counters follow: lof-opens Number of logical other file opens lof-file-busy-time Logical other file busy time lof-logical-ios Number of logical other file logical I/Os lof-messages Number of logical other fi
Entity and Attribute Definitions SERVER (continued) to-timestamp To time delta-time Elapsed time pid Group level name for process ID data cpu-num CPU number pin PIN number priority Process priority trans-count Transaction count messages-received Number of messages received received-bytes Number of received bytes reply-bytes Number of reply bytes messages-sent Number of messages sent sent-bytes Number of bytes sent returned-bytes Number of returned bytes ready-time Process ready t
Entity and Attribute Definitions SQLPROC (continued) sql-newprocesses Measure field- SQL new processes opens Measure field- SQL process opens priority Measure field- process priority device-name Measure field - name of disk device osspid Measure field - OSS process ID program-file-name-mid Measure-field - unique identifier for OSS program file pathid Measure field - internal representation of OSS file crvsn Measure field - creation volume sequence number SQLSTMT Attribute Identification De
Entity and Attribute Definitions SQLSTMT (continued) sorts Measure field- number of sorts timeouts Measure field- number of timeouts device-name Measure field - name of disk device message-bytes-f Measure field - 64-bit version of message-bytes calls-f Measure field - 64-bit version of calls records-used-f Measure field - 64-bit version of records-used records-accessed-f Measure field - 64-bit version of records-accessed disc-reads-f Measure field - 64-bit version of disc-reads messages-f
Entity and Attribute Definitions SQLSUM (continued) sorts Number of sorts elapsed-sort-time Amount of elapsed sort time recompiles Number of recompiles elapsed-recompile-time Amount of elapsed recompile time lock-waits Number of lock waits timeouts Number of timeouts escalations Number of escalations SQLTOTAL Attribute Identification Definition loadid Identification field for LOAD load-id Redefines LOAD prefix-id Identification field for load prefix interval-id Identification field f
Entity and Attribute Definitions SVNET (continued) requests Measure field - requests to the SAC total-io-bytes Measure field - bytes transferred to and from the SAC io-qtime Measure field - time the SAC is busy performing I/Os io-qlen-max Measure field - maximum number of outstanding I/Os adapter-name Measure field - logical name associated with the adapter SAC-name Measure field - logical name of the SAC node-class Measure field - identifies the SAC type group-number Measure field - group n
Entity and Attribute Definitions SYSTEM Attribute Identification Definition system-link Identification field for SYSTEM link-time Measure field - link time links Measure field - number of links received Measure field - received sent Measure field - sent sent-forward Measure field - sent forward received-forward Measure field - received forward nodenme-link Identification field for NODENME timetpl-link Identification field for TIMETPL remote-system Measure field - remote system cpu-num
Entity and Attribute Definitions TOC toc-type Table of contents type section-num Section number ret-name Name of report TPDCNME Attribute Identification Definition tpdcnme-link Identification field for TPDCNME tpdcnme-nme Eight-character name field subvol-occurs Number of times used as subvolumes filename-occurs Number of times used as a filename UNLINES Attribute Identification Definition unlines-sequence Identification field for UNLINES loadid Identification field for LOAD load-id
Entity and Attribute Definitions UNLINES (continued) output-data-bytes Number of output data bytes reads Number of reads writes Number of writes retries Number of retries transactions Number of transactions response-time Amount of response time VLDFTOT Attribute Identification Definition vldfot-key Identification field for VLDFTOT loadid Identification field for LOAD load-id Redefines LOADID prefix-id Identification field for load prefix interval-id Identification field for load inte
Entity and Attribute Definitions WORKLOAD Attribute Identification Definition workload-sequence Identification field for WORKLOAD loadid Identification field for LOAD load-id Redefines LOADID prefix-id Identification field for load prefix interval-id Identification field for load interval program-file-name Program file name volume Program volume subvol Program subvolume filename Program file name total-processes Total number of processes proc-msec Process messages per seconds intr-m
Entity and Attribute Definitions Tandem Performance Data Collector (TPDC) Manual— 529899-002 A -66
B Cross-Reference of Enform Queries to Data Files This example shows the XREFRPTS file, which cross-references Enform queries to the data files they use. !----------------------------------------------------------------------------! ! ! ! ! ! XREFRPTS ! ! ========== ! ! ! ! ! ! This file cross-references compiled ENFORM queries to the data files ! ! they require. You may edit this file to "customize" the selection ! ! and sequence of charts and/or reports contained within a named ! ! .
Cross-Reference of Enform Queries to Data Files !----------------------------------------------------------------------------! ! For each such line (unless, of course, it begins with an ! ! exclamation mark), TBUILD adds a "?Execute R" line to ! ! the command file it is building if, and only if: ! ! ! ! a. The ENFORM-compiled query file R exists and ! ! has a file code of 888, and ! ! ! ! b.
Cross-Reference of Enform Queries to Data Files CREATE CHARTS ! Name ! ------COVER PCOUNTS RCBCHRT ACUCHRT RDBCHRT DRTCHRT ADUCHRT DIOCHRT DCPCHRT TMFVIEW EXPAND DATACOM ! STACHRT WKLOAD AXLCHRT SQLPROG SQLSTAT ! PGSQLWT PGOVIEW PGOPENS PGLIOWT PGDIOWT PGSPLWT LDFIOWT DFSIOS DFPIOS BLKSPLT REQBLKD DFOATBL DFOSTBL DPMEMRY DFIODST PRIDIST ! DCUCHRT ( 80) Pseudo-graphic charts of overall activity/balance Uses [( ) = link optional] Description -------------------------- ---------------------------------GLOB
Cross-Reference of Enform Queries to Data Files CREATE REPORTS ! Name ! ------COVER PTIMLIN NEWPROC PATHWAY SERVICE ! SVCBYIO ! SERVLIO ! SERVPIO CPUREPT DPREPT DSCREPT PDISCIO CACHE1 TMFREPT SYSREPT NETREPT ! PALPHA ! PBSYOVR ! PCPUPRI PBSYCPU PMEMCPU PFLTCPU IOWOVER LIOBVOL ! LIOOVER SIOBVOL ! SIOOVER PIOBVOL ! PIOOVER SQLDETL ! HAYSTCK ! CACHE2 ! FILOPNS ! PROGLIO (132) Detailed reports on measured entities Uses [( ) = link optional] Description -------------------------- ----------------------------
C Enform Query Source File (QPGROUPS) This example shows the QPGROUPS file, which you can use in customizing some of your Enform source queries.
Enform Query Source File (QPGROUPS) =========================== 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.
Enform Query Source File (QPGROUPS) ?Section CNT1 (count (1 over all where ( ?Section CNT2 ?Section CPU1 ?Section CPU2 ) ?Section ?Section ?Section ?Section ?Section ?Section ?Section ?Section ?Section ?Section ?Section ?Section ?Section (sum ) ) (CPU-BUSY-TIME over all where ( ) ) ) DESCR01 ,PTYPE[ 1].PDESC := ("DISC Processes ") GROUP01 PRIORITY >= 219 and PROCESS-NAME <> "$IPB " DESCR02 ,PTYPE[ 2].
Enform Query Source File (QPGROUPS) ?Section GROUP07 ! ! ! ! ! ! ! ! ! ?Section ?Section ?Section ?Section ?Section ?Section or or or or or or or or or or or or or or or or or or or or or or or or FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME DESCR08 ,PTYPE[ 8].
Enform Query Source File (QPGROUPS) ! ! ! ! ! ! ?Section ?Section ?Section ?Section ?Section ?Section ?Section ?Section ?Section or or or or or or FILENAME FILENAME FILENAME FILENAME FILENAME FILENAME DESCR11 ,PTYPE[11].PDESC GROUP11 FILENAME DESCR12 ,PTYPE[12].PDESC GROUP12 FILENAME DESCR13 ,PTYPE[13].PDESC GROUP13 FILENAME DESCR14 ,PTYPE[14].PDESC GROUP14 FILENAME ! or FILENAME ! or FILENAME DESCR15 ,PTYPE[15].PDESC GROUP15 ?Section ?Source QSERVDEF ?Section DESCR16 ,PTYPE[16].
Enform Query Source File (QPGROUPS) Tandem Performance Data Collector (TPDC) Manual— 529899-002 C- 6
Index A M Analysis 1-7 Measure entities 3-5 Measurement information 1-6 C Components measured 1-6 TPDC 1-2, 3-1 Configuration hardware 1-6 software 1-6 D Data collection 1-5 DEFER option 2-5 Disk file labels 3-2 DWS file 1-4 E Entities Measure 3-5 F N NAME option 2-3, 3-3, 3-5, 3-9 NOWAIT option 2-3, 3-3, 3-6, 3-10 O Options DEFER 2-5 NAME 2-3, 3-3, 3-5, 3-9 NOWAIT 2-3, 3-3, 3-6, 3-10 OUT 2-3, 3-3, 3-6, 3-10 REPORTS 2-4, 2-6, 3-3, 3-6, 3-10 RESTART 2-6 RETAIN 2-3, 2-6 VALIDATE 3-4 OUT option 2-3, 3
Index T T TPDP component 2-5 U UWS file 1-4 V VALIDATE option 3-4 Tandem Performance Data Collector (TPDC) Manual— 529899-002 Index -2
