Go to Home Page
Questions?
Call 1-800-572-5517
 
  Go to Home Page  
  See all products
  See price schedules
  See manuals, tutorials, articles
  Download a free 30-day trial
  See user testimonials
  About Pacific Systems Group
 
 
SMF Tools
  See SMF Record Layouts
  See Sample SMF Reports
  Learn How to Export SMF Data
  Download Free SMF Reporting Software (30 days)
 
One of the greatest SMF record parsing programming languages I've ever seen. Chief, Large Systems Services Branch, NIH
  Choose Spectrum Writer to add 4GL to your product
  Free 60-Page Book (PDF) - How to Make an SMF Report
Spectrum DCOLLECT Reporter - the 4GL DCOLLECT Report Writer.

Spectrum SMF Writer - the 4GL SMF Report Writer.

SMF Type 100 Record

This table shows the record layout for type 100 SMF records
(DATABASE 2 Statistics - DB2 V10).

List of other SMF record layouts available.
List of sample SMF reports.

Purpose: DATABASE 2 (DB2) writes record type 100 to record transaction data collected at event monitoring points.


It's easy to report on SMF 100 data! (Jump to sample reports)

SMF Spectrum Writer
We have a low-cost 4GL report writer especially for SMF files. It's called Spectrum SMF Writer.

Spectrum SMF Writer handles the difficult SMF record parsing for you automatically. You just specify which fields you want to see.

Spectrum SMF Writer also converts the arcane date and time fields and reformats them into an attractive report.

Plus, Spectrum SMF Writer can export SMF data as comma delimited files to use on your PC.
 
Try It FREE Now!

The Spectrum Writer definitions for the SMF type 100 record below are based on the description provided by IBM in its "MVS Systems Management Facilities (SMF)" manual and/or DSECTs mapped by its Assembler macros.

 

Spectrum SMF Writer
File Definition for Type 100 SMF Records
DATABASE 2 Statistics - DB2 V10

***********************************************************************
*          SPECTRUM SMF WRITER -- FILE DEFINITION STATEMENTS          *
*       SMF TYPE 100 RECORD - "DATABASE 2 STATISTICS - DB2 V10"       *
***********************************************************************
FLD: QWST     LEN(4) TYPE(BIN) DISP(0)       /*SMF 100 RECORD IFCID 0*/
*******************************************************************
*  SMF COMMON HEADER MAPPING MACRO FOR STATISTICS TYPE 100
*******************************************************************
*
FLD: SM100BKE LEN(4) DISP(0)
                          /*END OF BLOCK ADDRESS WHEN COLLECTING DATA*/
FLD: SM100LEN LEN(2) DISP(0)      /*SM100 TOTAL LENGTH*/
FLD: SM100SGD LEN(2) DISP(2)      /*ZZ BYTES*/
FLD: SM100FLG LEN(1) DISP(4)      /*SYSTEM INDICATOR*/
FLD: SM100RTY LEN(1) TYPE(BIN) DISP(5)            /*RECORD TYPE X'64'*/
FLD: SM100TME LEN(4) TYPE(B-SECS) DISP(6) DEC(2)
                                  /*TIME SMF MOVED RECORD*/
FLD: SM100DTE TYPE(P-CYYDDD) DISP(10)         /*DATE SMF MOVED RECORD*/
FLD: SM100SID LEN(4) DISP(14)     /*SYSTEM ID (SID)*/
FLD: SM100SSI LEN(4) DISP(18)     /*SUBSYSTEM ID*/
FLD: SM100STF LEN(1) DISP(22)     /*RESERVED*/
FLD: SM100RI  LEN(1) DISP(23)     /*RESERVED*/
FLD: SM100SEQ LEN(4) DISP(24)     /*RESERVED*/
FLD: SM100BUF LEN(4) DISP(24)     /*TEMPORARY POINTER TO BUFFER AREA*/
FLD: SM100END LEN(1) DISP(28)    /*START OF THE SELF DEFINING SECTION*/
*
FLD: SM100PSO LEN(4) TYPE(BIN) DISP(28)
                                  /*OFFSET TO THE PRODUCT SECTION*/
FLD: SM100PSL LEN(2) TYPE(BIN) DISP(32)
                                  /*LENGTH OF THE PRODUCT SECTION*/
FLD: SM100PSN LEN(2) TYPE(BIN) DISP(34)  /*NUMBER OF PRODUCT SECTIONS*/
*
*   STANDARD HEADER MAPPED BY DSNDQWHS

***********************************************************************
*   QWHS    DSNDQWHS   *   STANDARD HEADER ALWAYS APPEARS
*    QWHC    DSNDQWHC  *    CORRELATION HEADER MAY APPEAR
*    QWHT    DSNDQWHT  *    TRACE HEADER MAY APPEAR
*    QWHU    DSNDQWHU  *    CPU   HEADER MAY APPEAR
*    QWHD    DSNDQWHD  *    DISTRIBUTED HEADER MAY APPEAR
*    QWHA    DSNDQWHA  *    DATA SHARING HEADER
***********************************************************************
**** QWHS     DSECT                                                     
COMP: QWHS_OFFSET = 
        WHEN(SM100RTY=100 AND SM100PSN > 0) ASSIGN(SM100PSO)
        ELSE                                ASSIGN(99999)
FLD: QWHS     DISP(0) LEN(1) OFFSET(QWHS_OFFSET)
*
***********************************************************************
*                         PRODUCT SECTION
* THIS SECTION CONTAINS 1 OR MORE HEADERS. EACH HEADER CONTAINS		
* HEADER LENGTH, A HEADER TYPE CODE, AND VARIABLE INFORMATION
* DEPENDING UPON THE HEADER TYPE.
***********************************************************************
COMP: PSHDR_MAX_OFFSET  =      /* WILL POINT PAST ALL HDRS*/
        WHEN(SM100RTY=100 AND SM100PSN > 0) ASSIGN(SM100PSO +SM100PSL)
        ELSE                                ASSIGN(99999)
*
***********************************************************************
***                                                                  **
*** INSTRUMENTATION STANDARD HEADER DATA IN PRODUCT SECTION          **
***    THIS HEADER IS ALWAYS PRESENT AND IS ALWAYS THE 1ST HEADER    **
***********************************************************************
*
FLD: QWHSLEN  LEN(2) TYPE(BIN) DISP(0) /*LENGTH OF THE STANDARD HEADER*/
FLD: QWHSTYP  LEN(1)               /*HEADER TYPE*/
*
*  **              HEADER TYPE CONSTANTS                             **
COMP: QWHSHS01 = 1                 /*..STANDARD HEADER*/
COMP: QWHSHC02 = 2                 /*..CORRELATION HEADER*/
COMP: QWHSHT04 = 4                 /*..TRACE HEADER*/
COMP: QWHSHU08 = 8                 /*..CPU HEADER*/
COMP: QWHSHD16 = 16                /*..DISTRIBUTED HEADER*/
COMP: QWHSHA32 = 32                /*..DATA SHARING HEADER*/
*
FLD: QWHSRMID LEN(1)               /*RESOURCE MANAGER ID*/
FLD: QWHSIID  TYPE(HALF)           /*IFCID*/
FLD: QWHSRELN LEN(2)               /*RELEASE NUMBER AREA*/
FLD: QWHSNSDA LEN(1) TYPE(BIN) DISP(6) /*NUMBER OF SELF DEFINING AREAS*/
*
FLD: QWHSRN   LEN(1)               /*RELEASE INDICATOR NUMBER HEX*/
*
FLD: QWHSACE  TYPE(FULL)           /*ACE ADDRESS DISPATCH UNIT ADDRESS*/
FLD: QWHSSSID LEN(4)               /*SUBSYSTEM NAME*/
FLD: QWHSSTCK TYPE(STCKTIME)       /*STORE CLOCK VALUE OF HEADER*/
*                                 For data sharing, this is the sysplex
*                                 timer value.
*
* *********************************************************************
* * NOTE- THE FOLLOWING SEQUENCE NUMBERS ARE UNIQUE WITHIN A SINGLE   *
* * SUBSYSTEM INSTANCE AND ARE INITIALIZED TO ZERO ON RESTART.        *
* * BECAUSE OF MP CONSIDERATIONS THE NUMBERS MAY NOT ALWAYS BE        *
* * IN ASCENDING ORDER.                                               *
* *********************************************************************
*
FLD: QWHSISEQ TYPE(FULL)           /*SEQUENCE NUMBER FOR IFCID*/
FLD: QWHSWSEQ TYPE(FULL)           /*SEQUENCE NUMBER FOR DESTINATION*/
FLD: QWHSMTN  LEN(4)               /*ACTIVE TRACE NUMBER MASK*/
FLD: QWHSLOCN LEN(16)              /*%U LOCAL LOCATION NAME*/
*                                   Truncated if QWHSLOCN_Off¬=0
FLD: QWHSLWID LEN(24)              /*LUWID*/
FLD: QWHSNID  LEN(8) DISP(52)      /*NETWORK ID*/
FLD: QWHSLUNM LEN(8)               /*LUNAME*/
FLD: QWHSLUUV LEN(6)               /*UNIQUENESS VALUE*/
FLD: QWHSLUCC TYPE(BIN) LEN(2)     /*COMMIT COUNT*/
FLD: QWHSFLAG LEN(1)               /*Flags*/
COMP: QWHS_UNICODE = X'80'         /*%U fields contain Unicode (UTF 8)*/
FLD: QWHSLOCN_OFF TYPE(HALF) DISP(78)            /*Offset from QWHS to*/
*                                   LOCAL LOCATION NAME
*                                   If QWHSLOCN truncated
FLD: QWHSSUBV TYPE(HALF)         /*THE SUBVERSION FOR THE BASE RELEASE*/
FLD: QWHSSID  LEN(4)               /*THE MVS SYSTEM ID (SID)*/
FLD: QWHSEND  LEN(1)               /*END OF STANDARD HEADER*/
*
*
*

**** QWHSLOCN_D   Dsect                Use if QWHSLOCN_Off¬=0
COMP: QWHSLOCN_D_OFFSET = 
        WHEN(QWHSLOCN_Off <> 0) ASSIGN(QWHS_OFFSET + QWHSLOCN_Off)
        ELSE                    ASSIGN(99999)
           
FLD: QWHSLOCN_D DISP(0) LEN(1) OFFSET(QWHSLOCN_D_OFFSET)
                                  /*Use if QWHSLOCN_Off¬ 0*/
*
FLD: QWHSLOCN_LEN TYPE(HALF) DISP(0)   /*Length of the following field*/
FLD: QWHSLOCN_VAR LEN(128)         /*%U LOCAL LOCATION NAME*/
*
***THE FOLLOWING VALUES DEFINE THE IFCID IN QWHSIID                  **
***                          RMID: DESCRIPTION:                      **
COMP: QWHS0000 = 0                 /*..DEFAULT NORMAL TRACE RECORDS*/
COMP: QWHS0001 = 1                 /*26 ..SYSTEM STATISTICS*/
COMP: QWHS0002 = 2                 /*26 ..DATA BASE STATISTICS*/
COMP: QWHS0003 = 3                 /*26 ..ACCOUNTING*/
*

***********************************************************************
*    SOME OR ALL OF THESE HEADERS MAY NOW FOLLOW THE STD HEADER:
*    QWHC    DSNDQWHC  *  CORRELATION HEADER PRESENT ON ACCOUNTING
*    QWHT    DSNDQWHT  *  TRACE HEADER MAY APPEAR
*    QWHU    DSNDQWHU  *  CPU HEADER MAY APPEAR
*    QWHD    DSNDQWHD  *  DISTRIBUTED HEADER PRESENT ON ACCOUNTING
*    QWHA    DSNDQWHA  *  DATA SHARING HEADER
***********************************************************************
*
***********************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE NEXT HEADER SECTION PRESENT  *
***********************************************************************
COMPUTE: PSHDR_2_TEST_OFFSET = QWHS_OFFSET + QWHSLEN  
COMPUTE: PSHDR_2_OFFSET =
  WHEN(PSHDR_2_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
  ELSE                                      ASSIGN(PSHDR_2_TEST_OFFSET)
*
FIELD:   PSHDR_2_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_2_OFFSET)
FIELD:   PSHDR_2_TYP         LEN(1) TYPE(BIN)
*

***********************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE 3RD SECTION PRESENT          *
***********************************************************************
COMPUTE: PSHDR_3_TEST_OFFSET = PSHDR_2_OFFSET + PSHDR_2_LEN
COMPUTE: PSHDR_3_OFFSET =
  WHEN(PSHDR_3_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
  ELSE                                      ASSIGN(PSHDR_3_TEST_OFFSET)
*
FIELD:   PSHDR_3_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_3_OFFSET)
FIELD:   PSHDR_3_TYP         LEN(1) TYPE(BIN)
*
***********************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE 4TH SECTION PRESENT          *
***********************************************************************
COMPUTE: PSHDR_4_TEST_OFFSET = PSHDR_3_OFFSET + PSHDR_3_LEN
COMPUTE: PSHDR_4_OFFSET =
  WHEN(PSHDR_4_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
  ELSE                                      ASSIGN(PSHDR_4_TEST_OFFSET)
*
FIELD:   PSHDR_4_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_4_OFFSET)
FIELD:   PSHDR_4_TYP         LEN(1) TYPE(BIN)
*
*
***********************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE 5TH SECTION PRESENT          *
***********************************************************************
COMPUTE: PSHDR_5_TEST_OFFSET = PSHDR_4_OFFSET + PSHDR_4_LEN
COMPUTE: PSHDR_5_OFFSET =
  WHEN(PSHDR_5_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
  ELSE                                      ASSIGN(PSHDR_5_TEST_OFFSET)
*
FIELD:   PSHDR_5_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_5_OFFSET)
FIELD:   PSHDR_5_TYP         LEN(1) TYPE(BIN)
*
************************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE 6TH SECTION PRESENT           *
************************************************************************
COMPUTE: PSHDR_6_TEST_OFFSET = PSHDR_5_OFFSET + PSHDR_5_LEN
COMPUTE: PSHDR_6_OFFSET =
  WHEN(PSHDR_6_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
  ELSE                                       ASSIGN(PSHDR_6_TEST_OFFSET)
*
FIELD:   PSHDR_6_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_6_OFFSET)
FIELD:   PSHDR_6_TYP         LEN(1) TYPE(BIN)
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR CORRELATION HEADER
***********************************************************************
COMPUTE: QWHC_OFFSET =
   WHEN(PSHDR_2_TYP = QWHSHC02) ASSIGN(PSHDR_2_OFFSET)
   WHEN(PSHDR_3_TYP = QWHSHC02) ASSIGN(PSHDR_3_OFFSET)
   WHEN(PSHDR_4_TYP = QWHSHC02) ASSIGN(PSHDR_4_OFFSET)
   WHEN(PSHDR_5_TYP = QWHSHC02) ASSIGN(PSHDR_5_OFFSET)
   WHEN(PSHDR_6_TYP = QWHSHC02) ASSIGN(PSHDR_6_OFFSET)
   ELSE                         ASSIGN(99999) /*QWHC NOT PRESENT*/
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR TRACE HEADER
***********************************************************************
COMPUTE: QWHT_OFFSET =
   WHEN(PSHDR_2_TYP = QWHSHT04) ASSIGN(PSHDR_2_OFFSET)
   WHEN(PSHDR_3_TYP = QWHSHT04) ASSIGN(PSHDR_3_OFFSET)
   WHEN(PSHDR_4_TYP = QWHSHT04) ASSIGN(PSHDR_4_OFFSET)
   WHEN(PSHDR_5_TYP = QWHSHT04) ASSIGN(PSHDR_5_OFFSET)
   WHEN(PSHDR_6_TYP = QWHSHT04) ASSIGN(PSHDR_6_OFFSET)
   ELSE                         ASSIGN(99999) /*QWHT NOT PRESENT*/
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR CPU HEADER
***********************************************************************
COMPUTE: QWHU_OFFSET =
   WHEN(PSHDR_2_TYP = QWHSHU08) ASSIGN(PSHDR_2_OFFSET)
   WHEN(PSHDR_3_TYP = QWHSHU08) ASSIGN(PSHDR_3_OFFSET)
   WHEN(PSHDR_4_TYP = QWHSHU08) ASSIGN(PSHDR_4_OFFSET)
   WHEN(PSHDR_5_TYP = QWHSHU08) ASSIGN(PSHDR_5_OFFSET)
   WHEN(PSHDR_6_TYP = QWHSHU08) ASSIGN(PSHDR_6_OFFSET)
   ELSE                         ASSIGN(99999) /*QWHU NOT PRESENT*/
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR DISTRIBUTED HEADER
***********************************************************************
COMPUTE: QWHD_OFFSET =
   WHEN(PSHDR_2_TYP = QWHSHD16) ASSIGN(PSHDR_2_OFFSET)
   WHEN(PSHDR_3_TYP = QWHSHD16) ASSIGN(PSHDR_3_OFFSET)
   WHEN(PSHDR_4_TYP = QWHSHD16) ASSIGN(PSHDR_4_OFFSET)
   WHEN(PSHDR_5_TYP = QWHSHD16) ASSIGN(PSHDR_5_OFFSET)
   WHEN(PSHDR_6_TYP = QWHSHD16) ASSIGN(PSHDR_6_OFFSET)
   ELSE                         ASSIGN(99999) /*QWHD NOT PRESENT*/
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR DATA SHARING HEADER
***********************************************************************
COMPUTE: QWHA_OFFSET =
   WHEN(PSHDR_2_TYP = QWHSHA32) ASSIGN(PSHDR_2_OFFSET)
   WHEN(PSHDR_3_TYP = QWHSHA32) ASSIGN(PSHDR_3_OFFSET)
   WHEN(PSHDR_4_TYP = QWHSHA32) ASSIGN(PSHDR_4_OFFSET)
   WHEN(PSHDR_5_TYP = QWHSHA32) ASSIGN(PSHDR_5_OFFSET)
   WHEN(PSHDR_6_TYP = QWHSHA32) ASSIGN(PSHDR_6_OFFSET)
   ELSE                         ASSIGN(99999) /*QWHA NOT PRESENT*/
*
*

***********************************************************************
*    QWHA    DSNDQWHA  *  DATA SHARING HEADER
***********************************************************************
**** QWHA     DSECT                                                     
FLD: QWHA     DISP(0) LEN(1) OFFSET(QWHA_OFFSET)
*
*     /**************************************/
*     /*INSTRUMENTATION DATA SHARING HEADER */
*     /**************************************/
*
FLD: QWHALEN  LEN(2) TYPE(BIN) DISP(0)              /*LENGTH OF HEADER*/
FLD: QWHATYP  LEN(1)               /*TYPE OF HEADER DATA SHARING*/
*                         /*   NAME - QWHSHA32                       */
FLD: QWHAMEMN LEN(8) DISP(4)       /*DB2 MEMBER NAME*/
*                         /*   WITHIN A DB2 DATA SHARING GROUP, EACH */
*                         /*   MEMBER DB2 HAS A NAME.                */
FLD: QWHADSGN LEN(8)               /*DB2 DATA SHARING GROUP NAME*/
FLD: QWHAEND  LEN(1)


***********************************************************************
*    QWHU    DSNDQWHU  *  CPU HEADER MAY APPEAR
***********************************************************************
**** QWHU     DSECT                                                     
FLD: QWHU     DISP(0) LEN(1) OFFSET(QWHU_OFFSET)
*     /*INSTRUMENTATION CPU HEADER DATA  */
FLD: QWHULEN  LEN(2) TYPE(BIN) DISP(0)              /*LENGTH OF HEADER*/
FLD: QWHUTYP  LEN(1)              /*TYPE OF HEADER CPU MAPPED QWHSHU08*/
FLD: QWHUCPU  TYPE(STCKTIME) DISP(4)
                               /*CPU time of the currently dispatched*/
*                      /* execution unit (TCB or SRB).  This    */
*                      /* time includes CPU consumed on an IBM  */
*                      /* specialty engine.                     */
*                      /* Note: A given ACE token may           */
*                      /* run under one or more MVS dispatchable*/
*                      /* execution units. Thus the CPU time for*/
*                      /* a given ACE may decrease between      */
*                      /* events.  Binary zero indicates        */
*                      /* CPU time was not available.           */
FLD: QWHUCNT  LEN(2)               /*(S) COUNT FIELD RESERVED*/
FLD: QWHUEND  LEN(1)


***********************************************************************
*    QWHT    DSNDQWHT  *  TRACE HEADER MAY APPEAR
***********************************************************************
**** QWHT     DSECT                                                     
FLD: QWHT     DISP(0) LEN(1) OFFSET(QWHT_OFFSET)
*     /*INSTRUMENTATION TRACE HEADER DATA  */
FLD: QWHTLEN  LEN(2) TYPE(BIN) DISP(0)              /*LENGTH OF HEADER*/
FLD: QWHTTYP  LEN(1)               /*TYPE OF HEADER TRACE*/
FLD: QWHTFLG0 LEN(1)               /*FLAGS*/
COMP: QWHTALFG = X'20'             /*ON DATA USES ALET TOKEN*/
FLD: QWHTTID  TYPE(HALF)           /*ID SPECIFIED DSNWTRC MACRO*/
FLD: QWHTTAG  LEN(1)               /*TAG SPECIFIED DSNWTRC MACRO*/
FLD: QWHTFUNC LEN(1)               /*FUNC SPECIFIED DSNWTRC MACRO*/
FLD: QWHTEB   TYPE(FULL)           /*EB ADDRESS*/
FLD: QWHTPASI TYPE(HALF)           /*PASID EPAR*/
*  /*FOLLOWING FIELDS BELONG TO CALLERS MODULE WHICH INVOKED TRACE*/
FLD: QWHTR14A TYPE(HALF)           /*REGISTER 14 ASID*/
FLD: QWHTR14  TYPE(FULL)           /*REGISTER 14*/
FLD: QWHTR15  TYPE(FULL)           /*REGISTER 15*/
FLD: QWHTR0   TYPE(FULL)           /*REGISTER 0*/
FLD: QWHTR1   TYPE(FULL)           /*REGISTER 1*/
FLD: QWHTEXU  TYPE(FULL)           /*ADDRESS OF MVS EXECUTION UNIT*/
FLD: QWHTDIM  TYPE(HALF)           /*NUMBER OF DATA ITEMS*/
FLD: QWHTHASI TYPE(HALF)           /*HOME ASID*/
FLD: QWHTFUNCG TYPE(HALF)          /*FUNC SPECIFIED DSNWTRC MACRO */
*  /*THE FOLLOWING FIELDS REPEAT FOR EACH  DATA ITEM              */
FLD: QWHTDATA TYPE(FULL) DISP(*+2) /*ADDRESS OF THE DATA*/
FLD: QWHTFLAG TYPE(HALF)           /*FLAGS IN THE TRACE LIST*/
FLD: QWHTDATL TYPE(HALF)           /*LENGTH OF THE DATA*/
FLD: QWHTEND  TYPE(FULL)
FLD: QWHTALET TYPE(FULL) DISP(48)  /*ALET TOKEN FOR DATA FIELD*/
*


***********************************************************************
*    QWHC    DSNDQWHC  *  CORRELATION HEADER PRESENT ON ACCOUNTING
***********************************************************************
**** QWHC     DSECT                                                     
FLD: QWHC     DISP(0) LEN(1) OFFSET(QWHC_OFFSET)
*
*/*****************************************************************/
*/*                                                               */
*/*             INSTRUMENTATION CORRELATION DATA                  */
*/*                                                               */
*/*****************************************************************/
*
FLD: QWHCLEN  LEN(2) TYPE(BIN) DISP(0)
                                  /*LENGTH OF THE CORRELATION HEADER*/
FLD: QWHCTYP  LEN(1)               /*TYPE OF HEADER CORRELATION 2*/
*
*/*****************************************************************/
*/*  FOLLOWING VALUES ARE OBTAINED WHEN THE RECORD IS WRITTEN     */
*/*****************************************************************/
*
FLD: QWHCAID  LEN(8) DISP(4)       /*%U AUTHORIZATION ID*/
*                                  /*   Truncated if QWHCAID_Off¬=0  */
FLD: QWHCCV   LEN(12)              /*CORRELATION ID VALUE*/
FLD: QWHCCN   LEN(8)   /*CONNECTION NAME (NOT VALID ON END OF MEMORY &*/
*                        REFLECTS THE MVS HOME ASID CONNECTION NAME) */
FLD: QWHCPLAN LEN(8)               /*PLAN NAME*/
FLD: QWHCOPID LEN(8)               /*%U ORIGINAL OPERATOR ID*/
*                                  /*   Truncated if QWHCOPID_Off¬=0 */
FLD: QWHCATYP TYPE(FULL)           /*CONNECTING SYSTEM TYPE CODE*/
FLD: QWHCTOKN LEN(22)              /*ACCOUNTING TOKEN*/
FLD: QWHCRES2 LEN(2)               /*RESERVED*/
FLD: QWHCEUID LEN(16)              /*THE END USER'S USERID AT THE*/
*                                  /* USER'S WORKSTATION.            */
*                                  /*   Truncated if QWHCOPID_Off¬=0 */
FLD: QWHCEUTX LEN(32)              /*THE END USER'S TRANSACTION NAME.*/
FLD: QWHCEUWN LEN(18)              /*THE END USER'S WORKSTATION NAME.*/
*
FLD: QWHCAID_OFF TYPE(HALF)        /*Offset from QWHC to*/
*                                  /*   AUTHORIZATION ID             */
*                                  /*   If QWHCAID truncated         */
FLD: QWHCOPID_OFF TYPE(HALF)       /*Offset from QWHC to*/
*                                  /*   ORIGINAL OPERATOR ID         */
*                                  /*   If QWHCOPID truncated        */
FLD: QWHCEUID_OFF TYPE(HALF)       /*Offset from QWHC to*/
*                                  /*   THE END USER'S USERID        */
*                                  /*   If QWHCEUID truncated        */
*                                  /* Trusted context and role data  */
*                                  /* will be present if the record  */
*                                  /* is written by an agent running */
*                                  /* under a trusted context and    */
*                                  /* the trusted context data can   */
*                                  /* be accessed.                   */
FLD: QWHCTCXT_OFF TYPE(HALF)       /*Offset from QWHC to*/
*                                  /* Trusted Context name, if       */
*                                  /* running in a trusted context   */
FLD: QWHCROLE_OFF TYPE(HALF)       /*Offset from QWHC to*/
*                                  /* Role name associated with the  */
*                                  /* Authorization ID, if running   */
*                                  /* in a trusted context           */
FLD: QWHCOAUD_OFF TYPE(HALF)       /*Offset from QWHC to original*/
*                                  /* application USERID             */
FLD: QWHCCTKN_OFF TYPE(HALF)       /*Offset from QWHC to*/
*                                  /* the correlation token.         */
*                                  /* V9-Present only if QWHSSUBV    */
*                                  /*    is 1 or higher.             */
FLD: QWHCEND  TYPE(FULL)
*
*

**** QWHCAID_D    Dsect                 /* Use if QWHCAID_Off¬=0     
COMP: QWHCAID_D_OFFSET = 
        WHEN(QWHCAID_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCAID_Off)
        ELSE                   ASSIGN(99999)
   
FLD: QWHCAID_D DISP(0) LEN(1) OFFSET(QWHCAID_D_OFFSET)
                                  /*Use if QWHCAID_Off¬ 0*/
FLD: QWHCAID_LEN TYPE(HALF) DISP(0)/*Length of the following field*/
FLD: QWHCAID_VAR LEN(128)          /*%U AUTHORIZATION ID*/
*
*

**** QWHCOPID_D   Dsect                 /* Use if QWHCOPID_Off¬=0      
COMP: QWHCOPID_D_OFFSET = 
        WHEN(QWHCOPID_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCOPID_Off)
        ELSE                    ASSIGN(99999)

FLD: QWHCOPID_D DISP(0) LEN(1) OFFSET(QWHCOPID_D_OFFSET)
                                  /*Use if QWHCOPID_Off¬ 0*/
FLD: QWHCOPID_LEN TYPE(HALF) DISP(0)   /*Length of the following field*/
FLD: QWHCOPID_VAR LEN(128)         /*%U ORIGINAL OPERATOR ID*/
*
*

**** QWHCEUID_D   Dsect                 /* Use if QWHCEUID_Off¬=0      
COMP: QWHCEUID_D_OFFSET = 
        WHEN(QWHCEUID_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCEUID_Off)
        ELSE                    ASSIGN(99999)

FLD: QWHCEUID_D DISP(0) LEN(1) OFFSET(QWHCEUID_D_OFFSET)
                                  /*Use if QWHCEUID_Off¬ 0*/
FLD: QWHCEUID_LEN TYPE(HALF) DISP(0)   /*Length of the following field*/
FLD: QWHCEUID_VAR LEN(128)         /*END USER'S USERID*/
*
*

**** QWHCTCXT_D   Dsect                 /* Use if QWHCTCXT_Off¬=0      
COMP: QWHCTCXT_D_OFFSET = 
        WHEN(QWHCTCXT_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCTCXT_Off)
        ELSE                    ASSIGN(99999)

FLD: QWHCTCXT_D DISP(0) LEN(1) OFFSET(QWHCTCXT_D_OFFSET)
                                  /*Use if QWHCTCXT_Off¬ 0*/
FLD: QWHCTCXT_LEN TYPE(HALF) DISP(0)   /*Length of the following field*/
FLD: QWHCTCXT_VAR LEN(128)         /*%U Trusted Context name*/
*
*

**** QWHCROLE_D   Dsect                 /* Use if QWHCROLE_Off¬=0      
COMP: QWHCROLE_D_OFFSET = 
        WHEN(QWHCROLE_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCROLE_Off)
        ELSE                    ASSIGN(99999)

FLD: QWHCROLE_D DISP(0) LEN(1) OFFSET(QWHCROLE_D_OFFSET)
                                  /*Use if QWHCROLE_Off¬ 0*/
FLD: QWHCROLE_LEN TYPE(HALF) DISP(0)   /*Length of the following field*/
FLD: QWHCROLE_VAR LEN(128)         /*%U Role name associated with*/
*                                  /*    authid                      */
*
*

**** QWHCOAUD_D   Dsect                 /* Use if QWHCOAUD_Off¬=0      
COMP: QWHCOAUD_D_OFFSET = 
        WHEN(QWHCOAUD_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCOAUD_Off)
        ELSE                    ASSIGN(99999)

FLD: QWHCOAUD_D DISP(0) LEN(1) OFFSET(QWHCOAUD_D_OFFSET)
                                  /*Use if QWHCOAUD_Off¬ 0*/
FLD: QWHCOAUD_LEN TYPE(HALF) DISP(0)   /*Length of the following field*/
FLD: QWHCOAUD_VAR LEN(128)         /*%U Original application USERID*/
*
*

**** QWHCCTKN_D   Dsect                 /* Use if QWHCCTKN_Off¬=0      
COMP: QWHCCTKN_D_OFFSET = 
        WHEN(QWHCCTKN_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCCTKN_Off)
        ELSE                    ASSIGN(99999)

FLD: QWHCCTKN_D DISP(0) LEN(1) OFFSET(QWHCCTKN_D_OFFSET)
                                  /*Use if QWHCCTKN_Off¬ 0*/
FLD: QWHCCTKN_LEN TYPE(HALF) DISP(0)   /*Length of the following field*/
FLD: QWHCCTKN_VAR LEN(128)         /*%U Correlation token.*/
*
*
*/*****************************************************************/
*/*      CONNECTION SYSTEM TYPE CONSTANTS                         */
*/*****************************************************************/
*
COMP: QWHCTSO = X'1'               /*TSO FOREGROUND AND BACKGROUND*/
COMP: QWHCDB2C = X'2'              /*DB2 CALL ATTACH*/
COMP: QWHCDLIB = X'3'              /*DL/I BATCH*/
COMP: QWHCCICS = X'4'              /*CICS ATTACH*/
COMP: QWHCIMSB = X'5'              /*IMS ATTACH BMP*/
COMP: QWHCIMSM = X'6'              /*IMS ATTACH MPP*/
COMP: QWHCDUW = X'7'               /*DB2 PRIVATE PROTOCOL*/
COMP: QWHCRUW = X'8'               /*DRDA PROTOCOL*/
COMP: QWHCICTL = X'9'              /*IMS CONTROL REGION*/
COMP: QWHCTBMP = X'A'              /*IMS TRANSACTION BMP*/
COMP: QWHCUTIL = X'B'              /*DB2 UTILITIES*/
COMP: QWHCTRRS = X'C'              /*RRSAF ATTACH*/


***********************************************************************
*    QWHD    DSNDQWHD  *  DISTRIBUTED HEADER PRESENT ON ACCOUNTING
***********************************************************************
**** QWHD     DSECT                                                     
FLD: QWHD     DISP(0) LEN(1) OFFSET(QWHD_OFFSET)
*
*/********************************************************************/
*/*             INSTRUMENTATION DISTRIBUTED DATA                     */
*/********************************************************************/
*
FLD: QWHDLEN  LEN(2) TYPE(BIN) DISP(0)
                                  /*LENGTH OF THE DISTRIBUTED HEADER*/
FLD: QWHDTYP  LEN(1)               /*TYPE OF HEADER DISTRIBUTED 16*/
*
*/********************************************************************/
*/* THE FOLLOWING VALUES ARE OBTAINED WHEN THE RECORD IS WRITTEN     */
*/********************************************************************/
*
FLD: QWHDRQNM LEN(16) DISP(4)
                         /*%U REQUESTER LOCATION NAME BLANK IF HEADER*/
*                            IS WRITTEN AT APPLICATION REQUESTER SITE
*                            THE NAME BY WHICH DB2 KNOWS THE APPLI-
*                            REQUESTER
*                            Truncated if QWHDRQNM_Off¬=0
FLD: QWHDTSTP LEN(8)               /*TIMESTAMP FOR DBAT TRACE RECORDS*/
FLD: QWHDSVNM LEN(16)     /*%U SRVNAM PARAMETER OF DRDA EXCSAT COMMAND*/
*                            WHAT A DRDA REQUESTER CALLS ITSELF.
*                            FOR PRIVATE PROTOCOLS SAME AS QWHDRQNM.
*                            ZEROES IF HEADER IS WRITTEN AT
*                            APPLICATION REQUESTER SITE.
*                            Truncated if QWHDSVNM_Off¬=0
FLD: QWHDPRID LEN(8)          /*PRDID PARAMETER OF DRDA ACCRDB COMMAND*/
*                            PRODUCT ID OF APPLICATION REQUESTER.
*                            FOR PRIVATE PROTOCOLS THIS FIELD WILL
*                            BE SET TO AN APPROPRIATE PRODUCT ID VALUE
*                            ZEROES IF HEADER IS WRITTEN AT APPLICA-
*                            TION REQUESTER SITE.
FLD: QWHDRQNM_OFF TYPE(HALF)       /*Offset from QWHD to*/
*                            REQUESTER LOCATION NAME
*                            If QWHDRQNM truncated
FLD: QWHDSVNM_OFF TYPE(HALF)       /*Offset from QWHD*/
*                            SRVNAM PARAMETER OF DRDA EXCSAT COMMAND
*                            If QWHDSVNM truncated
FLD: QWHDEND  TYPE(FULL)
*
*
*

**** QWHDRQNM_D   Dsect        Use if QWHDRQNM_Off¬=0  
COMP: QWHDRQNM_D_OFFSET = 
        WHEN(QWHDRQNM_Off <> 0) ASSIGN(QWHD_OFFSET + QWHDRQNM_Off)
        ELSE                    ASSIGN(99999)
                 
FLD: QWHDRQNM_D DISP(0) LEN(1) OFFSET(QWHDRQNM_D_OFFSET) 
FLD: QWHDRQNM_LEN TYPE(HALF) DISP(0)   /*Length of the following field*/
FLD: QWHDRQNM_VAR LEN(128)         /*%U REQUESTER LOCATION NAME*/
*
*
*

**** QWHDSVNM_D   Dsect        Use if QWHDSVNM_Off¬=0                  
COMP: QWHDSVNM_D_OFFSET = 
        WHEN(QWHDSVNM_Off <> 0) ASSIGN(QWHD_OFFSET + QWHDSVNM_Off)
        ELSE                    ASSIGN(99999)
                 
FLD: QWHDSVNM_D DISP(0) LEN(1) OFFSET(QWHDSVNM_D_OFFSET) 
FLD: QWHDSVNM_LEN TYPE(HALF) DISP(0)   /*Length of the following field*/
FLD: QWHDSVNM_VAR LEN(128)
                         /*%U SRVNAM PARAMETER OF DRDA EXCSAT COMMAND*/


***********************************************************************
*                                                                     *
* SMF 100 RECORD  SUBTYPE 0 (IFCID 1) FOLLOWS                         *
*                                                                     *
***********************************************************************
 
***********************************************************************
* DB2 DSNDQWST SUBTYPE=0 STATISTICS RECORD SECTION MAPPING FPR        *
* SYSTEM SERVICES STATISTICS.  THE RECORD IS WRITTEN TO SMF AS A SMF  *
* TYPE 100 RECORD.                                                    *
*(SEE SYSTEM PLANNING AND ADMINISTRATION GUIDE FOR ADDITIONAL DETAIL) *
***********************************************************************
*   DSECT   MACRO      *  DESCRIPTION OF SECTIONS IN RECORD           *
*                                                                     *
*  NOTE: FIELDS DEFINED AS CHARACTER MAY CONTAIN HEX DATA             *
*-------------------------------------------------------------------- *
*   SM100   DSNDQWST   *  SMF HEADER SECTION                          *
*---------------------------------------------------------------------*
*                      * IFCID 0001 FOLLOWS
*                      *
*   QWS0    DSNDQWS0   *  SELF DEFINING SECTION - NOTE: USE OFFSETS
*                      *   IN QWS0 TO GET TO THE FOLLOWING SECTIONS
*----------------------*   BECAUSE THEIR EXACT POSITION VARIES
*                      *
*                      * See DSNDQWS0 for parsing algorithm for
*                      * varying length repeating group section(s):
*                      * QLST
*                      *
*                      *FOLLOWING SECTIONS BEGIN ON A WORD BOUNDARY
*                      *  PRODUCT SECTION. THE SECTION
*                      *  NORMALLY APPEARS AT THE END OF RECORD
*   QWHS    DSNDQWHS   *   STANDARD HEADER ALWAYS APPEARS
*    QWHC    DSNDQWHC  *    CORRELATION HEADER MAY APPEAR
*    QWHT    DSNDQWHT  *    TRACE HEADER MAY APPEAR
*    QWHU    DSNDQWHU  *    CPU   HEADER MAY APPEAR
*    QWHD    DSNDQWHD  *    DISTRIBUTED HEADER MAY APPEAR
*    QWHA    DSNDQWHA  *    DATA SHARING HEADER
*   QWSA    DSNDQWSA   *   CONTROL ADDRESS SPACES STATISTICS
*   QWSB    DSNDQWSB   *   IFC DESTINATION STATISTICS
*   QWSC    DSNDQWSC   *   IFCID STATISTICAL INFORMATION
*   Q3ST    DSNDQ3ST   *   SUBSYSTEM SUPORT STATISTICS
*   Q9ST    DSNDQ9ST   *   COMMAND STATISTICS
*   QWSD    DSNDQWSD   *   IFC CHECKPOINT INFORMATION - RELEASE 2
*   QVLS    DSNDQVLS   *   LATCH   STATISTICS
*   QVAS    DSNDQVAS   *   AGENT SERVICES STATISTICS
*   QSST    DSNDQSST   *   STORAGE MANAGER STATISTICS
*   QLST    DSNDQLST   *   DDF STATISTICS - V2R2
*   QJST    DSNDQJST   *   LOG MANAGER STATISTICS
*   QDST    DSNDQDST   *   DDF SYSTEM STATISTICS
*   QWOS    DSNDQWOS   *   ZOS SYSTEM STATISTICS
************************
***********************************************************************
**** QWS0     DSECT                                                     
***********************************************************************

COMP: QWS0_OFFSET =
           WHEN(SM100RTY=100 AND QWHSIID = 1) ASSIGN(28)
           ELSE                               ASSIGN(99999)
FLD: QWS0     DISP(0) LEN(1) OFFSET(QWS0_OFFSET)
* DB2 SELF DEFINING SECTION MACRO FOR SYSTEM STATISTICS (IFCID=0001)
*
*   PRODUCT SECTION FOR SYSTEM STATISTICS CONTAINS THE
*   STANDARD HEADER MAPPED BY DSNDQWHS
FLD: QWS00PSO LEN(4) TYPE(BIN) DISP(0)
                                  /*OFFSET TO THE PRODUCT SECTION*/
FLD: QWS00PSL LEN(2) TYPE(BIN) DISP(4)
                                  /*LENGTH OF THE PRODUCT SECTION*/
FLD: QWS00PSN LEN(2) TYPE(BIN) DISP(6)   /*NUMBER OF PRODUCT SECTIONS*/
* FOR RMID 026 MAPPED BY DSNDQWSA
FLD: QWS00R1O LEN(4) TYPE(BIN) DISP(8)   /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R1L LEN(2) TYPE(BIN) DISP(12)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R1N LEN(2) TYPE(BIN) DISP(14)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 026 MAPPED BY DSNDQWSB
FLD: QWS00R2O LEN(4) TYPE(BIN) DISP(16)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R2L LEN(2) TYPE(BIN) DISP(20)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R2N LEN(2) TYPE(BIN) DISP(22)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 026 MAPPED BY DSNDQWSC
FLD: QWS00R3O LEN(4) TYPE(BIN) DISP(24)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R3L LEN(2) TYPE(BIN) DISP(28)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R3N LEN(2) TYPE(BIN) DISP(30)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID     MAPPED BY DSNDQ3ST   SSSC
FLD: QWS00R4O LEN(4) TYPE(BIN) DISP(32)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R4L LEN(2) TYPE(BIN) DISP(36)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R4N LEN(2) TYPE(BIN) DISP(38)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID     MAPPED BY DSNDQ9ST    COMMAND PROCESSING
FLD: QWS00R5O LEN(4) TYPE(BIN) DISP(40)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R5L LEN(2) TYPE(BIN) DISP(44)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R5N LEN(2) TYPE(BIN) DISP(46)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 26  MAPPED BY DSNDQWSD - CHECKPOINT INFO - NEW RELEASE 2
FLD: QWS00R6O LEN(4) TYPE(BIN) DISP(48)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R6L LEN(2) TYPE(BIN) DISP(52)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R6N LEN(2) TYPE(BIN) DISP(54)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID     MAPPED BY DSNDQVLS     LATCH MANAGER
FLD: QWS00R7O LEN(4) TYPE(BIN) DISP(56)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R7L LEN(2) TYPE(BIN) DISP(60)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R7N LEN(2) TYPE(BIN) DISP(62)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID     MAPPED BY DSNDQVAS     ASMC
FLD: QWS00R8O LEN(4) TYPE(BIN) DISP(64)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R8L LEN(2) TYPE(BIN) DISP(68)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R8N LEN(2) TYPE(BIN) DISP(70)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID     MAPPED BY DSNDQSST      STORAGE MANAGER
FLD: QWS00R9O LEN(4) TYPE(BIN) DISP(72)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R9L LEN(2) TYPE(BIN) DISP(76)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R9N LEN(2) TYPE(BIN) DISP(78)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 16  MAPPED BY DSNDQWTR   TRACE - DELETED IN RELEASE 2
* DDF - CHANGE
* FOR RMID     MAPPED BY DSNDQLST     DDF - V2R2
FLD: QWS00RAO LEN(4) TYPE(BIN) DISP(80)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00RAL LEN(2) TYPE(BIN) DISP(84)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00RAN LEN(2) TYPE(BIN) DISP(86)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 004 MAPPED BY  DSNDQJST      LOG MANAGER
FLD: QWS00RBO LEN(4) TYPE(BIN) DISP(88)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00RBL LEN(2) TYPE(BIN) DISP(92)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS00RBN LEN(2) TYPE(BIN) DISP(94)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID     MAPPED BY DSNDQDST     DDF SYSTEM STATISTICS
FLD: QWS00RCO LEN(4) TYPE(BIN) DISP(96)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS00RCL LEN(2) TYPE(BIN) DISP(100) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00RCN LEN(2) TYPE(BIN) DISP(102)    /*NUMBER OF DATA SECTIONS*/
* FOR RMID     MAPPED BY DSNDQWOS     ZOS SYSTEM STATISTICS
FLD: QWS00RDO LEN(4) TYPE(BIN) DISP(104) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00RDL LEN(2) TYPE(BIN) DISP(108) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00RDN LEN(2) TYPE(BIN) DISP(110)    /*NUMBER OF DATA SECTIONS*/
FLD: QWS00END LEN(1) DISP(112)    /*END OF THE SELF DEFINING SECTION*/
*


***********************************************************************
* DB2 DSNDQWST SUBTYPE=1 STATISTICS RECORD SECTION MAPPING FOR        *
* DATA BASE SERVICES STATISTICS.  THE RECORD IS WRITTEN TO SMF AS     *
* A TYPE 100 RECORD.                                                  *
*(SEE SYSTEM PLANNING AND ADMINISTRATION GUIDE FOR ADDITIONAL DETAIL) *
***********************************************************************
*   DSECT   MACRO      *  DESCRIPTION OF SECTIONS IN RECORD           *
*---------------------------------------------------------------------*
*   SM100   DSNDQWST   *  SMF HEADER SECTION                          *
*
*  NOTE: FIELDS DEFINED AS CHARACTER MAY CONTAIN HEX DATA
*---------------------------------------------------------------------*
*                      * IFCID 0002 FOLLOWS
*   QWS1    DSNDQWS1   *  SELF DEFINING SECTION - NOTE: USE OFFSETS
*                      *   IN QWS1 TO GET TO THE FOLLOWING SECTIONS
*----------------------*   BECAUSE THEIR EXACT POSITION VARIES
*                      *FOLLOWING SECTIONS BEGIN ON A WORD BOUNDARY
*                      *  PRODUCT SECTION. THE SECTION
*                      *  NORMALLY APPEARS AT THE END OF RECORD
*   QWHS    DSNDQWHS   *   STANDARD HEADER ALWAYS APPEARS
*    QWHC    DSNDQWHC  *    CORRELATION HEADER MAY APPEAR
*    QWHT    DSNDQWHT  *    TRACE HEADER MAY APPEAR
*    QWHU    DSNDQWHU  *    CPU   HEADER MAY APPEAR
*    QWHD    DSNDQWHD  *    DISTRIBUTED HEADER MAY APPEAR
*    QWHA    DSNDQWHA  *    DATA SHARING HEADER
*   QXST    DSNDQXST   *   SQL  STATISTICS
*   QTST    DSNDQTST   *   SERVICE CONTROLLER STATISTICS
*   QBST    DSNDQBST   *   BUFFER MANAGER STATISTICS
*   QIST    DSNDQIST   *   DATA MANAGER STATISTICS - V2R2
*   QTXA    DSNDQTXA   *   LOCKING STATISTICS
*   QISE    DSNDQISE   *   EDM POOL STATISTICS - RELEASE 2
*   QBGL    DSNDQBGL   *   Buffer Manager Data Sharing Stats - V4R1
*   QTGS    DSNDQTGS   *   Service Controller Data Sharing Stats - V4R1
*   QLES    DSNDQLES   *   LE STATISTICS
*   QISJ    DSNDQISJ   *   STARJOIN POOL STATISTICS (S)
************************
***********************************************************************
**** QWS1     DSECT                                                     
***********************************************************************

COMP: QWS1_OFFSET =
           WHEN(SM100RTY=100 AND QWHSIID = 2) ASSIGN(28)
           ELSE                               ASSIGN(99999)
FLD: QWS1     DISP(0) LEN(1) OFFSET(QWS1_OFFSET)
* DB2 SELF DEFINING SECTION MACRO FOR DATA BASE STATISTICS IFCID=0002
*
* PRODUCT SECTION FOR DATA BASE STATISTICS CONTAINS THE
* STANDARD HEADER MAPPED BY DSNDQWHS
FLD: QWS10PSO LEN(4) TYPE(BIN) DISP(0)
                                  /*OFFSET TO THE PRODUCT SECTION*/
FLD: QWS10PSL LEN(2) TYPE(BIN) DISP(4)
                                  /*LENGTH OF THE PRODUCT SECTION*/
FLD: QWS10PSN LEN(2) TYPE(BIN) DISP(6)   /*NUMBER OF PRODUCT SECTIONS*/
* FOR RMID 22    MAPPED BY DSNDQXST       SQL
FLD: QWS10R1O LEN(4) TYPE(BIN) DISP(8)   /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R1L LEN(2) TYPE(BIN) DISP(12)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R1N LEN(2) TYPE(BIN) DISP(14)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 20    MAPPED BY DSNDQTST  SERVICE CONTROLLER
FLD: QWS10R2O LEN(4) TYPE(BIN) DISP(16)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R2L LEN(2) TYPE(BIN) DISP(20)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R2N LEN(2) TYPE(BIN) DISP(22)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 10    MAPPED BY DSNDQBST     BUFFER MANAGER
FLD: QWS10R3O LEN(4) TYPE(BIN) DISP(24)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R3L LEN(2) TYPE(BIN) DISP(28)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R3N LEN(2) TYPE(BIN) DISP(30)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 14    MAPPED BY DSNDQIST    DATA MANAGER
FLD: QWS10R4O LEN(4) TYPE(BIN) DISP(32)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R4L LEN(2) TYPE(BIN) DISP(36)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R4N LEN(2) TYPE(BIN) DISP(38)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 20    MAPPED BY DSNDQTXA   **  LOCK MANAGER
FLD: QWS10R5O LEN(4) TYPE(BIN) DISP(40)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R5L LEN(2) TYPE(BIN) DISP(44)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R5N LEN(2) TYPE(BIN) DISP(46)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 14    MAPPED BY DSNDQISE   EDM POOL STATISTICS
FLD: QWS10R6O LEN(4) TYPE(BIN) DISP(48)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R6L LEN(2) TYPE(BIN) DISP(52)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R6N LEN(2) TYPE(BIN) DISP(54)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 10    MAPPED BY DSNDQBGL   GROUP BUFFER POOL STATISTICS
FLD: QWS10R7O LEN(4) TYPE(BIN) DISP(56)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R7L LEN(2) TYPE(BIN) DISP(60)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R7N LEN(2) TYPE(BIN) DISP(62)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 20    MAPPED BY DSNDQTGS   GLOBAL LOCKING STATISTICS
FLD: QWS10R8O LEN(4) TYPE(BIN) DISP(64)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R8L LEN(2) TYPE(BIN) DISP(68)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R8N LEN(2) TYPE(BIN) DISP(70)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 22    MAPPED BY DSNDQLES LE ACCESS FROM ADMF STATISTICS
FLD: QWS10R9O LEN(4) TYPE(BIN) DISP(72)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R9L LEN(2) TYPE(BIN) DISP(76)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R9N LEN(2) TYPE(BIN) DISP(78)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 22    MAPPED BY DSNDQISJ STARJOIN POOL STATISTICS
FLD: QWS10RAO LEN(4) TYPE(BIN) DISP(80)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10RAL LEN(2) TYPE(BIN) DISP(84)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10RAN LEN(2) TYPE(BIN) DISP(86)     /*NUMBER OF DATA SECTIONS*/
* FOR RMID 033 MAPPED BY DSNDQ8ST    ACCEL SVCS SYSTEM STATISTICS     
FLD: QWS10RBO LEN(4) TYPE(BIN) DISP(88)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS10RBL LEN(2) TYPE(BIN) DISP(92)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS10RBN LEN(2) TYPE(BIN) DISP(94)   /*NUMBER OF DATA SECTIONS **/
FLD: QWS10END LEN(1) DISP(96)     /*END OF THE SELF DEFINING SECTION*/


*******************************************************************
*   QWSA    DSNDQWSA   *   CONTROL ADDRESS SPACES STATISTICS
*******************************************************************
***********************************************************************
**** QWSA     DSECT                                                     
***********************************************************************

***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QWSA, USE:
*    INPUT: SMF100
*           NORMWHEN(SM100RTY=100)
*           NORMSMF(QWS00R1O)
***********************************************************************
COMP: QWSA_OFFSET =
           WHEN(SM100RTY=100 AND QWS00R1N > 0) ASSIGN(QWS00R1O)
           ELSE                                ASSIGN(99999)
FLD: QWSA     DISP(0) LEN(1) OFFSET(QWSA_OFFSET)
* INSTRUMENTATION STATISTICS DATA OF CPU TIMER VALUES FOR EACH
* RESOURCE MANAGER & CONTROL ADDRESS SPACE.
*
*  NOTE: FIELDS DEFINED AS CHARACTER MAY CONTAIN HEX DATA
*
FLD: QWSAPROC LEN(4) DISP(0)
                 /*LAST FOUR CHARACTERS OF THE PROCEDURE NAME USED TO*/
*                    START THE ADDRESS SPACE - OR A CONSTANT IDENTIFIER
FLD: QWSAEJST TYPE(STCKTIME) DISP(4)
                             /*JOB STEP TIMER VALUE FOR ADDRESS SPACE*/
FLD: QWSASRBT TYPE(STCKTIME) DISP(12)
                                  /*SRB TIMER VALUE FOR ADDRESS SPACE*/
*                    NOT INCLUDING CPU CONSUMED ON AN IBM ZIIP
FLD: QWSAASID TYPE(HALF) DISP(20) /*ASID OF THE ADDRESS SPACE*/
FLD: QWSAASCB LEN(4) TYPE(BIN) DISP(24)                  /*ASCB TOKEN*/
FLD: QWSAPSRB TYPE(STCKTIME) DISP(28)
                      /*PREEMPTABLE SRB TIMER VALUE FOR ADDRESS SPACE*/
*                    NOT INCLUDING CPU CONSUMED ON AN IBM ZIIP
FLD: QWSAPSRB_ZIIP TYPE(STCKTIME) DISP(36)
                         /*PREEMPTABLE SRB TIMER VALUE CONSUMED ON AN*/
*                    IBM zIIP FOR ADDRESS SPACE
FLD: QWSAEND  LEN(1) DISP(44)

*******************************************************************
*   QWSB    DSNDQWSB   *   IFC DESTINATION STATISTICS
*******************************************************************
***********************************************************************
**** QWSB     DSECT                                                     
***********************************************************************

***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QWSB, USE:
*    INPUT: SMF100
*           NORMWHEN(SM100RTY=100)
*           NORMSMF(QWS00R2O)
***********************************************************************
COMP: QWSB_OFFSET =
           WHEN(SM100RTY=100 AND QWS00R2N > 0) ASSIGN(QWS00R2O)
           ELSE                                ASSIGN(99999)
FLD: QWSB     DISP(0) LEN(1) OFFSET(QWSB_OFFSET)
*     /*INSTRUMENTATION STATISTICS DATA ON DESTINATION.
*                                              */
FLD: QWSBNM   LEN(4) DISP(0)
                       /*NAME OF THE EXTERNAL OR INTERNAL DESTINATION*/
*                     FOLLOWING ARE EXAMPLES OF DESTINATION VALUES:
*                     GTF, SMF
*                     RES = RESIDENT TRACE TABLE
*                     SRV = SERVICEABILITY
*                     SR1 = INTERNAL SPECIAL ACCOUNTING DESTINATION
*                            USED TO CALCULATE OPTIONAL DELTA TIMINGS*/
*                     SR2 = INTERNAL SPECIAL DESTINATION  FOR IFI READS
*                            USED TO RETURN DATA TO THE APPLICATION  */
***                     OPN = SPECIAL DESTINATION  FOR IFI READA BUFFERE
*                           RECORDS                                  */
* /* STATISTICS UPDATED WITH COMPARE & SWAP (+=YES,-=NO) */
FLD: QWSBSTAT LEN(4) TYPE(BIN) DISP(4)           /*STATISTIC COUNTERS*/
FLD: QWSBWSEQ LEN(4) TYPE(BIN) DISP(4)      /*+UNIQUE SEQUENCE NUMBER*/
FLD: QWSBSRSW LEN(4) TYPE(BIN) DISP(8)             /*+RECORDS WRITTEN*/
FLD: QWSBSRNW LEN(4) TYPE(BIN) DISP(12)        /*+RECORDS NOT WRITTEN*/
*
*                          THE FOLLOWING REASONS FOR FAILURE
*                         ARE GENERIC CATEGORIES. ERRORS CAN OCCUR
*                         BECAUSE THE EXTERNAL WRITER HAS A PROBLEM
*                         (SMF AND GTF).
*                         RECORDS CAN ALSO FAIL TO BE PROCESSED BY
*                         INTERNAL WRITERS (SR1, SR2, SRV, OPN, RES).
*
*                         ONLY EXTERNAL WRITER ERROR CATEGORIES
*                         ARE COMMENTED BELOW.
*
*                         INTERNAL WRITER ERRORS
*                         NORMALLY ARE CAUSED BECAUSE ASYNCHONOUS
*                         TRACE EVENTS OCCUR AND THE WRITER CANNOT
*                         PROCESS THE REQUEST. INTERNAL WRITER ERRORS
*                         ARE NOT A PROBLEM TO (SRV, SR1, RES,AND SR2)
*                         INTERNAL ERRORS TO OPN USUALLY INDICATE
*                         AN APPLICATION PROGRAM IS NOT PROCESSING
*                         RECORDS BEFORE THE BUFFER FILLS OR A OPX
*                         DESTINATION TRACE IS ACTIVE AND AN
*                         APPLICATION PROGRAM DOES NOT EXIST TO PROCES
*                         PROCESS THE RECORDS.
FLD: QWSBSBUF TYPE(HALF) DISP(16) /*BUFFER ERRORS*/
FLD: QWSBSACT TYPE(HALF) DISP(18) /*NOT ACTIVE ERRORS*/
FLD: QWSBSRNA TYPE(HALF) DISP(20) /*RECORD NOT ACCEPTED*/
FLD: QWSBSWF  TYPE(HALF) DISP(22) /*WRITER FAILURES*/
FLD: QWSBOTH  LEN(4) TYPE(BIN) DISP(24)                         /*(S)*/
FLD: QWSBOTH1 LEN(1) DISP(24)     /*(S)*/
FLD: QWSBOTH2 LEN(1) DISP(25)     /*(S)*/
FLD: QWSBOTH3 LEN(1) DISP(26)     /*(S)*/
FLD: QWSBOTH4 LEN(1) DISP(27)     /*(S)*/
FLD: QWSBEND  LEN(1) DISP(28)
*
*
*******************************************************************
*   QWSC    DSNDQWSC   *   IFCID STATISTICAL INFORMATION
*******************************************************************
***********************************************************************
**** QWSC     DSECT                                                     
***********************************************************************

***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QWSC, USE:
*    INPUT: SMF100
*           NORMWHEN(SM100RTY=100)
*           NORMSMF(QWS00R3O)
***********************************************************************
COMP: QWSC_OFFSET =
           WHEN(SM100RTY=100 AND QWS00R3N > 0) ASSIGN(QWS00R3O)
           ELSE                                ASSIGN(99999)
FLD: QWSC     DISP(0) LEN(1) OFFSET(QWSC_OFFSET)
*
*................................................................
*     IFCIDS RECORDED TO STATISTICS AS OF  08/31/91
*     IFCIDS EQU MAPPED BY DSNDQWHS
*
*        0001      SYSTEM RELATED STATISTICS
*        0002      DATA BASE RELATED STATISTICS
*        0003      ACCOUNTING
*        0004      START TRACE RECORDS
*        0005      STOP TRACE RECORDS
*        0106      DSNZPARM RECORDS
*        0140-0146 AUDIT RECORDS
*        0202      DYNAMIC DSNZPARM RECORDS
*................................................................
*          STATISTICS UPDATED USING COMPARE & SWAP (+=YES, -=NO)
FLD: QWSCIID  TYPE(HALF) DISP(0)  /*IFCID*/
FLD: QWSCSTAT LEN(4) TYPE(BIN) DISP(4)                   /*STATISTICS*/
FLD: QWSCISEQ LEN(4) TYPE(BIN) DISP(4)       /*+IFCID SEQUENCE NUMBER*/
*
*        THE FOLLWING COUNTS ARE UPDATED BY THE TRACE
*         WRITER. IF A IFCID IS ACTIVE TO MULTIPLE TRACES
*         DESTINATIONS, THEN THE RECORD COUNTS BELOW
*         MAY BE GREATER THAN THE IFCID SEQUENCE NUMBER (QWSCISEQ)
*
FLD: QWSCSRSW LEN(4) TYPE(BIN) DISP(8)             /*+RECORDS WRITTEN*/
FLD: QWSCSRNW LEN(4) TYPE(BIN) DISP(12)        /*+RECORDS NOT WRITTEN*/
FLD: QWSCSRND TYPE(HALF) DISP(16) /*RECORD NOT DESIRED*/
*          INSTALATION TURNED OFF, SEVERE ERROR
FLD: QWSCSBNA TYPE(HALF) DISP(18) /*BUFFER NOT AVAILABLE*/
FLD: QWSCSCF  TYPE(HALF) DISP(20) /*COLLECTION FAILURE*/
*          ABEND DURING COLLECTION, ERROR RETURN INFORMATION
FLD: QWSCOTH1 LEN(1) DISP(22)     /*(S)*/
FLD: QWSCOTH2 LEN(1) DISP(23)     /*(S)*/
FLD: QWSCEND  LEN(1) DISP(24)

*/********************************************************************/
*/*                                                                  */
*/*      SSSC (SSSS AND SSAM) STATISTICS BLOCK (Q3ST) - 13MAY81      */
*/*                                                                  */
*/********************************************************************/
*/*                                                                  */
*/*  - FUNCTION:                                                     */
*/*      THE Q3ST IS A BLOCK USED FOR ACCUMULATING STATISTICS FOR    */
*/*      SSSS AND SSAM RESOURCE MANAGERS                             */
*/*                                                                  */
*/*  - CREATED BY:         DSN3SSIN                                  */
*/*  - DELETED BY:         DSN3SSTM - WHEN THE POOL (SSGSCPHB) IS    */
*/*                            FREED AT SUBSYSTEM TERMINATION.       */
*/*  - STORAGE TYPE:       CLASS 2 (POOL WHOSE PHB IS POINTED        */
*/*                            TO BY SSGSCPHB).                      */
*/*  - POINTED TO BY:      SSGSQ3ST                                  */
*/*                        AMGSQ3ST                                  */
*/*  - NUMBER:             1                                         */
*/*  - DURATION:           UNTIL SSSS TERMINATION                    */
*/*  - METHOD OF ACCESS:   PL/S - %INCLUDE (COMPLETE BLOCK IS ALWAYS */
*/*                               GENERATED)                         */
*/*                        BAL - DSNDQ3ST MACRO ('HEADER' AREA NEVER */
*/*                              GENERATED - ONLY THE STATISTICS     */
*/*                              DATA PORTION IS GENERATED)          */
*/*                                                                  */
*/********************************************************************/
*/*

*******************************************************************
*   Q3ST    DSNDQ3ST   *   SUBSYSTEM SUPORT STATISTICS
*******************************************************************
***********************************************************************
**** Q3ST     DSECT                                                     
***********************************************************************

COMP: Q3ST_OFFSET =
           WHEN(SM100RTY=100 AND QWS00R4N > 0) ASSIGN(QWS00R4O)
           ELSE                                ASSIGN(99999)
FLD: Q3ST     DISP(0) LEN(1) OFFSET(Q3ST_OFFSET)
FLD: Q3STDATA LEN(4) TYPE(BIN) DISP(0)         /*DATA PORTION OF Q3ST*/
FLD: Q3STIDEN LEN(4) TYPE(BIN) DISP(0) /*SUCCESSFUL DSN3IDEN REQUESTS*/
FLD: Q3STSIGN LEN(4) TYPE(BIN) DISP(4) /*SUCCESSFUL DSN3SIGN REQUESTS*/
FLD: Q3STCTHD LEN(4) TYPE(BIN) DISP(8) /*SUCCESSFUL DSN3CTHD REQUESTS*/
FLD: Q3STTERM LEN(4) TYPE(BIN) DISP(12)
                                  /*SUCCESSFUL DSN3TERM REQUESTS*/
FLD: Q3STRIUR LEN(4) TYPE(BIN) DISP(16)
                                  /*SUCCESSFUL DSN3RIUR REQUESTS*/
FLD: Q3STPREP LEN(4) TYPE(BIN) DISP(20)
                                  /*SUCCESSFUL DSN3PREP REQUESTS*/
FLD: Q3STCOMM LEN(4) TYPE(BIN) DISP(24)
                                  /*SUCCESSFUL DSN3COMM REQUESTS*/
FLD: Q3STABRT LEN(4) TYPE(BIN) DISP(28)
                                  /*SUCCESSFUL DSN3ABRT REQUESTS*/
FLD: Q3STSYNC LEN(4) TYPE(BIN) DISP(32)
                                  /*SUCCESSFUL DSN3SYNC REQUESTS*/
FLD: Q3STEXIT LEN(4) TYPE(BIN) DISP(36)
                                  /*SUCCESSFUL DSN3EXIT REQUESTS*/
FLD: Q3STINDT LEN(4) TYPE(BIN) DISP(40)
                                  /*TOTAL NUMBER OF AGENTS HAVING*/
*                             GONE IN-DOUBT
FLD: Q3STMEOT LEN(4) TYPE(BIN) DISP(44)                  /*SSAM EOT'S*/
FLD: Q3STMEOM LEN(4) TYPE(BIN) DISP(48)                  /*SSAM EOM'S*/
FLD: Q3STSSSI LEN(4) TYPE(BIN) DISP(52)   /*TOTAL NUMBER OF SSI CALLS*/
*                             PROCESSED (SSSS)
FLD: Q3STCTHW LEN(4) TYPE(BIN) DISP(56)
                                  /*NUMBER OF DSN3CTHD WHICH WAITED*/
FLD: Q3STRDON LEN(4) TYPE(BIN) DISP(60) /*NUMBER OF READ ONLY COMMITS*/
FLD: Q3STHWIB LEN(4) TYPE(BIN) DISP(64)
                                 /*High water mark for IDBACK threads*/
FLD: Q3STHWIF LEN(4) TYPE(BIN) DISP(68)
                                 /*High water mark for IDFORE threads*/
FLD: Q3STHWCT LEN(4) TYPE(BIN) DISP(72)
                                /*High water mark for CTHREAD threads*/
FLD: Q3STDATL LEN(1)              /*Q3STDATA LENGTH OF DATA PORTION*/

*/* ---------------------------------------------------------------- */
*/*                                                                  */
*/*    Licensed Materials - Property of IBM                          */
*/*    5635-DB2                                                      */
*/*    (C) COPYRIGHT 1982, 2006 IBM Corp.  All Rights Reserved.      */
*/*                                                                  */
*/*    STATUS = Version 9                                            */
*/*                                                                  */
*/* DESCRIPTIVE NAME - GCPC SMF DATA MAPPING.                        */
*/*                                                                  */
*/* FUNCTION-                                                        */
*/*   THIS MACRO MAPS THE COMMAND STATISTICAL COUNTERS WHICH ARE     */
*/*   PASSED TO IFC FOR THE RMFTSTAT (STATISTICAL) BROADCAST.        */
*/*                                                                  */
*/*                                                                  */
*******************************************************************
*   Q9ST    DSNDQ9ST   *   COMMAND STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQ9ST DSECT                                                     
***********************************************************************

COMP: Q9ST_OFFSET =
           WHEN(SM100RTY=100 AND QWS00R5N > 0) ASSIGN(QWS00R5O)
           ELSE                                ASSIGN(99999)
FLD: DSNDQ9ST DISP(0) LEN(1) OFFSET(Q9ST_OFFSET)
FLD: Q9ST     LEN(256) DISP(0)    /*GCPC STATISTICAL COUNTER BLOCK*/
FLD: Q9STCTR0 LEN(4) TYPE(BIN) DISP(0)
                                  /*COUNTER, CMD DISPLAY DATABASE*/
FLD: Q9STCTR1 LEN(4) TYPE(BIN) DISP(4)  /*COUNTER, CMD DISPLAY THREAD*/
FLD: Q9STCTR2 LEN(4) TYPE(BIN) DISP(8) /*COUNTER, CMD DISPLAY UTILITY*/
FLD: Q9STCTR3 LEN(4) TYPE(BIN) DISP(12)   /*COUNTER, CMD RECOVER BSDS*/
FLD: Q9STCTR4 LEN(4) TYPE(BIN) DISP(16)
                                  /*COUNTER, CMD RECOVER INDOUBT*/
FLD: Q9STCTR5 LEN(4) TYPE(BIN) DISP(20) /*COUNTER, CMD START DATABASE*/
FLD: Q9STCTR6 LEN(4) TYPE(BIN) DISP(24)    /*COUNTER, CMD START TRACE*/
FLD: Q9STCTR7 LEN(4) TYPE(BIN) DISP(28)
                                  /*COUNTER, CMD START SUBSYSTEM*/
FLD: Q9STCTR8 LEN(4) TYPE(BIN) DISP(32)  /*COUNTER, CMD STOP DATABASE*/
FLD: Q9STCTR9 LEN(4) TYPE(BIN) DISP(36)     /*COUNTER, CMD STOP TRACE*/
FLD: Q9STCTRA LEN(4) TYPE(BIN) DISP(40) /*COUNTER, CMD STOP SUBSYSTEM*/
FLD: Q9STCTRB LEN(4) TYPE(BIN) DISP(44)   /*COUNTER, CMD TERM UTILITY*/
FLD: Q9STCTRC LEN(4) TYPE(BIN) DISP(48)      /*COUNTER, CMD DIS TRACE*/
FLD: Q9STCTRD LEN(4) TYPE(BIN) DISP(52)
                                  /*COUNTER, CMD RESET GENERICLU*/
FLD: Q9STEROR LEN(4) TYPE(BIN) DISP(56)
                                  /*COUNTER, UNRECOGNIZED COMMAND*/
FLD: Q9STCTRE LEN(4) TYPE(BIN) DISP(60)   /*COUNTER, CMD START RLIMIT*/
FLD: Q9STCTRF LEN(4) TYPE(BIN) DISP(64)    /*COUNTER, CMD STOP RLIMIT*/
FLD: Q9STCTRG LEN(4) TYPE(BIN) DISP(68) /*COUNTER, CMD DISPLAY RLIMIT*/
FLD: Q9STCTRH LEN(4) TYPE(BIN) DISP(72)   /*COUNTER, CMD MODIFY TRACE*/
FLD: Q9STCTRI LEN(4) TYPE(BIN) DISP(76)      /*COUNTER, CMD START DDF*/
FLD: Q9STCTRJ LEN(4) TYPE(BIN) DISP(80)       /*COUNTER, CMD STOP DDF*/
FLD: Q9STCTRK LEN(4) TYPE(BIN) DISP(84)
                                  /*COUNTER, CMD CANCEL(DDF)THREAD*/
FLD: Q9STCTRL LEN(4) TYPE(BIN) DISP(88)
                                  /*COUNTER, CMD DISPLAY LOCATION*/
FLD: Q9STCTRM LEN(4) TYPE(BIN) DISP(92)    /*COUNTER, CMD ARCHIVE LOG*/
FLD: Q9STCTRN LEN(4) TYPE(BIN) DISP(96)
                                  /*COUNTER, CMD ALTER BUFFERPOOL*/
FLD: Q9STCTRO LEN(4) TYPE(BIN) DISP(100)
                                  /*COUNTER, CMD DISPLAY BUFFERPOOL*/
FLD: Q9STCTRP LEN(4) TYPE(BIN) DISP(104)   /*COUNTER, CMD SET ARCHIVE*/
FLD: Q9STCTRQ LEN(4) TYPE(BIN) DISP(108)
                                  /*COUNTER, CMD DISPLAY ARCHIVE*/
FLD: Q9STCTRR LEN(4) TYPE(BIN) DISP(112) /*COUNTER, CMD RESET INDOUBT*/
FLD: Q9STCTRS LEN(4) TYPE(BIN) DISP(116)  /*COUNTER, CMD ALTER GBPOOL*/
FLD: Q9STCTRT LEN(4) TYPE(BIN) DISP(120)
                                  /*COUNTER, CMD DISPLAY GBPOOL*/
FLD: Q9STCTRU LEN(4) TYPE(BIN) DISP(124)
                                  /*COUNTER, CMD DISPLAY PROCEDURE*/
FLD: Q9STCTRV LEN(4) TYPE(BIN) DISP(128)
                                  /*COUNTER, CMD START PROCEDURE*/
FLD: Q9STCTRW LEN(4) TYPE(BIN) DISP(132)
                                  /*COUNTER, CMD STOP PROCEDURE*/
FLD: Q9STCTRX LEN(4) TYPE(BIN) DISP(136)     /*COUNTER, CMD DIS GROUP*/
FLD: Q9STCTRY LEN(4) TYPE(BIN) DISP(140) /*COUNTER, CMD ALTER UTILITY*/
FLD: Q9STCTRZ LEN(4) TYPE(BIN) DISP(144)
                                  /*COUNTER, CMD DISPLAY FUNCTION*/
FLD: Q9STCTX0 LEN(4) TYPE(BIN) DISP(148)
                                  /*COUNTER, CMD START FUNCTION*/
FLD: Q9STCTX1 LEN(4) TYPE(BIN) DISP(152) /*COUNTER, CMD STOP FUNCTION*/
FLD: Q9STCTX2 LEN(4) TYPE(BIN) DISP(156)       /*COUNTER, CMD SET LOG*/
FLD: Q9STCTX3 LEN(4) TYPE(BIN) DISP(160)   /*COUNTER, CMD DISPLAY LOG*/
FLD: Q9STCTX4 LEN(4) TYPE(BIN) DISP(164)   /*COUNTER, CMD SET SYSPARM*/
FLD: Q9STCTX5 LEN(4) TYPE(BIN) DISP(168)   /*COUNTER, CMD DISPLAY DDF*/
FLD: Q9STCTAD LEN(4) TYPE(BIN) DISP(172)
                                  /*COUNTER, CMD ACCESS DATABASE*/
FLD: Q9STCTSS LEN(4) TYPE(BIN) DISP(176) /*COUNTER, CMD START PROFILE*/
FLD: Q9STCTST LEN(4) TYPE(BIN) DISP(180)  /*COUNTER, CMD STOP PROFILE*/
FLD: Q9STCTSD LEN(4) TYPE(BIN) DISP(184)
                                  /*COUNTER, CMD DISPLAY PROFILE*/

*******************************************************************
*   QWSD    DSNDQWSD   *   IFC CHECKPOINT INFORMATION - RELEASE 2
*******************************************************************
***********************************************************************
**** QWSD     DSECT                                                     
***********************************************************************

COMP: QWSD_OFFSET =
           WHEN(SM100RTY=100 AND QWS00R6N > 0) ASSIGN(QWS00R6O)
           ELSE                                ASSIGN(99999)
FLD: QWSD     DISP(0) LEN(1) OFFSET(QWSD_OFFSET)
*       MISCELLANEOUS IFC PROVIDED STATISTICS
*
FLD: QWSDCKPT LEN(4) TYPE(BIN) DISP(0)         /*DB2 CHECKPOINT COUNT*/
*
FLD: QWSDRINV LEN(4) TYPE(BIN) DISP(4)
                                  /*REASON WHY STATISTICS WAS INVOKED*/
*                                   04 = DB2 START UP
*                                   08 = DB2 SHUT DOWN
*                                   0C = BY COMMAND
*                                   10 = ACTIVATED BY TIMER
*                                   14 = ACTIVATED AT CHECKPOINT
*                                   18 = ACTIVATED DURING ACCOUNTING
*                                   1C = READS REQUEST
*                                   20 = RESERVED                   */
*
FLD: QWSDLR   LEN(8) DISP(8)      /*HIGH USED RBA ADDRESS OF LOG*/
*
*   THE IFI COUNTERS ARE NOT UPDATED USING COMPARE AND SWAP
*
FLD: QWSDSCA  LEN(4) TYPE(BIN) DISP(16)         /*COUNT OF IFI ABENDS*/
FLD: QWSDSCU  LEN(4) TYPE(BIN) DISP(20)
                                /*COUNT OF IFI UNRECOGNIZED FUNCTIONS*/
FLD: QWSDSCCO LEN(4) TYPE(BIN) DISP(24)
                                  /*COUNT OF IFI COMMAND REQUESTS*/
FLD: QWSDSCRA LEN(4) TYPE(BIN) DISP(28) /*COUNT OF IFI READA REQUESTS*/
FLD: QWSDSCRS LEN(4) TYPE(BIN) DISP(32) /*COUNT OF IFI READS REQUESTS*/
FLD: QWSDSCWR LEN(4) TYPE(BIN) DISP(36) /*COUNT OF IFI WRITE REQUESTS*/
FLD: QWSDCDCS LEN(4) TYPE(BIN) DISP(40) /*IFI DATA CAPTURE STATISTICS*/
FLD: QWSDCDLC LEN(4) TYPE(BIN) DISP(40)
                                 /*NUMBER OF LOG RECORDS CAPTURED FOR*/
*                           /* WHICH DATA CAPTURE PROCESSING WAS     */
*                           /* INVOKED.                              */
FLD: QWSDCDLR LEN(4) TYPE(BIN) DISP(44)
                                  /*NUMBER OF DATA CAPTURE LOG READS*/
*                           /* PERFORMED.                            */
FLD: QWSDCDRR LEN(4) TYPE(BIN) DISP(48)
                                 /*NUMBER OF DATA CAPTURE LOG RECORDS*/
*                           /* RETURNED.                             */
FLD: QWSDCDDR LEN(4) TYPE(BIN) DISP(52)
                                  /*NUMBER OF DATA CAPTURE DATA ROWS*/
*                           /* RETURNED.                             */
*                           /* DATA CAPTURE DATA ROWS ARE RETURNED   */
*                           /* IN IFCID 185 AND MAPPED BY QW0185DR.  */
FLD: QWSDCDDD LEN(4) TYPE(BIN) DISP(56) /*NUMBER OF DATA CAPTURE DATA*/
*                           /* DESCRIPTIONS RETURNED. DATA CAPTURE   */
*                           /* DATA DESCRIPTIONS ARE MAPPED IN IFCID */
*                           /* 185 BEGINNING WITH FIELD QW0185DD.    */
FLD: QWSDCDMB LEN(4) TYPE(BIN) DISP(60)
                                  /*NUMBER OF DATA CAPTURE DESCRIBES*/
*                           /* PERFORMED.                            */
FLD: QWSDCDTB LEN(4) TYPE(BIN) DISP(64)
                                  /*NUMBER OF DATA CAPTURE TABLES FOR*/
*                           /* WHICH DATA CAPTURE DATA DESCRIPTIONS  */
*                           /* WERE RETURNED.                        */
FLD: QWSDARTH LEN(4) TYPE(BIN) DISP(68)
                                /*Number of rollup accounting records*/
*                           /* written due to rollup threshold       */
*                           /* exceeded                              */
FLD: QWSDARSG LEN(4) TYPE(BIN) DISP(72)
                                /*Number of rollup accounting records*/
*                           /* written due to rollup accounting      */
*                           /* storage threshold exceeded            */
FLD: QWSDARST LEN(4) TYPE(BIN) DISP(76)
                                /*Number of rollup accounting records*/
*                           /* written due to staleness threshold    */
*                           /* exceeded                              */
FLD: QWSDARIR LEN(4) TYPE(BIN) DISP(80)
                               /*Number of records failing to qualify*/
*                           /* for accounting rollup due to all      */
*                           /* rollup key fields = NULL or NULL      */
*                           /* values not being permitted            */
FLD: QWSDEND  LEN(1) DISP(84)


*******************************************************************
*   QVLS    DSNDQVLS   *   LATCH   STATISTICS
*******************************************************************
***********************************************************************
**** QVLS     DSECT                                                     
***********************************************************************

COMP: QVLS_OFFSET =
           WHEN(SM100RTY=100 AND QWS00R7N > 0) ASSIGN(QWS00R7O)
           ELSE                                ASSIGN(99999)
FLD: QVLS     DISP(0) LEN(1) OFFSET(QVLS_OFFSET)
*! The QVLS counts represent the number of suspends performed
*! by agents attempting to obtain a latch.  There is NOT a
*! 1 to 1 relationship between the QVLS counters and
*! IFCID56/57 since an agent may suspend multiple times or
*! not at all while trying to obtain a latch.  Thus, the
*! QVLS counters are not directly related to accounting
*! class 3.
*!
*! IMPORTANT NOTE: All field descriptions denote the
*! predominate latch usage. The description does NOT
*! cover all usage of a given latch class.
FLD: QVLSLC01 LEN(4) TYPE(BIN) DISP(0)            /*Infrequently used*/
FLD: QVLSLC02 LEN(4) TYPE(BIN) DISP(4)   /*Global authorization cache*/
FLD: QVLSLC03 LEN(4) TYPE(BIN) DISP(8)               /*DDF disconnect*/
FLD: QVLSLC04 LEN(4) TYPE(BIN) DISP(12)             /*SYSSTRING cache*/
FLD: QVLSLC05 LEN(4) TYPE(BIN) DISP(16)     /*IRLM data sharing exits*/
*                           /* or RLF                      */
FLD: QVLSLC06 LEN(4) TYPE(BIN) DISP(20)    /*Data sharing index split*/
FLD: QVLSLC07 LEN(4) TYPE(BIN) DISP(24)         /*Index lotch and OBD*/
*                           /* allocation                  */
FLD: QVLSLC08 LEN(4) TYPE(BIN) DISP(28)           /*Query parallelism*/
FLD: QVLSLC09 LEN(4) TYPE(BIN) DISP(32)         /*Utilities or stored*/
*                           /* procedure URIDs             */
FLD: QVLSLC10 LEN(4) TYPE(BIN) DISP(36)       /*Allied agent chain or*/
*                           /* sequence descriptors        */
FLD: QVLSLC11 LEN(4) TYPE(BIN) DISP(40)             /*DGTT allocation*/
FLD: QVLSLC12 LEN(4) TYPE(BIN) DISP(44) /*Global transaction ID table*/
FLD: QVLSLC13 LEN(4) TYPE(BIN) DISP(48)          /*Pageset operations*/
FLD: QVLSLC14 LEN(4) TYPE(BIN) DISP(52)              /*Bufferpool LRU*/
FLD: QVLSLC15 LEN(4) TYPE(BIN) DISP(56)   /*ARCHIVE LOG MODE(QUIESCE)*/
FLD: QVLSLC16 LEN(4) TYPE(BIN) DISP(60)                    /*UR chain*/
FLD: QVLSLC17 LEN(4) TYPE(BIN) DISP(64)                  /*RURE chain*/
FLD: QVLSLC18 LEN(4) TYPE(BIN) DISP(68)            /*DDF resynch list*/
FLD: QVLSLC19 LEN(4) TYPE(BIN) DISP(72)                   /*Log write*/
FLD: QVLSLC20 LEN(4) TYPE(BIN) DISP(76)           /*System checkpoint*/
FLD: QVLSLC21 LEN(4) TYPE(BIN) DISP(80)           /*Accounting rollup*/
FLD: QVLSLC22 LEN(4) TYPE(BIN) DISP(84)         /*Internal checkpoint*/
FLD: QVLSLC23 LEN(4) TYPE(BIN) DISP(88)              /*Buffer manager*/
FLD: QVLSLC24 LEN(4) TYPE(BIN) DISP(92)        /*EDM pool or prefetch*/
FLD: QVLSLC25 LEN(4) TYPE(BIN) DISP(96)         /*Workfile allocation*/
FLD: QVLSLC26 LEN(4) TYPE(BIN) DISP(100)    /*Dynamic statement cache*/
FLD: QVLSLC27 LEN(4) TYPE(BIN) DISP(104)       /*Stored procedures or*/
*                           /* authorization cache         */
FLD: QVLSLC28 LEN(4) TYPE(BIN) DISP(108)       /*Stored procedures or*/
*                           /* authorization cache         */
FLD: QVLSLC29 LEN(4) TYPE(BIN) DISP(112)        /*Field procs and DDF*/
*                           /* transaction manager         */
FLD: QVLSLC30 LEN(4) TYPE(BIN) DISP(116)             /*Agent services*/
FLD: QVLSLC31 LEN(4) TYPE(BIN) DISP(120)            /*Storage manager*/
FLD: QVLSLC32 LEN(4) TYPE(BIN) DISP(124)            /*Storage manager*/
FLD: QVLSLC254 LEN(4) TYPE(BIN) DISP(128)               /*Index lotch*/
FLD: QVLSEND  LEN(1) DISP(132)


*******************************************************************
*   QVAS    DSNDQVAS   *   AGENT SERVICES STATISTICS
*******************************************************************
***********************************************************************
**** QVAS     DSECT                                                     
***********************************************************************

COMP: QVAS_OFFSET =
           WHEN(SM100RTY=100 AND QWS00R8N > 0) ASSIGN(QWS00R8O)
           ELSE                                ASSIGN(99999)
FLD: QVAS     DISP(0) LEN(1) OFFSET(QVAS_OFFSET)
*        /* ASMC STATISTICS COUNTER DCL  */
FLD: QVASSUSP LEN(4) TYPE(BIN) DISP(0)                          /*(S)*/
FLD: QVASXSUS LEN(4) TYPE(BIN) DISP(4)                          /*(S)*/
FLD: QVASXSUT LEN(4) TYPE(BIN) DISP(8)                          /*(S)*/
FLD: QVASXAUS LEN(4) TYPE(BIN) DISP(12)                         /*(S)*/
FLD: QVASXAUT LEN(4) TYPE(BIN) DISP(16)                         /*(S)*/
FLD: QVASXSRS LEN(4) TYPE(BIN) DISP(20)                         /*(S)*/
FLD: QVASXSRT LEN(4) TYPE(BIN) DISP(24)                         /*(S)*/
FLD: QVASADUR LEN(4) TYPE(BIN) DISP(28)                         /*(S)*/
FLD: QVASADDL LEN(4) TYPE(BIN) DISP(32)                         /*(S)*/
FLD: QVASADIR LEN(4) TYPE(BIN) DISP(36)                         /*(S)*/
FLD: QVASCBOS LEN(4) TYPE(BIN) DISP(40)                         /*(S)*/
FLD: QVASCBOF LEN(4) TYPE(BIN) DISP(44)                         /*(S)*/
FLD: QVASMBOS LEN(4) TYPE(BIN) DISP(48)                         /*(S)*/
FLD: QVASMBOF LEN(4) TYPE(BIN) DISP(52)                         /*(S)*/
FLD: QVASEND  LEN(1) DISP(56)     /*END*/


*******************************************************************
*   QSST    DSNDQSST   *   STORAGE MANAGER STATISTICS
*******************************************************************
***********************************************************************
****          DSECT ,                                                        
***********************************************************************

COMP: QSST_OFFSET =
           WHEN(SM100RTY=100 AND QWS00R9N > 0) ASSIGN(QWS00R9O)
           ELSE                                ASSIGN(99999)
FLD: QSST_DSECT DISP(0) LEN(1) OFFSET(QSST_OFFSET)
FLD: QSST     LEN(8) DISP(0)      /*CONTROL BLOCK NAME*/
FLD: QSSTHEAD LEN(4) TYPE(BIN) DISP(0)                /*! QSST header*/
FLD: QSSTID   LEN(2) DISP(0)      /*! ID*/
FLD: QSSTLEN  TYPE(HALF) DISP(2)  /*! Length*/
FLD: QSSTDESC LEN(4) DISP(4)      /*! Eye catchers*/
FLD: QSSTDATA LEN(4) TYPE(BIN) DISP(8)    /*! Serviceability counters*/
FLD: QSSTGPLF LEN(4) TYPE(BIN) DISP(8)         /*! (S) Get fixed pool*/
FLD: QSSTFPLF LEN(4) TYPE(BIN) DISP(12)       /*! (S) Free fixed pool*/
FLD: QSSTFREF LEN(4) TYPE(BIN) DISP(16)
                                /*! (S) Freemained segments in 31 bit*/
*                           !     fixed pools                          
FLD: QSSTEXPF LEN(4) TYPE(BIN) DISP(20)
                                /*! (S) Extensions getmained in fixed*/
*                           !     pools                                
FLD: QSSTCONF LEN(4) TYPE(BIN) DISP(24)
                                /*! (S) Contracted segments in 31 bit*/
*                           !     fixed pools                          
FLD: QSSTGPLV LEN(4) TYPE(BIN) DISP(28)     /*! (S) Get variable pool*/
FLD: QSSTFPLV LEN(4) TYPE(BIN) DISP(32)    /*! (S) Free variable pool*/
FLD: QSSTFREV LEN(4) TYPE(BIN) DISP(36)
                                /*! (S) Freemained segments in 31 bit*/
*                           !     variable pools                       
FLD: QSSTEXPV LEN(4) TYPE(BIN) DISP(40)
                               /*! (S) Extensions getmained in 31 bit*/
*                           !     variable pools                       
FLD: QSSTCONV LEN(4) TYPE(BIN) DISP(44)
                                /*! (S) Contracted segments in 31 bit*/
*                           !     variable pools                       
FLD: QSSTGETM LEN(4) TYPE(BIN) DISP(48)
                                  /*! (S) 31 bit getmain request*/
FLD: QSSTFREM LEN(4) TYPE(BIN) DISP(52)
                                  /*! (S) 31 bit freemain request*/
FLD: QSSTRCNZ LEN(4) TYPE(BIN) DISP(56)
                               /*! (S) Conditional 31 bit get request*/
*                           !     failure due to local storage         
*                           !     shortage                             
FLD: QSSTCONT LEN(4) TYPE(BIN) DISP(60)
                                  /*! (S) Full system contractions*/
FLD: QSSTCRIT LEN(4) TYPE(BIN) DISP(64)
                              /*! (S) Critical storage shortage after*/
*                           !     contraction                     
FLD: QSSTABND LEN(4) TYPE(BIN) DISP(68)
                                  /*! (S) Abends due to local storage*/
*                           !     shortage                        
FLD: QSST_SGETM LEN(8) DISP(72) /*! (S) 31 bit stack request required*/
*                           !     a GETMAIN                       
FLD: QSST_SGETR LEN(8) TYPE(BIN) DISP(80)
                                 /*! (S) Number of out of line 31 bit*/
*                           !     stack get requests              
FLD: QSST_SGETEXT LEN(8) DISP(88)
                               /*! (S) 31 bit stack request satisfied*/
*                           !     via an available extension      
FLD: QSST_SFREEM LEN(8) DISP(96) /*! (S) 31 bit free request required*/
*                           !     a FREEMAIN                      
FLD: QSST_SFREER LEN(8) TYPE(BIN) DISP(104)
                                 /*! (S) Number of out of line 31 bit*/
*                           !     stack free requests             
FLD: QSST_D64POST LEN(8) TYPE(BIN) DISP(112)
                                 /*! (S) Number of out of line 64 bit*/
*                           !     stack deallocation requests     
FLD: QSST_A64POST LEN(8) TYPE(BIN) DISP(120)
                                 /*! (S) Number of out of line 64 bit*/
*                           !     stack allocation requests       
FLD: QSST_A64WAIT LEN(8) TYPE(BIN) DISP(128)
                                 /*! (S) Number of out of line 64 bit*/
*                           !     stack allocation requests that  
*                           !     resulted in a wait              
FLD: QSST_M64DISNUM LEN(8) TYPE(BIN) DISP(136)
                               /*! (S) Number of 64 bit stack segment*/
*                           !     that required a discard         
FLD: QSST_M64DISPGS LEN(8) TYPE(BIN) DISP(144)
                                 /*! (S) Number of 64 bit stack pages*/
*                           !     discarded                             
FLD: QSST_SGETR64 LEN(8) TYPE(BIN) DISP(152)
                                 /*! (S) Number of out of line 64 bit*/
*                           !     stack get requests                    
FLD: QSST_SGETEXT64 LEN(8) DISP(160)
                               /*! (S) 64 bit stack request satisfied*/
*                           !     via an available extension            
FLD: QSST_SGETDEXT64 LEN(8) DISP(168)
                                /*! (S) 64 bit stack request required*/
*                           !     an extension deallocation             
FLD: QSST_SFREER64 LEN(8) TYPE(BIN) DISP(176)
                                 /*! (S) Number of out of line 64 bit*/
*                           !     stack free requests                   
FLD: QSST_SFREEDEXT64 LEN(8) DISP(184)
                                  /*! (S) 64 bit stack free required*/
*                           !     an extension deallocation             
FLD: QSST_DISCARDMODE64 LEN(8) DISP(192)
                                  /*! (S) Real frame discard mode*/
FLD: QSST_RSMAX_WARN LEN(8) TYPE(BIN) DISP(200)
                              /*! (S) Number of times REALSTORAGE_MAX*/
*                           !     warning level was reached             
FLD: QSST_P64DISNUM LEN(8) TYPE(BIN) DISP(208)
                                  /*! (S) Number of 64 bit pools*/
*                           !     contracted                            
FLD: QSST_P64DISBLK LEN(8) TYPE(BIN) DISP(216)
                                 /*! (S) Number of 64 bit pool blocks*/
*                           !     that required a discard               
FLD: QSST_P64DISPGS LEN(8) TYPE(BIN) DISP(224)
                                  /*! (S) Number of 64 bit pool pages*/
*                           !     discarded                             
FLD: QSST_CONTSTOR_NUM LEN(8) TYPE(BIN) DISP(232)
                               /*! Number of 31 bit agent local pools*/
*                           ! contracted due to system configuration    
*                           ! parameter CONTSTOR being enabled          
FLD: QSSTEND  LEN(1) DISP(240)    /*! QSST end*/
COMP: QSSTIDEN = X'003C'          /*HEADER CONSTANT*/
COMP: QSSTEYEC = 'QSST'           /*EYE CATCHER CONSTANT*/


*******************************************************************
*   QLST    DSNDQLST   *   DDF STATISTICS - V2R2
*******************************************************************
***********************************************************************
**** QLST     DSECT                                                     
***********************************************************************

COMP: QLST_OFFSET =
           WHEN(SM100RTY=100 AND QWS00RAN > 0) ASSIGN(QWS00RAO)
           ELSE                                ASSIGN(99999)
FLD: QLST     DISP(0) LEN(1) OFFSET(QLST_OFFSET)
FLD: QLSTLOCN_OFF TYPE(HALF) DISP(0)            /*Offset from QLST to*/
*                              LOCATION NAME OF THE 'REMOTE'     
*                              SITE WITH WHICH THE               
*                              INFORMATION IS ASSOCIATED.        
*                              If QLSTLOCN truncated             
FLD: QLSTLOCN LEN(16) DISP(8)     /*%U LOCATION NAME OF THE 'REMOTE'*/
*                              SITE WITH WHICH THE               
*                              INFORMATION IS ASSOCIATED.        
*                              Truncated if QLSTLOCN_Off¬=0      
FLD: QLSTPRID LEN(8) DISP(24)     /*THE PRDID OF THE REMOTE LOCATION.*/
FLD: QLSTCNVS LEN(8) TYPE(BIN) DISP(32)
                                  /*NUMBER OF CONVERSATIONS THAT*/
*                              WERE INITIATED FROM THIS          
*                              SITE TO THE REMOTE SITE.          
*                              (MEANINGFUL AT AR ONLY).          
FLD: QLSTCNVT LEN(8) TYPE(BIN) DISP(40)
                                  /*NUMBER OF CONVERSATIONS THAT*/
*                              WERE DEALLOCATED FROM THIS        
*                              SITE TO THE REMOTE SITE           
*                              (MEANINGFUL AT AR ONLY).          
FLD: QLSTCNVR LEN(8) TYPE(BIN) DISP(48)
                                  /*NUMBER OF CONVERSATIONS THAT*/
*                              WERE INITIATED FROM THE           
*                              REMOTE SITE TO THIS SITE.         
*                              (MEANINGFUL AT AS ONLY).          
FLD: QLSTMSGS LEN(8) TYPE(BIN) DISP(56)  /*NUMBER OF MESSAGES SENT TO*/
*                              THE REMOTE SITE.                  
FLD: QLSTMSGR LEN(8) TYPE(BIN) DISP(64) /*NUMBER OF MESSAGES RECEIVED*/
*                              FROM THE REMOTE SITE.                    
FLD: QLSTSQLS LEN(8) TYPE(BIN) DISP(72)
                                  /*NUMBER OF SQL STATEMENTS SENT*/
*                              TO THE REMOTE SITE.                      
FLD: QLSTSQLR LEN(8) TYPE(BIN) DISP(80)    /*NUMBER OF SQL STATEMENTS*/
*                              RECEIVED FROM THE REMOTE SITE.           
FLD: QLSTBYTS LEN(8) TYPE(BIN) DISP(88)
                                  /*NUMBER OF BYTES OF DATA SENT*/
*                              TO THE REMOTE SITE.                      
FLD: QLSTBYTR LEN(8) TYPE(BIN) DISP(96)     /*NUMBER OF BYTES OF DATA*/
*                              RECEIVED FROM THE REMOTE SITE.           
FLD: QLSTROWS LEN(8) TYPE(BIN) DISP(104)
                                 /*NUMBER OF ROWS OF DATA SENT TO THE*/
*                              REMOTE SITE (INCLUDES THE SQLDA)         
FLD: QLSTROWR LEN(8) TYPE(BIN) DISP(112)     /*NUMBER OF ROWS OF DATA*/
*                              RETRIEVED FROM THE REMOTE SITE (THIS     
*                              COUNT DOES NOT INCLUDE                   
*                              EITHER THE SQLDA OR SQLCA                
*                              IF THEY ARE TRANSMITTED).                
FLD: QLSTBTBF LEN(8) TYPE(BIN) DISP(120)
                           /*NUMBER OF BLOCKS TRANSMITTED USING BLOCK*/
*                              FETCH (SERVER SITE ONLY).                
FLD: QLSTBRBF LEN(8) TYPE(BIN) DISP(128)
                              /*NUMBER OF BLOCKS RECEIVED USING BLOCK*/
*                              FETCH (REQUESTER SITE ONLY).             
FLD: QLSTCOMS LEN(8) TYPE(BIN) DISP(136)
                              /*NUMBER OF COMMIT REQUESTS SENT TO THE*/
*                              SERVER (SINGLE-PHASE COMMIT PROTOCOL)    
*                              AND COMMITED REQUESTS SENT TO THE        
*                              PARTICIPANT (TWO-PHASE COMMIT PROTOCOL). 
FLD: QLSTCOMR LEN(8) TYPE(BIN) DISP(144)
                        /*NUMBER OF COMMIT REQUESTS RECEIVED FROM THE*/
*                              REQUESTER (SINGLE-PHASE COMMIT PROTOCOL)
*                              AND COMMITED REQUESTS RECEIVED FROM THE 
*                              COORDINATOR (TWO-PHASE COMMIT PROTOCOL).
FLD: QLSTABRS LEN(8) TYPE(BIN) DISP(152)
                        /*NUMBER OF ABORT REQUESTS SENT TO THE SERVER*/
*                              (SINGLE-PHASE COMMIT PROTOCOL) AND      
*                              NUMBER OF BACKOUT REQUESTS SENT TO THE  
*                              PARTICIPANT (TWO-PHASE COMMIT PROTOCOL).
FLD: QLSTABRR LEN(8) TYPE(BIN) DISP(160)
                         /*NUMBER OF ABORT REQUESTS RECEIVED FROM THE*/
*                              REQUESTER (SINGLE-PHASE COMMIT PROTOCOL)
*                              AND NUMBER OF BACKOUT REQUESTS RECEIVED 
*                              FROM THE COORDINATOR (TWO-PHASE COMMIT  
*                              PROTOCOL)                               
FLD: QLSTINDT LEN(8) TYPE(BIN) DISP(168)
                     /*NUMBER OF THREADS THAT BECAME INDOUBT WITH THE*/
*                              REMOTE LOCATION AS THE COORDINATOR.     
FLD: QLSTCNVQ LEN(8) TYPE(BIN) DISP(176)
                                  /*NUMBER OF CONVERSATION REQUESTS*/
*                              QUEUED BY DDF WAITING FOR               
*                              ALLOCATION.                             
FLD: QLSTEND  LEN(4) TYPE(BIN) DISP(184)
*
*
***********************************************************************
**** QLSTLOCN_D DSECT       Use if QLSTLOCN_Off¬=0                     
***********************************************************************

COMP: QLSTLOCN_D_OFFSET =
           WHEN(SM100RTY=100 AND QWS00RAN > 0 AND QLSTLOCN_Off <> 0)
                                  ASSIGN(QWS00RAO + QLSTLOCN_Off)
           ELSE                   ASSIGN(99999)
FLD: QLSTLOCN_D DISP(0) LEN(1) OFFSET(QLSTLOCN_D_OFFSET)
                                  /*Use if QLSTLOCN_Off¬ 0*/
FLD: QLSTLOCN_LEN TYPE(HALF) DISP(0)  /*Length of the following field*/
FLD: QLSTLOCN_VAR LEN(128) DISP(2)/*%U LOCATION NAME OF THE 'REMOTE'*/
*                              SITE WITH WHICH THE
*                              INFORMATION IS ASSOCIATED.
*                              Truncated if QLSTLOCN_Off¬=0


*******************************************************************
*   QJST    DSNDQJST   *   LOG MANAGER STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQJST DSECT                                                     
***********************************************************************

COMP: QJST_OFFSET =
           WHEN(SM100RTY=100 AND QWS00RBN > 0) ASSIGN(QWS00RBO)
           ELSE                                ASSIGN(99999)
FLD: DSNDQJST DISP(0) LEN(1) OFFSET(QJST_OFFSET)
FLD: QJST     LEN(8) DISP(0)
FLD: QJSTID   LEN(2) DISP(0)      /*(S) CONTROL BLOCK ID X'0093'*/
FLD: QJSTLL   TYPE(HALF) DISP(2)  /*LENGTH OF BLOCK*/
FLD: QJSTEID  LEN(4) DISP(4)      /*EBCDIC EYECATCHER*/
FLD: QJSTWRW  LEN(4) TYPE(BIN) DISP(8)    /*WRITE REQUEST COUNT, WAIT*/
FLD: QJSTWRNW LEN(4) TYPE(BIN) DISP(12) /*WRITE REQUEST COUNT, NOWAIT*/
FLD: QJSTWRF  LEN(4) TYPE(BIN) DISP(16)  /*WRITE REQUEST COUNT, FORCE*/
FLD: QJSTWTB  LEN(4) TYPE(BIN) DISP(20)
                        /*WAIT COUNT DUE TO UNAVAILABLE ACTIVE BUFFER*/
FLD: QJSTRBUF LEN(4) TYPE(BIN) DISP(24)
                            /*LOG READS SATISFIED FROM OUTPUT BUFFERS*/
FLD: QJSTRACT LEN(4) TYPE(BIN) DISP(28)
                           /*READS SATISFIED FROM ACTIVE LOG DATA SET*/
FLD: QJSTRARH LEN(4) TYPE(BIN) DISP(32)
                          /*READS SATISFIED FROM ARCHIVE LOG DATA SET*/
FLD: QJSTTVC  LEN(4) TYPE(BIN) DISP(36)
                             /*NUMBER OF READ ACCESSES DELAYED DUE TO*/
*                           TAPE VOLUME CONTENTION
FLD: QJSTBSDS LEN(4) TYPE(BIN) DISP(40)  /*TOTAL BSDS ACCESS REQUESTS*/
FLD: QJSTBFFL LEN(4) TYPE(BIN) DISP(44)
                        /*ACTIVE LOG OUTPUT CONTROL INTERVALS CREATED*/
FLD: QJSTBFWR LEN(4) TYPE(BIN) DISP(48)
                         /*COUNT OF CALLS TO WRITE ACTIVE LOG BUFFERS*/
FLD: QJSTALR  LEN(4) TYPE(BIN) DISP(52)
                                  /*ARCHIVE LOG READ ALLOCATIONS*/
FLD: QJSTALW  LEN(4) TYPE(BIN) DISP(56)
                                  /*ARCHIVE LOG WRITE ALLOCATIONS*/
FLD: QJSTCIOF LEN(4) TYPE(BIN) DISP(60)
                               /*COUNT OF CONTROL INTERVALS OFFLOADED*/
FLD: QJSTWUR  LEN(4) TYPE(BIN) DISP(64)
                             /*NUMBER OF READ ACCESSES DELAYED DUE TO*/
*                           UNAVAILABLE RESOURCE
FLD: QJSTLAMA LEN(4) TYPE(BIN) DISP(68)
                            /*NUMBER OF LOOK AHEAD TAPE VOLUME MOUNTS*/
*                           ATTEMPTED.  THIS FIELD ALONG WITH FIELD
*                           QJSTLAMS, WILL SHOW HOW MANY TIMES LOOK-
*                           AHEAD MOUNTING FAILED, THUS NEGATING
*                           POTENTIAL SIGNIFICANT PERFORMANCE GAINS.
FLD: QJSTLAMS LEN(4) TYPE(BIN) DISP(72)
                            /*NUMBER OF LOOK AHEAD TAPE VOLUME MOUNTS*/
*                           PERFORMED.
FLD: QJSTLSUS LEN(4) TYPE(BIN) DISP(76)                         /*(S)*/
FLD: QJSTLOGW LEN(4) TYPE(BIN) DISP(80)
                            /*TOTAL NUMBER OF LOG WRITE I/O REQUESTS.*/
FLD: QJSTCIWR LEN(4) TYPE(BIN) DISP(84)
                                  /*TOTAL NUMBER OF LOG CI S WRITTEN.*/
FLD: QJSTSERW LEN(4) TYPE(BIN) DISP(88)
                            /*NUMBER OF SERIAL LOG WRITE REQUESTS FOR*/
*                           CI RE-WRITES WHEN DUAL LOGGING.
FLD: QJSTTHRW LEN(4) TYPE(BIN) DISP(92)
                            /*NUMBER OF TIMES A LOG WRITE REQUEST WAS*/
*                           SCHEDULED BECAUSE THE LOG WRITE THRESHOLD
*                           WAS REACHED.
FLD: QJSTBPAG LEN(4) TYPE(BIN) DISP(96)
                          /*NUMBER OF TIMES A LOG WRITE BUFFER HAD TO*/
*                           BE PAGED-IN BEFORE IT COULD BE USED.
FLD: QJSTSPNN LEN(4) TYPE(BIN) DISP(100)                        /*(S)*/
FLD: QJSTSPNI LEN(8) DISP(104)    /*(S)*/
FLD: QJSTEND  LEN(4) TYPE(BIN) DISP(112)


*******************************************************************
*   QDST    DSNDQDST   *   DDF SYSTEM STATISTICS
*******************************************************************
***********************************************************************
**** QDST     DSECT                                                     
***********************************************************************

COMP: QDST_OFFSET =
           WHEN(SM100RTY=100 AND QWS00RCN > 0) ASSIGN(QWS00RCO)
           ELSE                                ASSIGN(99999)
FLD: QDST     DISP(0) LEN(1) OFFSET(QDST_OFFSET)
*       DDF SYSTEM STATISTICS
*
FLD: QDSTQDBT LEN(4) TYPE(BIN) DISP(0)  /*NUMBER OF TIMES THAT A DBAT*/
*                                /* OR CONNECTION WAS QUEUED   */
*                                /* DUE TO HAVING REACHED THE  */
*                                /* ZPARM MAXIMUM FOR ACTIVE   */
*                                /* REMOTE THREADS (MAXDBAT).  */
*                                /* ALSO SEE QDSTNQR2.         */
FLD: QDSTCSTR LEN(4) TYPE(BIN) DISP(4)         /*NUMBER OF COLD START*/
*                                /* CONNECTIONS WITH ALL REMOTE*/
*                                /* LOCATIONS (TWO-PHASE       */
*                                /* COMMIT PROTOCOL ONLY).     */
FLD: QDSTWSTR LEN(4) TYPE(BIN) DISP(8)         /*NUMBER OF WARM START*/
*                                /* CONNECTIONS WITH ALL REMOTE*/
*                                /* LOCATIONS (TWO-PHASE       */
*                                /* COMMIT PROTOCOL ONLY).     */
FLD: QDSTRSAT LEN(4) TYPE(BIN) DISP(12) /*NUMBER OF RESYNCHRONIZATION*/
*                                /* CONNECTIONS ATTEMPTED WITH */
*                                /* ALL REMOTE LOCATIONS (TWO- */
*                                /* PHASE COMMIT PROTOCOL ONLY)*/
FLD: QDSTRSSU LEN(4) TYPE(BIN) DISP(16) /*NUMBER OF RESYNCHRONIZATION*/
*                                /* CONNECTIONS THAT SUCCEEDED */
*                                /* WITH ALL REMOTE LOCATIONS  */
*                                /* (TWO-PHASE COMMIT PROTOCOL */
*                                /* ONLY).                     */
FLD: QDSTQCRT LEN(4) TYPE(BIN) DISP(20)  /*NUMBER OF CONNECTIONS THAT*/
*                                /* WERE REJECTED DUE TO HAVING*/
*                                /* REACHED THE ZPARM LIMIT FOR*/
*                                /* MAXIMUM REMOTE CONNECTIONS */
*                                /* (CONDBAT).                 */
FLD: QDSTQCIT LEN(4) TYPE(BIN) DISP(24)       /*THE CURRENT NUMBER OF*/
*                                /* TYPE 1 INACTIVE DBATs      */
FLD: QDSTQMIT LEN(4) TYPE(BIN) DISP(28)       /*THE MAXIMUM NUMBER OF*/
*                                /* TYPE 1 INACTIVE DBATs THAT */
*                                /* EXISTED (HIGH WATER MARK)  */
FLD: QDSTCNAT LEN(4) TYPE(BIN) DISP(32)    /*CURRENT NUMBER OF ACTIVE*/
*                                /* AND DISCONNECTED (POOLED)  */
*                                /* DBATs.                     */
FLD: QDSTHWAT LEN(4) TYPE(BIN) DISP(36)   /*QDSTCNAT HIGH WATER MARK.*/
*                                /* MAXIMUM NUMBER OF ACTIVE   */
*                                /* AND DISCONNECTED (POOLED)  */
*                                /* DBATs THAT EXISTED.        */
FLD: QDSTHWDT LEN(4) TYPE(BIN) DISP(40)       /*THE MAXIMUM NUMBER OF*/
*                                /* REMOTE CONNECTIONS THAT    */
*                                /* EXISTED (HIGH WATER MARK). */
FLD: QDSTNITC LEN(4) TYPE(BIN) DISP(44)           /*NUMBER OF THREADS*/
*                                /* CONNECTIONS THAT WERE      */
*                                /* TERMINATED RATHER THAN MADE*/
*                                /* TYPE 1 INACTIVE BECAUSE THE*/
*                                /* MAXIMUM NUMBER OF TYPE 1   */
*                                /* INACTIVE THREADS WAS       */
*                                /* REACHED (MAXTYPE1).        */
FLD: QDSTCIN2 LEN(4) TYPE(BIN) DISP(48)  /*CURRENT NUMBER OF (TYPE 2)*/
*                                /* INACTIVE CONNECTIONS.      */
FLD: QDSTMIN2 LEN(4) TYPE(BIN) DISP(52)   /*QDSTCIN2 HIGH WATER MARK.*/
*                                /* MAXIMUM NUMBER OF          */
*                                /* CONCURRENT (TYPE 2)        */
*                                /* INACTIVE CONNECTIONS THAT  */
*                                /* HAVE EXISTED.              */
FLD: QDSTQIN2 LEN(4) TYPE(BIN) DISP(56)  /*NUMBER OF RECEIVE REQUESTS*/
*                                /* ON (TYPE 2) INACTIVE       */
*                                /* CONNECTIONS, OR NEW        */
*                                /* CONNECTIONS, THAT HAVE BEEN*/
*                                /* QUEUED TO BE SERVICED BY A */
*                                /* DISCONNECTED (POOLED) DBAT.*/
*                                /* ALSO SEE QDSTNQR2.         */
FLD: QDSTNQR2 LEN(4) TYPE(BIN) DISP(60)  /*CURRENT NUMBER OF (TYPE 2)*/
*                                /* INACTIVE CONNECTIONS, OR   */
*                                /* NEW CONNECTIONS, THAT ARE  */
*                                /* QUEUED WAITING TO BE       */
*                                /* SERVICED BY A DBAT.        */
*                                /* ALSO SEE QDSTNQMN,         */
*                                /* QDSTNQMX, AND QDSTNQAV.    */
FLD: QDSTMQR2 LEN(4) TYPE(BIN) DISP(64)   /*QDSTNQR2 HIGH WATER MARK.*/
*                                /* MAXIMUM NUMBER OF (TYPE 2) */
*                                /* INACTIVE CONNECTIONS, OR   */
*                                /* NEW CONNECTIONS, THAT WERE */
*                                /* QUEUED WAITING TO BE       */
*                                /* SERVICED BY A DBAT.        */
FLD: QDSTNADS LEN(4) TYPE(BIN) DISP(68)           /*CURRENT NUMBER OF*/
*                                /* DISCONNECTED (POOLED) DBATS*/
*                                /* THAT ARE AVAILABLE TO      */
*                                /* SERVICE WORK ON (TYPE 2)   */
*                                /* INACTIVE CONNECTIONS OR NEW*/
*                                /* CONNECTIONS.               */
FLD: QDSTMADS LEN(4) TYPE(BIN) DISP(72)   /*QDSTNADS HIGH WATER MARK.*/
*                                /* MAXIMUM NUMBER OF          */
*                                /* DISCONNECTED (POOLED) DBATS*/
*                                /* THAT WERE AVAILABLE TO     */
*                                /* SERVICE WORK ON (TYPE 2)   */
*                                /* INACTIVE CONNECTIONS OR NEW*/
*                                /* CONNECTIONS.               */
FLD: QDSTNDBA LEN(4) TYPE(BIN) DISP(76)     /*NUMBER OF REQUESTS THAT*/
*                                /* REQUIRED A DATA BASE ACCESS*/
*                                /* THREAD (DBAT) TO BE CREATED*/
*                                /* TO PROCESS THE REQUEST.    */
*                                /* NOTE THAT THIS DOES NOT    */
*                                /* INCLUDE DATA BASE ACCESS   */
*                                /* THREADS CREATED TO REPLACE */
*                                /* DISCONNECTED (POOL) DBATS  */
*                                /* THAT TERMINATED BECAUSE    */
*                                /* THEY REACHED THEIR REUSE   */
*                                /* LIMIT.                     */
FLD: QDSTPOOL LEN(4) TYPE(BIN) DISP(80)     /*NUMBER OF REQUESTS THAT*/
*                                /* WERE SATISFIED BY ASSIGNING*/
*                                /* A DISCONNECTED (POOL) DBAT */
*                                /* TO PROCESS THE REQUEST.    */
FLD: QDSTNCQC LEN(4) TYPE(BIN) DISP(84)     /*NUMBER OF QUEUED CLIENT*/
*                                /* CONNECTIONS WHICH HAVE HAD */
*                                /* THEIR TCP/IP SOCKETS CLOSED*/
*                                /* BECAUSE MAXDBAT WAS REACHED*/
*                                /* AND THE NUMBER OF INACTIVE */
*                                /* CONNECTIONS QUEUED, WAITING*/
*                                /* FOR A DBAT, HAS ALSO       */
*                                /* REACHED MAXDBAT IN NUMBER. */
FLD: QDSTNARD LEN(4) TYPE(BIN) DISP(88)    /*CURRENT NUMBER OF ACTIVE*/
*                                /* DBATS DUE TO PACKAGES BOUND*/
*                                /* WITH RELEASE(DEALLOCATE)   */
FLD: QDSTMARD LEN(4) TYPE(BIN) DISP(92)    /*MAXIMUM NUMBER OF ACTIVE*/
*                                /* DBATS DUE TO PACKAGES BOUND*/
*                                /* WITH RELEASE(DEALLOCATE)   */
FLD: QDSTNQMN LEN(8) DISP(96)     /*Relative to QDSTNQR2, the*/
*                                /* minimum queued duration    */
*                                /* for this statistics period.*/
*                                /* Note: Only statistics      */
*                                /*  records written due to an */
*                                /*  expired statistics timer  */
*                                /*  will cause the value to   */
*                                /*  be reset. Statistics      */
*                                /*  records written for IFI   */
*                                /*  READS, checkpoints, or    */
*                                /*  commands will not result  */
*                                /*  in a value reset.         */
*                                /* STCK format.               */
FLD: QDSTNQMX LEN(8) DISP(104)    /*Relative to QDSTNQR2, the*/
*                                /* maximum queued duration    */
*                                /* for this statistics period.*/
*                                /* Note: Only statistics      */
*                                /*  records written due to an */
*                                /*  expired statistics timer  */
*                                /*  will cause the value to   */
*                                /*  be reset. Statistics      */
*                                /*  records written for IFI   */
*                                /*  READS, checkpoints, or    */
*                                /*  commands will not result  */
*                                /*  in a value reset.         */
*                                /* STCK format.               */
FLD: QDSTNQAV LEN(8) DISP(112)    /*Relative to QDSTNQR2, the*/
*                                /* average queued duration    */
*                                /* for this statistics period.*/
*                                /* Note: Only statistics      */
*                                /*  records written due to an */
*                                /*  expired statistics timer  */
*                                /*  will cause the value to   */
*                                /*  be reset. Statistics      */
*                                /*  records written for IFI   */
*                                /*  READS, checkpoints, or    */
*                                /*  commands will not result  */
*                                /*  in a value reset.         */
*                                /* STCK format.               */
FLD: QDSTEND  LEN(1) DISP(120)


*******************************************************************
*   QWOS    DSNDQWOS   *   ZOS SYSTEM STATISTICS
*******************************************************************
***********************************************************************
**** QWOS     DSECT                                                     
***********************************************************************

COMP: QWOS_OFFSET =
           WHEN(SM100RTY=100 AND QWS00RDN > 0) ASSIGN(QWS00RDO)
           ELSE                                ASSIGN(99999)
FLD: QWOS     DISP(0) LEN(1) OFFSET(QWOS_OFFSET)
***********************************************************************
*   IFCID 0001 - DATA SECTION QWS00RDO(Z/OS METRICS)
***********************************************************************
*
FLD: QWOSLNCP LEN(4) TYPE(BIN) DISP(0)            /*NO OF CPS ON LPAR*/
FLD: QWOSLPRU LEN(4) TYPE(BIN) DISP(4)         /*CPU UTILIZATION LPAR*/
FLD: QWOSDB2U LEN(4) TYPE(BIN) DISP(8)   /*CPU UTILIZATION DB2 SUBSYS*/
FLD: QWOSMSTU LEN(4) TYPE(BIN) DISP(12)    /*CPU UTILIZATION DB2 MSTR*/
FLD: QWOSDBMU LEN(4) TYPE(BIN) DISP(16)    /*CPU UTILIZATION DB2 DBM1*/
FLD: QWOSLPIR LEN(4) TYPE(BIN) DISP(20)           /*PAGE IN RATE LPAR*/
FLD: QWOSDPIR LEN(4) TYPE(BIN) DISP(24)     /*PAGE IN RATE DB2 SUBSYS*/
FLD: QWOSLRST LEN(4) TYPE(BIN) DISP(28)  /*REAL STORAGE ON LPAR IN MB*/
FLD: QWOSLRSF LEN(4) TYPE(BIN) DISP(32)
                                  /*FREE REAL STORAGE LPAR IN MB*/
FLD: QWOSDRSU LEN(4) TYPE(BIN) DISP(36)
                                 /*USED REAL STORAGE DB2 SUBSYS IN MB*/
FLD: QWOSLVST LEN(4) TYPE(BIN) DISP(40)  /*VIRTUAL STORAGE LPAR IN MB*/
FLD: QWOSLVSF LEN(4) TYPE(BIN) DISP(44)
                                  /*FREE VIRTUAL STORAGE LPAR IN MB*/
FLD: QWOSDVSU LEN(4) TYPE(BIN) DISP(48)
                              /*USED VIRTUAL STORAGE DB2 SUBSYS IN MB*/
FLD: QWOSLUIC LEN(4) TYPE(BIN) DISP(52)
                                  /*UNREFERENCED INTERVAL COUNT @116*/
FLD: QWOSFLG  LEN(1) DISP(56)     /*(S) STATUS FLAG FOR RMF API @116*/
FLD: QWOSRCDE LEN(4) TYPE(BIN) DISP(60)
                                  /*(S) RETURN CODE FROM RMF API @116*/
FLD: QWOSRSNC LEN(4) TYPE(BIN) DISP(64)
                                  /*(S) REASON CODE from RMF API @116*/
FLD: QWOSEND  LEN(1) DISP(68)
*


*******************************************************************
*   QXST    DSNDQXST   *   SQL  STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQXST DSECT         TABLE OF SQL STMT COUNTERS                  
***********************************************************************

COMP: QXST_OFFSET =
           WHEN(SM100RTY=100 AND QWS10R1N > 0) ASSIGN(QWS10R1O)
           ELSE                                ASSIGN(99999)
FLD: DSNDQXST DISP(0) LEN(1) OFFSET(QXST_OFFSET)
                                  /*TABLE OF SQL STMT COUNTERS*/
FLD: QXST     LEN(8) DISP(0)      /*RDS ACCOUNTING AREA*/
FLD: QXHEAD   LEN(4) TYPE(BIN) DISP(0)         /*CONTROL BLOCK HEADER*/
FLD: QXID     TYPE(HALF) DISP(0)  /*CONTROL BLOCK ID*/
FLD: QXLEN    TYPE(HALF) DISP(2)  /*CONTROL BLOCK LENGTH*/
FLD: QXEYE    LEN(4) DISP(4)      /*CONTROL BLOCK EYE CATCHER*/
FLD: STMT     LEN(8) DISP(8)      /*OVERLAY ON QXSTATS*/
FLD: QXSTATS  LEN(8) DISP(8)      /*ACCOUNTING STATISTICS*/
FLD: QXSELECT LEN(8) TYPE(BIN) DISP(8)                 /*# OF SELECTS*/
FLD: QXINSRT  LEN(8) TYPE(BIN) DISP(16)                /*# OF INSERTS*/
FLD: QXUPDTE  LEN(8) TYPE(BIN) DISP(24)                /*# OF UPDATES*/
FLD: QXDELET  LEN(8) TYPE(BIN) DISP(32)                /*# OF DELETES*/
FLD: QXDESC   LEN(8) TYPE(BIN) DISP(40)              /*# OF DESCRIBES*/
FLD: QXPREP   LEN(8) TYPE(BIN) DISP(48)               /*# OF PREPARES*/
FLD: QXOPEN   LEN(8) TYPE(BIN) DISP(56)                  /*# OF OPENS*/
FLD: QXCLOSE  LEN(8) TYPE(BIN) DISP(64)                 /*# OF CLOSES*/
FLD: QXCRTAB  LEN(8) TYPE(BIN) DISP(72)           /*# OF CREATE TABLE*/
FLD: QXCRINX  LEN(8) TYPE(BIN) DISP(80)           /*# OF CREATE INDEX*/
FLD: QXCTABS  LEN(8) TYPE(BIN) DISP(88)      /*# OF CREATE TABLESPACE*/
FLD: QXCRSYN  LEN(8) TYPE(BIN) DISP(96)         /*# OF CREATE SYNONYM*/
FLD: QXCRDAB  LEN(8) TYPE(BIN) DISP(104)       /*# OF CREATE DATABASE*/
FLD: QXCRSTG  LEN(8) TYPE(BIN) DISP(112)  /*# OF CREATE STORAGE GROUP*/
FLD: QXDEFVU  LEN(8) TYPE(BIN) DISP(120)           /*# OF CREATE VIEW*/
FLD: QXDRPIX  LEN(8) TYPE(BIN) DISP(128)            /*# OF DROP INDEX*/
FLD: QXDRPTA  LEN(8) TYPE(BIN) DISP(136)            /*# OF DROP TABLE*/
FLD: QXDRPTS  LEN(8) TYPE(BIN) DISP(144)       /*# OF DROP TABLESPACE*/
FLD: QXDRPDB  LEN(8) TYPE(BIN) DISP(152)         /*# OF DROP DATABASE*/
FLD: QXDRPSY  LEN(8) TYPE(BIN) DISP(160)          /*# OF DROP SYNONYM*/
FLD: QXDRPST  LEN(8) TYPE(BIN) DISP(168)    /*# OF DROP STORAGE GROUP*/
FLD: QXDRPVU  LEN(8) TYPE(BIN) DISP(176)             /*# OF DROP VIEW*/
FLD: QXALTST  LEN(8) TYPE(BIN) DISP(184)   /*# OF ALTER STORAGE GROUP*/
FLD: QXFETCH  LEN(8) TYPE(BIN) DISP(192)                /*# OF FETCHS*/
FLD: QXALTTS  LEN(8) TYPE(BIN) DISP(200)      /*# OF ALTER TABLESPACE*/
FLD: QXALTTA  LEN(8) TYPE(BIN) DISP(208)           /*# OF ALTER TABLE*/
FLD: QXALTIX  LEN(8) TYPE(BIN) DISP(216)           /*# OF ALTER INDEX*/
FLD: QXCMTON  LEN(8) TYPE(BIN) DISP(224)            /*# OF COMMENT ON*/
FLD: QXLOCK   LEN(8) TYPE(BIN) DISP(232)            /*# OF LOCK TABLE*/
FLD: QXGRANT  LEN(8) TYPE(BIN) DISP(240)                 /*# OF GRANT*/
FLD: QXREVOK  LEN(8) TYPE(BIN) DISP(248)                /*# OF REVOKE*/
FLD: QXINCRB  LEN(8) TYPE(BIN) DISP(256)
                          /*# OF INCREMENTAL BINDS EXCLUDING PREPARES*/
FLD: QXLABON  LEN(8) TYPE(BIN) DISP(264)              /*# OF LABEL ON*/
FLD: QXSETSQL LEN(8) TYPE(BIN) DISP(272)   /*# OF Set Current SQLID 1*/
FLD: QXCRALS  LEN(8) TYPE(BIN) DISP(280)        /*# OF CREATE ALIAS 2*/
FLD: QXDRPAL  LEN(8) TYPE(BIN) DISP(288)          /*# OF DROP ALIAS 2*/
FLD: QXMIAP   LEN(8) TYPE(BIN) DISP(296)
                        /*# of times RID list processing used. This 9*/
*                           field is incremented once for a given     9
*                           table access for Index Access with list   9
*                           prefetch and for Multiple Index Access.   9
FLD: QXNSMIAP LEN(8) TYPE(BIN) DISP(304)
                           /*# of times a RID list was not used for 9*/
*                           a given RID list process involving one    9
*                           index (Index Access with list prefetch)   9
*                           or involving multiple indexes (Multiple   9
*                           Index Access) because no storage was      9
*                           available to hold the list of RIDs.       9
FLD: QXMRMIAP LEN(8) TYPE(BIN) DISP(312)
                        /*# of times one or more RID lists were not 9*/
*                           used for a given RID list process involving
*                           one indx (Index Access with list prefetch)9
*                           or involving multiple indexes (Multiple   9
*                           Index Access) because the number of RIDs  9
*                           exceeded one or more internal limits.     9
FLD: QXSETHV  LEN(8) TYPE(BIN) DISP(320)
                            /*# OF Set Host Variable statements, we 6*/
*                           don't trace the contents of the special   6
*                           register.                                 6
FLD: QXALDAB  LEN(8) TYPE(BIN) DISP(328)      /*# OF ALTER DATABASE 7*/
FLD: QXDRPPKG LEN(8) TYPE(BIN) DISP(336)
                                  /*# OF DROP PACKAGE STATEMENTS 8*/
FLD: QXDSCRTB LEN(8) TYPE(BIN) DISP(344)
                                  /*# OF DESCRIBE TABLE STATEMENTS 8*/
FLD: QXMAXDEG LEN(8) DISP(352)
                          /*Maximum degree of parallelism among the A*/
*                           parallel groups to indicate the extent to A
*                           which query parallelism applies.          A
FLD: QXTOTGRP LEN(8) TYPE(BIN) DISP(360)
                         /*Total number of parallel groups executed A*/
FLD: QXDEGCUR LEN(8) DISP(368)
                            /*Total number pf parallel groups which A*/
*                           fell back to sequential mode because the  A
*                           cursor may be used in UPDATE/DELETE.      A
FLD: QXDEGESA LEN(8) TYPE(BIN) DISP(376)
                        /*Total number of parallel groups which fellA*/
*                           back to sequential mode due to lack of    A
*                           ESA sort support.                         A
FLD: QXDEGBUF LEN(8) TYPE(BIN) DISP(384)
                        /*Total number of parallel groups that have C*/
*                           a planned degree greater than one at run  C
*                           time, but fell back to sequential mode    C
*                           because of storage shortage or contention C
*                           on the buffer pool.                       C
FLD: QXREDGRP LEN(8) TYPE(BIN) DISP(392)
                        /*Total number of parallel groups that have C*/
*                           a planned degree greater than one at run  C
*                           time, but were processed to a parallel    C
*                           degree less than planned because of a     C
*                           storage shortage or contention on the     C
*                           buffer pool.                              C
FLD: QXNORGRP LEN(8) TYPE(BIN) DISP(400)
                        /*Total number of parallel groups that have C*/
*                           a planned degree greater than one at run  C
*                           time, and were executed to the same degreeC
*                           because of sufficient storage on the      C
*                           buffer pool.                              C
FLD: QXCON1   LEN(8) TYPE(BIN) DISP(408)
                          /*# of CONNECT type 1 statements executed B*/
FLD: QXCON2   LEN(8) TYPE(BIN) DISP(416)
                          /*# of CONNECT type 2 statements executed B*/
FLD: QXREL    LEN(8) TYPE(BIN) DISP(424)
                                 /*# of RELEASE statements executed B*/
FLD: QXSETCON LEN(8) TYPE(BIN) DISP(432)
                          /*# of SET CONNECTION statements executed B*/
FLD: QXSETCDG LEN(8) TYPE(BIN) DISP(440)
                               /*# of SET CURRENT DEGREE statements A*/
*                           executed
FLD: QXSETCRL LEN(8) TYPE(BIN) DISP(448)
                                /*# of SET CURRENT RULES statements D*/
FLD: QXCALL   LEN(8) TYPE(BIN) DISP(456)
                                /*# of SQL CALL statements executed F*/
FLD: QXCALLAB LEN(8) TYPE(BIN) DISP(464)
                            /*# of times a stored procedure ABENDed F*/
FLD: QXCALLTO LEN(8) TYPE(BIN) DISP(472)
                           /*# of times an SQL CALL statement timed F*/
*                             out waiting to be scheduled             F
FLD: QXCALLRJ LEN(8) TYPE(BIN) DISP(480)
                             /*# of times an SQL CALL statement was F*/
*                             rejected                                F
FLD: QXRLFDPA LEN(1) DISP(488)
                              /*If non zero, then Query Parallelism J*/
*                           is disabled by the RLF for at least one   I
*                           dynamic SELECT statement in this thread.  I
*                           See IFCID 0022 from a PREPARE statement   I
*                           for detailed information at the statement I
*                           level.  This field is for accounting      I
*                           IFCID 0003 and does not apply to IFCID    I
*                           0002.                                     I
FLD: QXCOORNO LEN(8) TYPE(BIN) DISP(496)
                         /*Total number of parallel groups executed K*/
*                           on a single DB2 due to the COORDINATOR    K
*                           subsystem parameter being set to NO.      K
*                           When the statement was bound, the         K
*                           COORDINATOR subsystem parameter was       K
*                           set to YES.  This situation can also      K
*                           occur when a plan or package is bound on  K
*                           one DB2 where COORDINATOR=YES but is run  K
*                           on a DB2 where COORDINATOR=NO.            K
FLD: QXISORR  LEN(8) TYPE(BIN) DISP(504)
                         /*Total number of parallel groups executed K*/
*                           on a single DB2 due to repeatable-read    K
*                           or read-stability isolation.              K
FLD: QXCRGTT  LEN(8) TYPE(BIN) DISP(512)
                               /*# OF CREATE GLOBAL TEMPORARY TABLE M*/
FLD: QXSTREOP LEN(8) TYPE(BIN) DISP(520)
                             /*Total number of times reoptimization N*/
*                           occurs.  This field does not apply to     N
*                           IFCID 0002.                               N
FLD: QXXCBPNX LEN(8) TYPE(BIN) DISP(528)
                        /*Total number of parallel groups that were O*/
*                           intended to run across the data sharing   O
*                           group.  This count is only incremented on O
*                           the parallelism coordinator at run time.  O
FLD: QXXCSKIP LEN(8) TYPE(BIN) DISP(536)
                         /*The number of times that the parallelism O*/
*                           coordinator had to bypass a DB2 when      O
*                           distributing tasks because there was not  O
*                           enough buffer pool storage on one or more O
*                           DB2 members.  This field is incremented   O
*                           only on the parallelism coordinator, and  O
*                           it is only incremented once per parallel  O
*                           group, even though it is possible that    O
*                           more than one DB2 had a buffer pool       O
*                           shortage for that parallel group.         O
*                           The purpose of this count is to indicate  O
*                           when there are not enough buffers on a    O
*                           member.  Therefore, this count is         O
*                           incremented only when the buffer pool is  O
*                           defined to allow parallelism.  For        O
*                           example, if VPXPSEQT = 0 on an assistant, O
*                           DB2 does not send parallel work there, butO
*                           this count is not incremented.            O
FLD: QXALOCL  LEN(8) TYPE(BIN) DISP(544)
                           /*Number of ASSOCIATE LOCATOR statements P*/
*                           executed                                  P
FLD: QXALOCC  LEN(8) TYPE(BIN) DISP(552)
                             /*Number of ALLOCATE CURSOR statements P*/
*                           statements executed                       P
FLD: QXSTFND  LEN(8) TYPE(BIN) DISP(560)
                            /*The number of times a PREPARE request P*/
*                           was satisfied by making a copy from the   P
*                           prepared statement cache                  P
FLD: QXSTNFND LEN(8) TYPE(BIN) DISP(568)
                            /*The number of times a PREPARE request P*/
*                           was received but a matching statement was P
*                           not found in the prepared statement       P
*                           cache.  Cache search is only done for     P
*                           DML SQL and only if cache option is activeP
FLD: QXSTIPRP LEN(8) TYPE(BIN) DISP(576)
                             /*The number of times that an implicit P*/
*                           prepare was performed because the         P
*                           KEEPDYNAMIC(YES) option was used and an   P
*                           OPEN, EXECUTE or DESCRIBE of a dynamic    P
*                           statement occurred after a COMMIT but     P
*                           DB2 no longer had a valid copy of the     P
*                           executable version of the prepared        P
*                           statement                                 P
FLD: QXSTNPRP LEN(8) TYPE(BIN) DISP(584)
                           /*The number of times that a prepare was P*/
*                           avoided because KEEPDYNAMIC(YES) was      P
*                           used along with prepared statement        P
*                           caching and DB2 still had the application P
*                           process' copy of the executable version   P
*                           of the prepared statement                 P
FLD: QXSTDEXP LEN(8) TYPE(BIN) DISP(592)
                          /*The number of times that an application P*/
*                           process' executable copy of a prepared    P
*                           statement was discarded due to the        P
*                           MAXKEEPD system limit being exceeded      P
FLD: QXSTDINV LEN(8) TYPE(BIN) DISP(600)
                              /*The number of times that a prepared P*/
*                           statement was purged from the cache       P
*                           because a DROP, ALTER, or REVOKE          P
*                           statement was issued on a dependent       P
*                           object.                                   P
FLD: QXRNTAB  LEN(8) TYPE(BIN) DISP(608)        /*# OF RENAME TABLE Q*/
FLD: QXCTRIG  LEN(8) TYPE(BIN) DISP(616)      /*# OF CREATE TRIGGER R*/
FLD: QXDRPTR  LEN(8) TYPE(BIN) DISP(624)        /*# OF DROP TRIGGER R*/
FLD: QXSETPTH LEN(8) TYPE(BIN) DISP(632)
                                 /*# OF SET CURRENT PATH statements S*/
FLD: QXDRPFN  LEN(8) TYPE(BIN) DISP(640)
                                  /*# OF DROP USER DEFINED FUNCTION T*/
FLD: QXDRPPR  LEN(8) TYPE(BIN) DISP(648)      /*# OF DROP PROCEDURE T*/
FLD: QXCDIST  LEN(8) TYPE(BIN) DISP(656)
                             /*# OF CREATE DISTINCT TYPE statements U*/
FLD: QXDDIST  LEN(8) TYPE(BIN) DISP(664)
                               /*# OF DROP DISTINCT TYPE statements U*/
FLD: QXCRUDF  LEN(8) TYPE(BIN) DISP(672)
                                  /*# OF CREATE FUNCTION statements V*/
FLD: QXCRPRO  LEN(8) TYPE(BIN) DISP(680)
                                 /*# OF CREATE PROCEDURE statements c*/
FLD: QXHOLDL  LEN(8) TYPE(BIN) DISP(688)
                                  /*# OF HOLD LOCATOR statements W*/
FLD: QXFREEL  LEN(8) TYPE(BIN) DISP(696)
                                  /*# OF FREE LOCATOR statements W*/
FLD: QXREPOP1 LEN(8) TYPE(BIN) DISP(704)
                        /*Total number of parallel groups for which X*/
*                           DB2 reformulated the parallel portion of  X
*                           the access path because the sysplex       X
*                           configuration was different from the      X
*                           sysplex configuration at bind time.       X
*                           This counter is only incremented by the   X
*                           parallelism coordinator at run time.      X
FLD: QXREPOP2 LEN(8) TYPE(BIN) DISP(712)
                        /*Total number of parallel groups for which X*/
*                           DB2 reformulated the paralllel portion of X
*                           the access path because there was not     X
*                           enough buffer pool resource.              X
*                           This counter is only incremented by the   X
*                           parallelism coordinator at run time.      X
FLD: QXCRATB  LEN(8) TYPE(BIN) DISP(720)
                                 /*# OF CREATE AUX TABLE statements c*/
FLD: QXSTLOBV LEN(8) DISP(728)    /*Max storage used for LOB values Y*/
*                           In KB for accounting, in MB for statisticsY
FLD: QXALUDF  LEN(8) TYPE(BIN) DISP(736)
                                  /*# OF ALTER FUNCTION statements Z*/
FLD: QXALPRO  LEN(8) TYPE(BIN) DISP(744)
                                  /*# OF ALTER PROCEDURE statements Z*/
FLD: QXROIMAT LEN(8) TYPE(BIN) DISP(752)
                            /*# of times that direct row access was a*/
*                           successful
FLD: QXROIIDX LEN(8) TYPE(BIN) DISP(760)
                          /*# of times an attempt to use direct row a*/
*                           access reverted to using an index to      a
*                           locate a record
FLD: QXROITS  LEN(8) TYPE(BIN) DISP(768)
                          /*# of times an attempt to use direct row a*/
*                           access reverted to using a table space    a
*                           scan to locate a record
FLD: QXSTTRG  LEN(8) TYPE(BIN) DISP(776)
                               /*# of times a statement trigger was b*/
*                           activated                                 b
FLD: QXROWTRG LEN(8) TYPE(BIN) DISP(784)
                           /*# of times a row trigger was activated b*/
FLD: QXTRGERR LEN(8) TYPE(BIN) DISP(792)
                          /*# of times an SQL error occurred during b*/
*                           execution of a triggered action           b
FLD: QXCASCDP LEN(8) DISP(800)    /*The maximum level of nested SQL b*/
*                           cascading.  This includes cascading       b
*                           due to triggers, UDFs and stored          b
*                           procedures.                               b
FLD: QXCAUD   LEN(8) TYPE(BIN) DISP(808)
                             /*# of user defined functions executed d*/
FLD: QXCAUDAB LEN(8) TYPE(BIN) DISP(816) /*# of times a UDF ABENDed d*/
FLD: QXCAUDTO LEN(8) TYPE(BIN) DISP(824)
                            /*# of times a UDF timed out waiting to d*/
*                             be scheduled                            d
FLD: QXCAUDRJ LEN(8) TYPE(BIN) DISP(832)
                                  /*# of times a UDF was rejected d*/
FLD: QXSETCPR LEN(8) DISP(840) /*# SET CURRENT PRECISION statements e*/
*                             executed                                e
FLD: QXDCLGTT LEN(8) TYPE(BIN) DISP(848)
                        /*# of DECLARE GLOBAL TEMPORARY TABLE stmts f*/
FLD: QXDEGDTT LEN(8) TYPE(BIN) DISP(856)
                         /*Total number of parallel groups that are f*/
*                           part of a query block using a UDF and     f
*                           executed on a single DB2 due to           f
*                           the existence of a Declared Temporary     f
*                           Table in the application process. Neither f
*                           the query block nor the parallel group    f
*                           references a Declared Temporary Table, andf
*                           a parallel group may or may not use a UDF.f
FLD: QXCRESEQ LEN(8) TYPE(BIN) DISP(864)      /*# OF CREATE SEQUENCES*/
FLD: QXALTSEQ LEN(8) TYPE(BIN) DISP(872)       /*# OF ALTER SEQUENCES*/
FLD: QXDROSEQ LEN(8) TYPE(BIN) DISP(880)        /*# OF DROP SEQUENCES*/
FLD: QXPRRESI LEN(8) TYPE(BIN) DISP(888)
                                /*# of PREPAREs for which use of an i*/
*                           index/indexes were restricted because the i
*                           index was in a pending state.             i
FLD: QXALTVW  LEN(8) TYPE(BIN) DISP(896)          /*# of ALTER VIEW j*/
FLD: QXALTJR  LEN(8) TYPE(BIN) DISP(904)           /*# OF ALTER JAR k*/
FLD: QXMERGE  LEN(8) TYPE(BIN) DISP(912)
                          /*# OF times MERGE statement was executed m*/
FLD: QXTRTBL  LEN(8) TYPE(BIN) DISP(920)
                           /*# of times TRUNCATE TABLE was executed n*/
FLD: QXCRROL  LEN(8) TYPE(BIN) DISP(928)         /*# OF CREATE ROLE o*/
FLD: QXDRPROL LEN(8) TYPE(BIN) DISP(936)           /*# OF DROP ROLE o*/
FLD: QXCRCTX  LEN(8) TYPE(BIN) DISP(944)
                                  /*# OF CREATE TRUSTED CONTEXT o*/
FLD: QXALTCTX LEN(8) TYPE(BIN) DISP(952)
                                  /*# OF ALTER TRUSTED CONTEXT o*/
FLD: QXDRPCTX LEN(8) TYPE(BIN) DISP(960)
                                  /*# OF DROP TRUSTED CONTEXT o*/
FLD: QXRNIX   LEN(8) TYPE(BIN) DISP(968)        /*# OF RENAME INDEX u*/
FLD: QXSTXMLV LEN(8) DISP(976)  /*# Max storage used for XML values q*/
FLD: QXRWSFETCHD LEN(8) TYPE(BIN) DISP(984)
                                  /*# Number of Rows Fetched r*/
FLD: QXRWSINSRTD LEN(8) TYPE(BIN) DISP(992)
                                  /*# Number of Rows Inserted r*/
FLD: QXRWSUPDTD LEN(8) TYPE(BIN) DISP(1000)
                                  /*# Number of Rows Updated r*/
FLD: QXRWSDELETD LEN(8) TYPE(BIN) DISP(1008)
                                  /*# Number of Rows Deleted r*/
FLD: QXSTCWLP LEN(8) TYPE(BIN) DISP(1016)
                         /*# of times DB2 parsed dynamic statements t*/
*                           because CONCENTRATE STATEMENTS WITH       t
*                           LITERALS behavior was in effect for       t
*                           the prepare of the statement for          t
*                           the dynamic statement cache               t
FLD: QXSTCWLR LEN(8) TYPE(BIN) DISP(1024)
                             /*# of times DB2 replaced at least one t*/
*                           literal in a dynamic statement because    t
*                           CONCENTRATE STATEMENTS WITH LITERALS      t
*                           was in effect for the prepare of          t
*                           the statement for dynamic statement cache t
FLD: QXSTCWLM LEN(8) TYPE(BIN) DISP(1032)
                         /*# of times DB2 found a matching reusable t*/
*                           copy of a dynamic statement in statement  t
*                           cache during prepare of a statement that  t
*                           had literals replaced because of          t
*                           CONCENTRATE STATEMENTS WITH LITERALS      t
FLD: QXSTCWLD LEN(8) TYPE(BIN) DISP(1040)
                          /*# of times DB2 created a duplicate stmt t*/
*                           instance in the the statement cache for   t
*                           a dynamic statement that had literals     t
*                           replaced by CONCENTRATE STATEMENTS WITH   t
*                           LITERALS behavior and the duplicate stmt  t
*                           instance was needed because a cache       t
*                           match failed solely due to literal        t
*                           reusability criteria                      t
FLD: QXPFSLNUM LEN(8) DISP(1048)  /*(S) v*/
FLD: QXPFSENUM LEN(8) DISP(1056)  /*(S) v*/
FLD: QXPFSENUMG LEN(8) DISP(1064) /*(S) v*/
FLD: QXPFMAXU LEN(8) DISP(1072)   /*(S) v*/
FLD: QXPFMAXUG LEN(8) DISP(1080)  /*(S) v*/
FLD: QXWFRIDS LEN(8) TYPE(BIN) DISP(1088)
                         /*# of times a RID list was overflown to a w*/
*                           work file because no RIDPOOL storage was  w
*                           available to hold the list of RIDs.       w
FLD: QXWFRIDT LEN(8) TYPE(BIN) DISP(1096)
                         /*# of times a RID list was overflown to a w*/
*                           work file because the number of RIDs      w
*                           exceeded one or more internal limits.     w
FLD: QXHJINCS LEN(8) TYPE(BIN) DISP(1104)
                        /*# of times a RID list append for a Hybrid w*/
*                           Join was interrupted because no RIDPOOL   w
*                           storage was available to hold the list of w
*                           RIDs (i.e. number of times DB2            w
*                           interrupted the RID phase and switched to w
*                           the Data phase).                          w
FLD: QXHJINCT LEN(8) TYPE(BIN) DISP(1112)
                        /*# of times a RID list append for a Hybrid w*/
*                           Join was interrupted because the number   w
*                           of RIDs exceeded one or more internal     w
*                           limits (i.e. number of times DB2          w
*                           interrupted the RID phase and switched to w
*                           the Data phase).                          w
FLD: QXRSMIAP LEN(8) TYPE(BIN) DISP(1120)
                              /*# of times a RID list retrieval for w*/
*                           multiple index access was skipped because w
*                           it was not necessary due to DB2 being     w
*                           able to predetermine the outcome of index w
*                           ANDing or ORing.                          w
FLD: QXCREMP  LEN(8) TYPE(BIN) DISP(1128)
                                  /*# OF CREATE MASK OR PERMISSION x*/
FLD: QXDRPMP  LEN(8) TYPE(BIN) DISP(1136)
                                  /*# OF DROP MASK OR PERMISSION x*/
FLD: QXALTMP  LEN(8) TYPE(BIN) DISP(1144)
                                  /*# OF ALTER MASK OR PERMISSION x*/
FLD: QXSTEND  LEN(8) DISP(1152)   /*END OF RDS ACCOUNTING AREA*/


*******************************************************************
*   QTST    DSNDQTST   *   SERVICE CONTROLLER STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQTST DSECT                TABLE OF SCC COUNTERS                
***********************************************************************

COMP: QTST_OFFSET =
           WHEN(SM100RTY=100 AND QWS10R2N > 0) ASSIGN(QWS10R2O)
           ELSE                                ASSIGN(99999)
FLD: DSNDQTST DISP(0) LEN(1) OFFSET(QTST_OFFSET)
                                  /*TABLE OF SCC COUNTERS*/
FLD: QTST     LEN(8) DISP(0)
FLD: QTHEAD   LEN(4) TYPE(BIN) DISP(0)         /*CONTROL BLOCK HEADER*/
FLD: QTID     TYPE(HALF) DISP(0)  /*CONTROL BLOCK ID*/
FLD: QTLEN    TYPE(HALF) DISP(2)  /*CONTROL BLOCK LENGTH*/
FLD: QTEYE    LEN(4) DISP(4)      /*CONTROL BLOCK EYE CATCHER*/
FLD: QTSTATS  LEN(4) TYPE(BIN) DISP(8)                   /*STATISTICS*/
FLD: QTALLOCA LEN(4) TYPE(BIN) DISP(8)          /*ALLOCATION ATTEMPTS*/
FLD: QTALLOC  LEN(4) TYPE(BIN) DISP(12)      /*SUCCESSFUL ALLOCATIONS*/
FLD: QTABINDA LEN(4) TYPE(BIN) DISP(16)     /*AUTOMATIC BIND ATTEMPTS*/
FLD: QTABIND  LEN(4) TYPE(BIN) DISP(20)  /*SUCCESSFUL AUTOMATIC BINDS*/
FLD: QTINVRID LEN(4) TYPE(BIN) DISP(24)        /*INVALID RESOURCE IDS*/
FLD: QTBINDA  LEN(4) TYPE(BIN) DISP(28)     /*BIND (ADD) SUB COMMANDS*/
FLD: QTBINDR  LEN(4) TYPE(BIN) DISP(32) /*BIND (REPLACE) SUB COMMANDS*/
FLD: QTTESTB  LEN(4) TYPE(BIN) DISP(36)     /*TEST BINDS (NO PLAN ID)*/
FLD: QTPLNBD  LEN(4) TYPE(BIN) DISP(40)                 /*PLANS BOUND*/
FLD: QTREBIND LEN(4) TYPE(BIN) DISP(44)         /*REBIND SUB COMMANDS*/
FLD: QTRBINDA LEN(4) TYPE(BIN) DISP(48)   /*ATTEMPTS TO REBIND A PLAN*/
FLD: QTPLNRBD LEN(4) TYPE(BIN) DISP(52)               /*PLANS REBOUND*/
FLD: QTFREE   LEN(4) TYPE(BIN) DISP(56)           /*FREE SUB COMMANDS*/
FLD: QTFREEA  LEN(4) TYPE(BIN) DISP(60)     /*ATTEMPTS TO FREE A PLAN*/
FLD: QTPLNFRD LEN(4) TYPE(BIN) DISP(64)                 /*PLANS FREED*/
FLD: QTAUCHK  LEN(4) TYPE(BIN) DISP(68)
                               /*TOTAL NUMBER OF AUTHORIZATION CHECKS*/
FLD: QTAUSUC  LEN(4) TYPE(BIN) DISP(72)
                                  /*TOTAL NUMBER OF SUCCESSFUL AUTH*/
*                                   CHECKS
FLD: QTDSOPN  LEN(4) TYPE(BIN) DISP(76)
                                  /*NUMBER OF DATASETS CURRENTLY OPEN*/
FLD: QTMAXDS  LEN(4) TYPE(BIN) DISP(80)
                                 /*MAXIMUM NUMBER OF DS OPENED CONCUR*/
FLD: QTAUCCH  LEN(4) TYPE(BIN) DISP(84)
                                  /*#SUCCESSFUL AUTH CHECKS FOR PLANS*/
*                                   USING A PLAN CACHE OR PUBLIC AUTH
*                                   CHECK (QTAUPUB)
FLD: QTAUPUB  LEN(4) TYPE(BIN) DISP(88)
                                  /*#SUCCESSFUL AUTH CHECKS FOR PLAN*/
*                                   EXECUTE AUTHORITY HELD BY PUBLIC
FLD: QTMAXPB  LEN(4) TYPE(BIN) DISP(92)
                                  /*MAXIMUM NOT IN USE DATA SETS*/
FLD: QTPACAUT LEN(4) TYPE(BIN) DISP(96)
                               /*#SUCCESSFUL AUTH CHECKS FOR PACKAGES*/
*                                   USING THE PACKAGE AUTH CACHE--
*                                   INCLUDES PUBLIC AUTH CHECKS
*                                   (QTPACPUB)
FLD: QTPACPUB LEN(4) TYPE(BIN) DISP(100)
                                /*#SUCCESSFUL AUTH CHECKS FOR PACKAGE*/
*                                   EXECUTE AUTHORITY HELD BY PUBLIC
FLD: QTPACNOT LEN(4) TYPE(BIN) DISP(104)
                                /*#PACKAGE AUTH CHECKS THAT COULD NOT*/
*                                   MAKE USE OF THE PACKAGE AUTH CACHE
FLD: QTREOPN  LEN(4) TYPE(BIN) DISP(108)
                                  /*# OF TIMES THAT NOT IN USE OPEN*/
*                                  DATA SETS BECAME IN-USE
FLD: QTPACOW1 LEN(4) TYPE(BIN) DISP(112)
                                 /*# OF TIMES DB2 OVERWROTE AN AUTHID*/
*                                  IN THE PACKAGE AUTH CACHE
FLD: QTPACOW2 LEN(4) TYPE(BIN) DISP(116)
                                 /*# OF TIMES DB2 OVERWROTE A PACKAGE*/
*                                  ENTRY IN THE PACKAGE AUTH CACHE
FLD: QTDSDRN  LEN(4) TYPE(BIN) DISP(124)
                                  /*# OF NOT IN USE DATA SETS CLOSED*/
*                                  DUE TO DSMAX/DD LIMIT
FLD: QTPCCT   LEN(4) TYPE(BIN) DISP(128)
                                  /*# OF INFREQUENTLY UPDATED DATA*/
*                                  SETS THAT ARE CONVERTED FROM
*                                  R/W TO R/O STATE
FLD: QTSLWDD  LEN(4) TYPE(BIN) DISP(132)
                                  /*# OF DATA SETS THAT ARE NOT*/
*                                  IN-USE, BUT ARE NOT CLOSED
FLD: QTBINDPA LEN(4) TYPE(BIN) DISP(136)
                                  /*BIND (ADD) PACKAGE SUB COMMANDS*/
FLD: QTBINDPR LEN(4) TYPE(BIN) DISP(140)
                                  /*BIND (REP) PACKAGE SUB COMMANDS*/
FLD: QTPKGBD  LEN(4) TYPE(BIN) DISP(144)           /*# PACKAGES BOUND*/
FLD: QTRBINDP LEN(4) TYPE(BIN) DISP(148)
                                  /*REBIND PACKAGE SUB COMMANDS*/
FLD: QTRBNDPA LEN(4) TYPE(BIN) DISP(152)
                                  /*ATTEMPTS TO REBIND A PACKAGE*/
FLD: QTPKGRBD LEN(4) TYPE(BIN) DISP(156)         /*# PACKAGES REBOUND*/
FLD: QTFREEP  LEN(4) TYPE(BIN) DISP(160)  /*FREE PACKAGE SUB COMMANDS*/
FLD: QTFREEAP LEN(4) TYPE(BIN) DISP(164) /*ATTEMPTS TO FREE A PACKAGE*/
FLD: QTPKGFRD LEN(4) TYPE(BIN) DISP(168)           /*# PACKAGES FREED*/
FLD: QTAUTOBA LEN(4) TYPE(BIN) DISP(172)
                                  /*ATTEMPTS TO AUTOBIND A PACKAGE*/
FLD: QTPKABND LEN(4) TYPE(BIN) DISP(176)       /*# PACKAGES AUTOBOUND*/
FLD: QTPKALLA LEN(4) TYPE(BIN) DISP(180)
                                  /*ATTEMPTS TO ALLOCATE A PACKAGE*/
FLD: QTPKALL  LEN(4) TYPE(BIN) DISP(184)       /*# PACKAGES ALLOCATED*/
FLD: QTRACAUT LEN(4) TYPE(BIN) DISP(200)
                               /*#SUCCESSFUL AUTH CHECKS FOR ROUTINES*/
*                                   USING THE ROUTINE AUTH CACHE--
*                                   INCLUDES PUBLIC AUTH CHECKS
*                                   (QTRACPUB)
FLD: QTRACPUB LEN(4) TYPE(BIN) DISP(204)
                                /*#SUCCESSFUL AUTH CHECKS FOR ROUTINE*/
*                                   EXECUTE AUTHORITY HELD BY PUBLIC
FLD: QTRACNOT LEN(4) TYPE(BIN) DISP(208)
                                /*#ROUTINE AUTH CHECKS THAT COULD NOT*/
*                                   MAKE USE OF THE ROUTINE AUTH CACHE
FLD: QTRACOW1 LEN(4) TYPE(BIN) DISP(212)
                                 /*# OF TIMES DB2 OVERWROTE AN AUTHID*/
*                                  IN THE ROUTINE AUTH CACHE
FLD: QTRACOW2 LEN(4) TYPE(BIN) DISP(216)
                                 /*# OF TIMES DB2 OVERWROTE A ROUTINE*/
*                                  ENTRY IN THE ROUTINE AUTH CACHE
FLD: QTRACNAC LEN(4) TYPE(BIN) DISP(220)
                                 /*# OF TIMES DB2 WAS NOT ABLE TO ADD*/
*                                  AN ENTRY TO THE ROUTINE AUTH CACHE
FLD: QTSTEND  LEN(4) TYPE(BIN) DISP(256)


*******************************************************************
*   QBST    DSNDQBST   *   BUFFER MANAGER STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQBST DSECT                                                     
***********************************************************************

COMP: QBST_OFFSET =
           WHEN(SM100RTY=100 AND QWS10R3N > 0) ASSIGN(QWS10R3O)
           ELSE                                ASSIGN(99999)
FLD: DSNDQBST DISP(0) LEN(1) OFFSET(QBST_OFFSET)
FLD: QBST     LEN(8) DISP(0)
FLD: QBSTPID  LEN(4) TYPE(BIN) DISP(0)               /*BUFFER POOL ID*/
FLD: QBSTFLG  LEN(1) DISP(4)      /*FLAGS*/
COMP: QBSTCON = X'80'             /*1 MORE QBST DATA WILL FOLLOW*/
FLD: QBSTGET  LEN(8) TYPE(BIN) DISP(8)
                              /*# OF GET PAGE REQUESTS. INCLUDES BOTH*/
*                             CONDITIONAL AND NON-CONDITIONAL,
*                             SUCCESSFUL AND UNSUCCESSFUL REQUESTS
FLD: QBSTRIO  LEN(8) TYPE(BIN) DISP(16)
                           /*# OF SYNC. READ I/O OPERATIONS PERFORMED*/
FLD: QBSTDWV  LEN(8) TYPE(BIN) DISP(24)
                                 /*# OF TIMES VERTICAL DEFERRED WRITE*/
*                             THRESHOLD REACHED
FLD: QBSTXFL  LEN(8) TYPE(BIN) DISP(32)
                            /*# OF GETPAGE FAILURES DUE TO VPOOL FULL*/
FLD: QBSTXFV  LEN(8) TYPE(BIN) DISP(40)
                          /*# OF EXPANSION FAILURE DUE TO SHORTAGE OF*/
*                             VIRTUAL STORAGE
FLD: QBSTSWS  LEN(8) TYPE(BIN) DISP(48)
                                  /*# OF SETW ISSUED FOR SYSTEM PAGES*/
FLD: QBSTPWS  LEN(8) TYPE(BIN) DISP(56)
                                  /*# OF PAGE WRITES FOR SYSTEM PAGES*/
FLD: QBSTWIO  LEN(8) TYPE(BIN) DISP(64)
                         /*# OF ASYNC. WRITE I/O OPERATIONS PERFORMED*/
FLD: QBSTCBA  LEN(8) TYPE(BIN) DISP(72) /*# OF CURRENT ACTIVE BUFFERS*/
FLD: QBSTRPI  LEN(8) TYPE(BIN) DISP(80)
                                 /*# OF PAGE IN REQUIRED FOR READ I/O*/
FLD: QBSTWPI  LEN(8) TYPE(BIN) DISP(88)
                                /*# OF PAGE IN REQUIRED FOR WRITE I/O*/
FLD: QBSTDSO  LEN(8) TYPE(BIN) DISP(96)
                                 /*# OF DATA SETS OPENED SUCCESSFULLY*/
FLD: QBSTIMW  LEN(8) TYPE(BIN) DISP(104)
                                /*# OF IMMED (SYNCHRONOUS) WRITE I/OS*/
FLD: QBSTSEQ  LEN(8) TYPE(BIN) DISP(112)
                                  /*# OF SEQ PREFETCH REQUESTED*/
FLD: QBSTSPP  LEN(8) TYPE(BIN) DISP(120)
                                 /*# OF PAGE READ DUE TO SEQ PREFETCH*/
FLD: QBSTSPD  LEN(8) TYPE(BIN) DISP(128)
                                  /*# OF SEQ PREFETCH DISABLED DUE TO*/
*                             UNAVAILABLE BUFFER RESOURCES
FLD: QBSTREE  LEN(8) TYPE(BIN) DISP(136)
                                  /*# OF SEQ PREFETCH DISABLED DUE TO*/
*                             UNAVAILABLE READ ENGINE
FLD: QBSTDWT  LEN(8) TYPE(BIN) DISP(144)
                           /*# OF TIMES THAT DEFERRED WRITE THRESHOLD*/
*                             IS REACHED
FLD: QBSTDMC  LEN(8) TYPE(BIN) DISP(152)
                            /*# OF TIMES THAT THE DATA MANAGER BUFFER*/
*                             CRITICAL THRESHOLD HAS BEEN REACHED
FLD: QBSTMIG  LEN(8) TYPE(BIN) DISP(160)
                                 /*# OF TIMES THAT MIGRATED DATA SETS*/
*                             ENCOUNTERED
FLD: QBSTRTO  LEN(8) TYPE(BIN) DISP(168)       /*# OF RECALL TIMEOUTS*/
FLD: QBSTPIO  LEN(8) TYPE(BIN) DISP(176)
                         /*# OF SEQ PREFETCH (ASYNCHRONOUS) READ I/OS*/
FLD: QBSTWKPD LEN(8) TYPE(BIN) DISP(184)
                             /*# OF WK PREFETCH ABORTED DUE TO A ZERO*/
*                             PREFETCH QUANTITY
FLD: QBSTMAX  LEN(8) TYPE(BIN) DISP(192)
                              /*# OF WK FILE CANNOT BE CREATED DUE TO*/
*                             INSUFFICIENT BUFFER RESOURCES
FLD: QBSTWFM  LEN(8) DISP(200)
                              /*MAXIMUM WORKFILES EVER BEEN ALLOCATED*/
*                             DURING THE SORT/MERGE PROCESSING
FLD: QBSTWDRP LEN(8) TYPE(BIN) DISP(208)
                          /*# OF PAGES FOR WHICH DESTRUCTIVE READ WAS*/
*                             REQUESTED
FLD: QBSTWBVQ LEN(8) TYPE(BIN) DISP(216)
                         /*# OF PAGES DEQUEUED FROM DATA SET DEFERRED*/
*                             WRITE QUEUE FOR DESTRUCTIVE READ REQUEST
FLD: QBSTWFR  LEN(8) DISP(224)
                            /*COUNT OF REQUESTS TO QUERY FOR WORFILES*/
*                             IN THE PROCESS OF SORT/MERGE
FLD: QBSTWFT  LEN(8) DISP(232)
                          /*SUM OF WORKFILES THAT HAVE BEEN REQUESTED*/
*                             DURING THE SORT/MERGE PROCESSING
FLD: QBSTWFD  LEN(8) DISP(240)
                             /*SUM OF WORKFILES THAT HAVE BEEN DENIED*/
*                             DURING THE SORT/MERGE PROCESSING
FLD: QBSTWFF  LEN(8) TYPE(BIN) DISP(248)
                                 /*# OF TIMES SORT/MERGE COULD NOT BE*/
*                             EFFICIENTLY PERFORMED DUE TO THE BUFFER
*                             SHORTAGE
FLD: QBSTLPF  LEN(8) TYPE(BIN) DISP(256)
                                  /*# OF LIST PREFETCH REQUESTED*/
*                             CONCURRENT PREFETCH AGAINST SAME PAGESET
FLD: QBSTDPF  LEN(8) TYPE(BIN) DISP(264)
                                  /*# OF DYNAMIC PREFETCH REQUESTED*/
FLD: QBSTVPA  LEN(8) TYPE(BIN) DISP(272)
                               /*# OF SUCCESSFUL VPOOL EXP/CONTRATION*/
FLD: QBSTPCO  LEN(8) TYPE(BIN) DISP(280)
                                  /*# OF PG on 'unlock castout'*/
FLD: QBSTCIO  LEN(8) TYPE(BIN) DISP(288)        /*# OF I/O on castout*/
FLD: QBSTVPL  LEN(8) TYPE(BIN) DISP(296)
                            /*# OF BUFFERS ALLOCATED FOR VIRTUAL POOL*/
FLD: QBSTDPP  LEN(8) TYPE(BIN) DISP(304)
                             /*# OF PAGE READ DUE TO DYNAMIC PREFETCH*/
FLD: QBSTLPP  LEN(8) TYPE(BIN) DISP(312)
                                /*# OF PAGE READ DUE TO LIST PREFETCH*/
FLD: QBSTDIO  LEN(8) TYPE(BIN) DISP(320)
                               /*# OF DYNAMIC PREFETCH (ASYNCHRONOUS)*/
*                             READ I/OS
FLD: QBSTLIO  LEN(8) TYPE(BIN) DISP(328)
                         /*# OF LIST PREFETCH (ASYNCHRONOUS) READ I/O*/
FLD: QBSTSGT  LEN(8) TYPE(BIN) DISP(336)
                         /*# OF GET PAGE ISSUED BY SEQUENTIAL REQUEST*/
FLD: QBSTSIO  LEN(8) TYPE(BIN) DISP(344)
                           /*# OF SYNC. READ I/O OPERATIONS PERFORMED*/
*                             BY SEQUENTIAL REQUESTS
FLD: QBSTNGT  LEN(8) TYPE(BIN) DISP(352)
                             /*# OF UNSUCCESSFUL GETPAGE DUE TO CONDI*/
*                             TIONAL GETPAGE REQUEST
FLD: QBSTXIS  LEN(8) DISP(360)
                        /*HIGHEST PREFETCH I/O STREAMS HAVE EVER BEEN*/
*                             ALLOCATED
FLD: QBSTJIS  LEN(8) TYPE(BIN) DISP(368)
                         /*# OF PREFETCH I/O STREAMS HAVE BEEN DENIED*/
*                             DUE TO THE SHORTAGE OF BUFFERPOOL
*                             FOR EXAMPLE, IF 100 PREFETCH I/O STREAMS
*                             ARE REQUESTED AND ONLY 80 ARE GRANTED,
*                             THEN 20 WILL BE ADDED TO THIS COUNTER.
FLD: QBSTPQO  LEN(8) TYPE(BIN) DISP(376)
                         /*TOTAL # OF NEGOTIATIONS BETWEEN BM AND RDS*/
*                             RUNTIME TO SUPPORT PARALLELISM
FLD: QBSTPQF  LEN(8) TYPE(BIN) DISP(384)
                               /*# OF TIMES PARALLELISM HAS BEEN DOWN*/
*                             GRADED DUE TO THE SHORTAGE OF BUFFERPOOL
FLD: QBSTPL1  LEN(8) TYPE(BIN) DISP(392)
                           /*TOTAL # OF OCCURRENCES WHEN PREFETCH QTY*/
*                             DECREASED FROM NORMAL TO HALF OF NORMAL.
*                             NORMAL IS BASED ON THE BUFFER POOL SIZE
FLD: QBSTPL2  LEN(8) TYPE(BIN) DISP(400)
                           /*TOTAL # OF OCCURRENCES WHEN PREFETCH QTY*/
*                             DECREASED FROM HALF OF NORMAL TO
*                             ONE QUARTER OF NORMAL.  NORMAL IS
*                             BASED ON THE BUFFER POOL SIZE.
FLD: QBSTNSG  LEN(8) TYPE(BIN) DISP(408)
                                /*# OF CONDITIONAL SEQUENTIAL GETPAGE*/
*                             REQUESTS WHICH FAILED BECAUSE THE
*                             PAGE WAS NOT IN THE BUFFER POOL.
FLD: QBSTLPL  LEN(8) TYPE(BIN) DISP(448)
                                  /*# of times one or more pages were*/
*                             added to LPL
FLD: QBSTEND  LEN(4) TYPE(BIN) DISP(456)


*******************************************************************
*   QIST    DSNDQIST   *   DATA MANAGER STATISTICS - V2R2
*******************************************************************
***********************************************************************
**** DSNDQIST DSECT                TABLE OF SCC COUNTERS                
***********************************************************************

COMP: QIST_OFFSET =
           WHEN(SM100RTY=100 AND QWS10R4N > 0) ASSIGN(QWS10R4O)
           ELSE                                ASSIGN(99999)
FLD: DSNDQIST DISP(0) LEN(1) OFFSET(QIST_OFFSET)
                                  /*TABLE OF SCC COUNTERS*/
FLD: QIST     LEN(8) DISP(0)
FLD: QIID     LEN(2) DISP(0)      /*CONTROL BLOCK ID*/
FLD: QILEN    TYPE(HALF) DISP(2)  /*CONTROL BLOCK LENGTH*/
FLD: QIEYE    LEN(4) DISP(4)      /*CONTROL BLOCK EYE CATCHER*/
FLD: QISTATS  LEN(4) TYPE(BIN) DISP(8)                   /*STATISTICS*/
FLD: QISTRLLM LEN(4) TYPE(BIN) DISP(8)      /*THE NUMBER OF TIMES RID*/
*                                  /* LIST PROCESSING TERMINATED */ 
*                                  /* BECAUSE THE NUMBER OF RID  */ 
*                                  /* ENTRIES WAS GREATER THAN   */ 
*                                  /* THE RDS LIMIT.  THE RDS    */ 
*                                  /* LIMIT IS THE MAX(25% OF    */ 
*                                  /* TABLE SIZE, NUMBER OF RIDS */ 
*                                  /* THAT CAN FIT INTO THE      */ 
*                                  /* GUARANTEED NUMBER OF RID   */ 
*                                  /* BLOCKS.                    */ 
FLD: QISTRPLM LEN(4) TYPE(BIN) DISP(12)     /*THE NUMBER OF TIMES RID*/
*                                  /* LIST PROCESSING TERMINATED */ 
*                                  /* BECAUSE THE NUMBER OF RID  */ 
*                                  /* ENTRIES WAS GREATER THAN   */ 
*                                  /* THE DM LIMIT.  THE DM      */ 
*                                  /* LIMIT IS APPROXIMATELY     */ 
*                                  /* 26 MILLION RIDS.           */ 
FLD: QISTRHAC LEN(8) DISP(16)     /*DOUBLE WORD CONTAINING*/
*                                  /* BOTH QISTRHIG AND QISTRCUR */ 
*                                  /* NOTE:QISTRHIG AND QISTRCUR */ 
*                                  /* MUST REMAIN IN CONTIGUOUS  */ 
*                                  /* MEMORY AND ON A DOUBLE     */ 
*                                  /* WORD BOUNDARY              */ 
FLD: QISTRHIG LEN(4) TYPE(BIN) DISP(16)       /*HIGHEST NUMBER OF RID*/
*                                  /* BLOCKS IN USE AT ANY ONE   */
*                                  /* TIME SINCE DB2 STARTUP TIME*/
FLD: QISTRCUR LEN(4) TYPE(BIN) DISP(20)        /*NUMBER OF RID BLOCKS*/
*                                  /* CURRENTLY IN USE.          */
FLD: QISTRSTG LEN(4) TYPE(BIN) DISP(24)    /*NUMBER OF TIMES RID LIST*/
*                                  /* PROCESSING EXHAUSTED       */
*                                  /* VIRTUAL STORAGE            */
FLD: QISTRMAX LEN(4) TYPE(BIN) DISP(28) /*NUMBER OF TIMES THE MAXIMUM*/
*                                  /* RID POOL STORAGE WAS       */
*                                  /* EXCEEDED.  THE DEFAULT     */
*                                  /* MAXIMUM RID POOL SIZE IS   */
*                                  /* THE MIN(install value,     */
*                                  /* 10GB).                     */
*/*--------------------------------------------------------------*/
*/*  Total number of columns (rows x columns)                    */
*/*   for which a Select Procedure was bypassed                  */
*/*   because the Select Procedure was invalidated               */
*/*   by applying service to DB2.                                */
*/*   Everything will continue to function                       */
*/*   correctly, but with some degradation in                    */
*/*   performance.                                               */
*/*   To obtain optimum performance, whenever this               */
*/*   counter is not zero, rebind any affected                   */
*/*   plans or packages.                                         */
*/*--------------------------------------------------------------*/
FLD: QISTCOLS LEN(4) TYPE(BIN) DISP(32)     /*Total number of columns*/
FLD: QISTWFNE LEN(4) TYPE(BIN) DISP(52) /*Number of times the maximum*/
*                                  /* allowable storage usage    */    
*                                  /* limit was exceeded         */    
FLD: QISTWFP1 LEN(4) TYPE(BIN) DISP(72)  /*How many times a 32KB page*/
*                                  /* TS was used when a 4KB     */    
*                                  /* page TS was preferable     */    
*                                  /* (but was not available)    */    
FLD: QISTWFP2 LEN(4) TYPE(BIN) DISP(76)   /*How many times a 4KB page*/
*                                  /* TS was used when a 32KB    */    
*                                  /* page TS was preferable     */    
*                                  /* (but was not available)    */    
FLD: QISTRCCI LEN(4) TYPE(BIN) DISP(80)        /*RCCI: Read Currently*/
*                                  /*       Committed Insert     */    
*                                  /* How many rows skipped by   */    
*                                  /* read transaction due to    */    
*                                  /* uncommitted insert when    */    
*                                  /* using Currently Committed  */    
*                                  /* semantic for fetch.        */    
FLD: QISTRCCD LEN(4) TYPE(BIN) DISP(84)        /*RCCD: Read Currently*/
*                                  /*       Committed Delete     */    
*                                  /* How many rows accessed by  */    
*                                  /* read transaction due to    */    
*                                  /* uncommitted delete when    */    
*                                  /* using Currently Committed  */    
*                                  /* semantic for fetch.        */    
FLD: QISTRCCU LEN(4) TYPE(BIN) DISP(88)        /*RCCU: Read Currently*/
*                                  /*       Committed Update     */    
*                                  /* How many rows accessed by  */    
*                                  /* read transaction due to    */    
*                                  /* uncommitted update when    */    
*                                  /* using Currently Committed  */    
*                                  /* semantic for fetch.        */    
FLD: QISTWMXA LEN(8) DISP(96)     /*Maximum allowable storage @219*/
*                                  /* usage limit per agent (KB) @219*/
*                                  /* (MAXTEMPS zparm value)     @219*/
*                                  /* Equivalent in V9 was       @219*/
*                                  /* QISTWFMX                   @219*/
FLD: QISTWMXU LEN(8) DISP(104)    /*Maximum total storage ever @219*/
*                                  /* used in workfile db (KB)   @219*/
*                                  /* (starts as 0 on restart)   @219*/
*                                  /* Equivalent in V9 was       @219*/
*                                  /* QISTWFMU                   @219*/
FLD: QISTWCTO LEN(8) DISP(112)    /*Current total storage used @219*/
*                                  /* in workfile DB (KB)        @219*/
*                                  /* Equivalent in V9 was       @219*/
*                                  /* QISTWFCU/QISTWFCK pair     @219*/
FLD: QISTW4K  LEN(8) DISP(120)    /*Current 4KB table space @219*/
*                                  /* storage used (KB)          @219*/
*                                  /* Equivalent in V9 was       @219*/
*                                  /* QISTWF04/QISTW04K pair     @219*/
FLD: QISTW32K LEN(8) DISP(128)    /*Current 32KB table space @219*/
*                                  /* storage used (KB)          @219*/
*                                  /* Equivalent in V9 was       @219*/
*                                  /* QISTWF32/QISTW32K pair     @219*/
FLD: QISTIMAC LEN(8) DISP(136)    /*How many DM In Memory work @wf1*/
*                                  /* files are Active Currently.@wf1*/
FLD: QISTIMSC LEN(8) DISP(144)    /*Total Space used for the @wf1*/
*                                  /* Currently-Active DM In-Mem @wf1*/
*                                  /* workfiles, in KBs.         @wf1*/
FLD: QISTIMAH LEN(8) DISP(152)    /*High watermark count of @wf1*/
*                                  /* maximum number DM In-Memory@wf1*/
*                                  /* workfiles Active           @wf1*/
*                                  /* at any point in time       @wf1*/
*                                  /* since DB2 came up.         @wf1*/
FLD: QISTIMSH LEN(8) DISP(160)    /*High watermark count of @wf1*/
*                                  /* maximum Space used for the @wf1*/
*                                  /* active DM In-Mem workfiles @wf1*/
*                                  /* at any point in time       @wf1*/
*                                  /* since DB2 came up, in KBs. @wf1*/
FLD: QISTSIAC LEN(8) DISP(168)    /*How many Sort Inmem work @wf1*/
*                                  /* files are Active Currently.@wf1*/
FLD: QISTSISC LEN(8) DISP(176)    /*Total Space used for the @wf1*/
*                                  /* Currently-active Sort-Inmem@wf1*/
*                                  /* workfiles, in bytes.       @wf1*/
FLD: QISTSIAH LEN(8) DISP(184)    /*High watermark count of @wf1*/
*                                  /* maximum number Sort-Inmem  @wf1*/
*                                  /* workfiles Active           @wf1*/
*                                  /* at any point in time       @wf1*/
*                                  /* since DB2 came up.         @wf1*/
FLD: QISTSISH LEN(8) DISP(192)    /*High watermark count of @wf1*/
*                                  /* maximum Space used for the @wf1*/
*                                  /* active Sort-Inmem workfiles@wf1*/
*                                  /* at any point in time       @wf1*/
*                                  /* since DB2 came up, in bytes@wf1*/
FLD: QISTWFRHIG LEN(8) TYPE(BIN) DISP(200)
                                  /*Highest # of RID blocks @353*/
*                                  /* overflown(stored) to a work@353*/
*                                  /* file at any time since DB2 @353*/
*                                  /* startup. This is a high-   @353*/
*                                  /* water mark.                @353*/
FLD: QISTWFRCUR LEN(8) TYPE(BIN) DISP(208)
                                  /*# of RID blocks currently @353*/
*                                  /* residing in work file      @353*/
*                                  /* storage. This is a         @353*/
*                                  /* snapshot value.            @353*/
FLD: QISTEND  LEN(4) TYPE(BIN) DISP(280)


*******************************************************************
*   QTXA    DSNDQTXA   *   LOCKING STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQTXA DSECT                                                     
***********************************************************************

COMP: QTXA_OFFSET =
           WHEN(SM100RTY=100 AND QWS10R5N > 0) ASSIGN(QWS10R5O)
           ELSE                                ASSIGN(99999)
FLD: DSNDQTXA DISP(0) LEN(1) OFFSET(QTXA_OFFSET)
FLD: QTXA     LEN(8) DISP(0)
FLD: QTXADEA  LEN(4) TYPE(BIN) DISP(0)               /*Deadlock count*/
FLD: QTXASLOC LEN(4) TYPE(BIN) DISP(4)
                                  /*Number of suspends because of*/
*                                        lock conflicts
FLD: QTXATIM  LEN(4) TYPE(BIN) DISP(8)               /*Timeout counts*/
FLD: QTXALES  LEN(4) TYPE(BIN) DISP(12)  /*Count of lock escal shared*/
FLD: QTXALEX  LEN(4) TYPE(BIN) DISP(16)
                                  /*Count of lock escal exclusive*/
FLD: QTXANPL  LEN(4) TYPE(BIN) DISP(20)   /*Max number of page or row*/
*                                        locks held.
*                                        Not applicable for Statistics
*                                        IFCID 2.
FLD: QTXAFLG1 LEN(1) DISP(24)     /*First Flag Byte*/
COMP: QTXAILMT = X'80'            /*Infinite Limit*/
COMP: QTXANRUN = X'40'            /*No Run or Zero Limit*/
FLD: QTXARLID LEN(2) DISP(26)     /*Resource Limit Table ID*/
FLD: QTXAPREC LEN(4) TYPE(BIN) DISP(28)    /*How Limit was determined*/
COMP: QTXAPRC1 = 1                /*Limit from specific Authid*/
COMP: QTXAPRC2 = 2                /*Limit from specific Authid*/
COMP: QTXAPRC3 = 3                /*Limit from specific Planname*/
COMP: QTXAPRC4 = 4                /*Limit from blank Authid & Plan*/
COMP: QTXAPRC5 = 5                /*Limit from Install no entry*/
COMP: QTXAPRC6 = 6                /*Limit from Install I/O error*/
COMP: QTXAPRC7 = 7                /*Infinite limit user has*/
COMP: QTXAPRC8 = 8                /*Limit from specific Authid,*/
COMP: QTXAPRC9 = 9                /*Limit from specific Authid*/
COMP: QTXAPR10 = 10               /*Limit from specific Authid*/
COMP: QTXAPR11 = 11               /*Limit from Authid running*/
COMP: QTXAPR12 = 12               /*Limit from specific package*/
COMP: QTXAPR13 = 13               /*Limit from any Authid and*/
COMP: QTXAPR14 = 14               /*Limit from any Authid and*/
COMP: QTXAPR15 = 15               /*Limit from any Authid, pkg,*/
FLD: QTXASLMT LEN(4) TYPE(BIN) DISP(32)       /*Limit in SU's ASUTIME*/
FLD: QTXACLMT LEN(4) TYPE(BIN) DISP(36)
                                  /*Limit in CPU 16 microseconds*/
FLD: QTXACHUS LEN(4) TYPE(BIN) DISP(40)
                                  /*Highest CPU 16 microsecs used*/
FLD: QTXASLAT LEN(4) TYPE(BIN) DISP(44)
                                  /*Suspend count latch conflict*/
FLD: QTXASOTH LEN(4) TYPE(BIN) DISP(48)
                                  /*Suspend count other conflict*/
FLD: QTXALOCK LEN(4) TYPE(BIN) DISP(52)          /*Lock request count*/
FLD: QTXAUNLK LEN(4) TYPE(BIN) DISP(56)        /*Unlock request count*/
FLD: QTXAQRY  LEN(4) TYPE(BIN) DISP(60)         /*Query request count*/
FLD: QTXACHG  LEN(4) TYPE(BIN) DISP(64)        /*Change request count*/
FLD: QTXAIRLM LEN(4) TYPE(BIN) DISP(68)    /*Other IRLM request count*/
FLD: QTXACLNO LEN(4) TYPE(BIN) DISP(72)    /*Number of claim requests*/
FLD: QTXACLUN LEN(4) TYPE(BIN) DISP(76)
                                  /*Number of claim requests that*/
*                                          were unsuccessful
FLD: QTXADRNO LEN(4) TYPE(BIN) DISP(80)    /*Number of drain requests*/
FLD: QTXADRUN LEN(4) TYPE(BIN) DISP(84)
                                  /*Number of drain requests that*/
*                                          were unsuccessful
FLD: QTXAEND  LEN(1) DISP(88)


*******************************************************************
*   QISE    DSNDQISE   *   EDM POOL STATISTICS - RELEASE 2
*******************************************************************
***********************************************************************
**** QISE     DSECT      /*EDM POOL STATISTICS         */               
***********************************************************************

COMP: QISE_OFFSET =
           WHEN(SM100RTY=100 AND QWS10R6N > 0) ASSIGN(QWS10R6O)
           ELSE                                ASSIGN(99999)
FLD: QISE     DISP(0) LEN(1) OFFSET(QISE_OFFSET)
                                  /*EDM POOL STATISTICS*/
FLD: QISEFAIL LEN(4) TYPE(BIN) DISP(0)   /*# OF FAIL DUE TO POOL FULL*/
FLD: QISEPAGE LEN(4) TYPE(BIN) DISP(4)       /*NOT USED, DO NOT REUSE*/
*                           /*PAGE IS 1K 370 AND 4K ON XA */
FLD: QISECTG  LEN(4) TYPE(BIN) DISP(8)     /*# OF REQ FOR CT SECTIONS*/
FLD: QISECTL  LEN(4) TYPE(BIN) DISP(12) /*# OF LOAD CT SECT FROM DASD*/
FLD: QISECT   LEN(4) TYPE(BIN) DISP(16)      /*NOT USED, DO NOT REUSE*/
FLD: QISEFREE LEN(4) TYPE(BIN) DISP(20)      /*NOT USED, DO NOT REUSE*/
FLD: QISESTMT LEN(4) TYPE(BIN) DISP(24)      /*# OF STMTS IN EDM POOL*/
FLD: QISEDBDG LEN(4) TYPE(BIN) DISP(32)       /*# OF REQUESTS FOR DBD*/
FLD: QISEDBDL LEN(4) TYPE(BIN) DISP(36)  /*# OF LOADING DBD FROM DASD*/
FLD: QISEKTG  LEN(4) TYPE(BIN) DISP(40)    /*# OF REQ FOR PT SECTIONS*/
FLD: QISEKTL  LEN(4) TYPE(BIN) DISP(44) /*# OF LOAD PT SECT FROM DASD*/
FLD: QISEKT   LEN(4) TYPE(BIN) DISP(48)      /*NOT USED, DO NOT REUSE*/
FLD: QISEDSI  LEN(4) TYPE(BIN) DISP(56)  /*# OF INSERTS FOR DYN CACHE*/
FLD: QISEDSG  LEN(4) TYPE(BIN) DISP(60) /*# OF REQUESTS FOR DYN CACHE*/
FLD: QISEDBD  LEN(4) TYPE(BIN) DISP(64)     /*# OF PAGES USED FOR DBD*/
FLD: QISEDFAL LEN(4) TYPE(BIN) DISP(68)
                                  /*# OF FAIL DUE TO DBD POOL FULL*/
FLD: QISEDPGE LEN(4) TYPE(BIN) DISP(72) /*NUMBER OF PAGES IN DBD POOL*/
FLD: QISEDFRE LEN(4) TYPE(BIN) DISP(76)
                                  /*# OF FREE PG IN DBD FREE CHAIN*/
FLD: QISEDYNP LEN(4) TYPE(BIN) DISP(80)  /*# OF PGS USED IN STMT POOL*/
FLD: QISECFAL LEN(4) TYPE(BIN) DISP(84)
                                  /*# OF FAIL DUE TO STMT POOL FULL*/
FLD: QISECPGE LEN(4) TYPE(BIN) DISP(88)       /*# OF PGS IN STMT POOL*/
FLD: QISECFRE LEN(4) TYPE(BIN) DISP(92)
                                  /*# OF FREE PG IN STMT FREE CHAIN*/
FLD: QISESKCT LEN(4) TYPE(BIN) DISP(96)    /*# OF PAGES USED FOR SKCT*/
FLD: QISESKPT LEN(4) TYPE(BIN) DISP(100)   /*# OF PAGES USED FOR SKPT*/
FLD: QISEKFAL LEN(4) TYPE(BIN) DISP(104)
                               /*# OF FAIL DUE TO STMT SKEL POOL FULL*/
FLD: QISEKPGE LEN(4) TYPE(BIN) DISP(108)
                                  /*# OF PAGES IN SKEL EDM POOL*/
FLD: QISEKFRE LEN(4) TYPE(BIN) DISP(112)
                               /*# OF FREE PG IN SKEL EDM POOL FRE CH*/
FLD: QISECTA  LEN(4) TYPE(BIN) DISP(116)
                                  /*# OF PAGES USED IN CT ABOVE BAR*/
FLD: QISEKTA  LEN(4) TYPE(BIN) DISP(120)
                                  /*# OF PAGES USED IN PT ABOVE BAR*/
FLD: QISESFAL LEN(4) TYPE(BIN) DISP(124)
                                /*# OF FAIL DUE TO STMT ABV POOL FULL*/
FLD: QISESPGE LEN(4) TYPE(BIN) DISP(128)
                                  /*# OF PAGES IN STMT ABV EDM POOL*/
FLD: QISESFRE LEN(4) TYPE(BIN) DISP(132)
                               /*# OF FREE PG IN STMT ABV EDM POL FRE*/
FLD: QISEKNFM LEN(4) TYPE(BIN) DISP(136)
                               /*# OF CACHED NOT FOUND RECORD LOCATED*/
FLD: QISEKNFA LEN(4) TYPE(BIN) DISP(140)
                               /*# OF NOT FOUND RECORD ADDED TO CACHE*/
FLD: QISEKNFR LEN(4) TYPE(BIN) DISP(144)
                               /*# OF NT FOUND RCRD REMOVED FRM CACHE*/
FLD: QISEKSPG LEN(4) TYPE(BIN) DISP(148)        /*# of XPROC requests*/
FLD: QISEKSPA LEN(4) TYPE(BIN) DISP(152)
                                  /*Total storage allocated to xPROC*/
FLD: QISEKLRU LEN(4) TYPE(BIN) DISP(156) /*Total stealable SKEL pages*/
FLD: QISEDLRU LEN(4) TYPE(BIN) DISP(160)  /*Total stealable DBD pages*/
FLD: QISESQCB LEN(4) TYPE(BIN) DISP(168)
                                  /*Storage allocated to PLAN BTB*/
FLD: QISESQKB LEN(4) TYPE(BIN) DISP(172)
                                  /*Storage allocated to PACKAGE BTB*/
FLD: QISESQCA LEN(8) DISP(176)    /*Storage allocated to PLAN ATB*/
FLD: QISESQKA LEN(8) DISP(184)    /*Storage allocated to PACKAGE ATB*/
FLD: QISEEND  LEN(4) TYPE(BIN) DISP(192)                /*END OF LIST*/


*******************************************************************
*   QBGL    DSNDQBGL   *   Buffer Manager Data Sharing Stats - V4R1
*******************************************************************
***********************************************************************
**** QBGL     DSECT                                                     
***********************************************************************

COMP: QBGL_OFFSET =
           WHEN(SM100RTY=100 AND QWS10R7N > 0) ASSIGN(QWS10R7O)
           ELSE                                ASSIGN(99999)
FLD: QBGL     DISP(0) LEN(1) OFFSET(QBGL_OFFSET)
FLD: QBGLGN   LEN(4) TYPE(BIN) DISP(0)         /*Group Buffer Pool id*/
FLD: QBGLFLG  LEN(1) DISP(4)      /*Flags*/
COMP: QBGLCON = X'80'             /*1 More QBGL data will follow*/
FLD: QBGLGG   LEN(8) DISP(8)      /*GetPages for GBP Dep pages*/
FLD: QBGLXD   LEN(8) TYPE(BIN) DISP(16)
                                  /*# of GBP reads under the user*/
*                                        task that were
*                                        necessary due to buffer cross
*                                        invalidation (XI) in which
*                                        data was returned           */
FLD: QBGLXR   LEN(8) TYPE(BIN) DISP(24)
                                  /*# of GBP reads under the user*/
*                                        task that were
*                                        necessary due to buffer XI
*                                        in which data was not
*                                        returned from GBP.          */
FLD: QBGLMD   LEN(8) TYPE(BIN) DISP(32)
                                  /*# of GBP reads under the user*/
*                                        task that were
*                                        necessary due to the reques-
*                                        ted page not being found in
*                                        the buffer pool in which
*                                        data was returned from GBP. */
FLD: QBGLMR   LEN(8) TYPE(BIN) DISP(40)
                                  /*# of GBP reads under the user*/
*                                        task that were
*                                        necessary due to the reques-
*                                        ted page not being found in
*                                        the buffer pool in which
*                                        data was not returned.      */
FLD: QBGLSW   LEN(8) TYPE(BIN) DISP(48)  /*# of changed pages written*/
*                                        under a user's execution    */
*                                        unit (via WAR or WARM)      */
FLD: QBGLWC   LEN(8) TYPE(BIN) DISP(56)    /*# of clean pages written*/
*                                        under a user's execution
*                                        unit (via WAR or WARM)      */
FLD: QBGLCT   LEN(8) TYPE(BIN) DISP(64)
                                  /*# of times castout was initiated*/
*                                        due to the castout class
*                                        threshold being detected.   */
FLD: QBGLGT   LEN(8) TYPE(BIN) DISP(72)
                                  /*# of times castout was initiated*/
*                                        due to the group buffer pool
*                                        castout threshold being
*                                        detected.                   */
FLD: QBGLWM   LEN(8) TYPE(BIN) DISP(80)     /*# of Write and Register*/
*                                        Multiple (WARM) requests.
*                                        Multiple pages written per
*                                        request.                    */
FLD: QBGLWS   LEN(8) TYPE(BIN) DISP(88)     /*# of Write and Register*/
*                                        (WAR) requests.  One page
*                                        written per request.        */
FLD: QBGLEX   LEN(8) TYPE(BIN) DISP(96)
                                  /*# of explicit cross invalidate*/
FLD: QBGLAW   LEN(8) TYPE(BIN) DISP(104) /*# of changed pages written*/
*                                        under a system execution
*                                        unit (via WAR or WARM).     */
FLD: QBGLRC   LEN(8) TYPE(BIN) DISP(112)
                                  /*# of pages castout from the*/
*                                        Group Buffer Pool to DASD.
*                                        For each page that is castout,
*                                        QBSTPWS is also incremented.
*                                        For each disk I/O that is
*                                        initiated for castout,
*                                        QBSTWIO is incremented.     */
FLD: QBGLCM   LEN(8) DISP(120)    /*# Read For Castout Multiple*/
*                                        RFCOM) requests.  Multiple
*                                        pages read per request.     */
FLD: QBGLCR   LEN(8) TYPE(BIN) DISP(128)
                                  /*# of Read For Castout (RFCO)*/
*                                        requests.  One page read
*                                        per request.                */
FLD: QBGLWP   LEN(8) TYPE(BIN) DISP(136)
                                  /*# of pages written via WARM*/
FLD: QBGLWF   LEN(8) TYPE(BIN) DISP(144)
                                  /*# of GBP write requests that*/
*                                        could not complete due to a
*                                        lack of GBP storage resour-
*                                        ces.                        */
FLD: QBGLOS   LEN(8) TYPE(BIN) DISP(152)
                                  /*# of IXLCACHE "read stgstats"*/
*                                        requests.                   */
FLD: QBGLAC   LEN(8) TYPE(BIN) DISP(160) /*# of changed pages written*/
*                                        under a system execution
*                                        unit (via WAR or WARM).     */
FLD: QBGLAX   LEN(8) TYPE(BIN) DISP(168)
                                  /*# of "register page list" (RPL)*/
*                                        requests done by Prefetch.
*                                        Prefetch will use this option
*                                        if running on MVS 5.2 or
*                                        above, and the GBP is
*                                        allocated in a coupling
*                                        facility of CFLEVEL=2 or
*                                        above.                      */
FLD: QBGLAY   LEN(8) TYPE(BIN) DISP(176)
                                  /*# of pages retrieved from the*/
*                                        group buffer pool
*                                        as a result of feedback from
*                                        RPL.                        */
FLD: QBGLCK   LEN(8) TYPE(BIN) DISP(184)
                                  /*# of GBP checkpoints triggered*/
*                                        by this member.             */
FLD: QBGLUN   LEN(8) DISP(192)    /*# IXLCACHE "unlock castout"*/
*                                        requests.                   */
FLD: QBGLCC   LEN(8) DISP(200)    /*# IXLCACHE "read castout class"*/
*                                        requests                    */
FLD: QBGLCS   LEN(8) DISP(208)    /*# IXLCACHE "read castout stats"*/
*                                        requests                    */
FLD: QBGLDN   LEN(8) DISP(216)    /*# IXLCACHE "delete name"*/
*                                        requests                    */
FLD: QBGLRD   LEN(8) DISP(224)    /*# IXLCACHE "read dirinfo"*/
*                                        requests                    */
FLD: QBGLRG   LEN(8) TYPE(BIN) DISP(232)
                                  /*# of "register page" requests*/
FLD: QBGLDG   LEN(8) TYPE(BIN) DISP(240)     /*# of "unregister page"*/
*                                        requests                    */
FLD: QBGL2F   LEN(8) DISP(248)    /*# writes of changed pages to*/
*                                        the secondary GBP that
*                                        failed due to a lack of
*                                        storage.                    */
FLD: QBGL2S   LEN(8) DISP(256)    /*# completion checks for writes*/
*                                        to the secondary GBP that
*                                        were suspended because the
*                                        write had not yet completed.*/
FLD: QBGL2D   LEN(8) DISP(264)    /*# IXLCACHE "delete name list"*/
*                                        requests to the secondary
*                                        GBP.                        */
FLD: QBGL2R   LEN(8) DISP(272)    /*# IXLCACHE "read castout stats"*/
*                                        requests to the secondary
*                                        GBP.                        */
FLD: QBGL2N   LEN(8) DISP(280)    /*# IXLCACHE "delete name"*/
*                                        requests to the secondary
*                                        GBP.                        */
FLD: QBGLHS   LEN(8) DISP(288)    /*# Asynch IXLCACHE invocations*/
*                                        for primary GBP.            */
FLD: QBGL2H   LEN(8) DISP(296)    /*# Asynch IXLCACHE invocations*/
*                                        for secondary GBP.          */
FLD: QBGLP1   LEN(8) DISP(304)    /*# page P lock lock requests for*/
*                                        space map pages             */
FLD: QBGLP2   LEN(8) DISP(312)    /*# page P lock lock requests for*/
*                                        data pages                  */
FLD: QBGLP3   LEN(8) DISP(320)    /*# page P lock lock requests for*/
*                                        index leaf pages            */
FLD: QBGLU1   LEN(8) DISP(328)    /*# page P lock unlock requests*/
FLD: QBGLS1   LEN(8) DISP(336)    /*# page P lock lock suspensions*/
*                                        for space map pages         */
FLD: QBGLS2   LEN(8) DISP(344)    /*# page P lock lock suspensions*/
*                                        for data pages              */
FLD: QBGLS3   LEN(8) DISP(352)    /*# page P lock lock suspensions*/
*                                        for index leaf pages        */
FLD: QBGLN1   LEN(8) DISP(360)    /*# page P lock lock negotiations*/
*                                        for space map pages         */
FLD: QBGLN2   LEN(8) DISP(368)    /*# page P lock lock negotiations*/
*                                        for data pages              */
FLD: QBGLN3   LEN(8) DISP(376)    /*# page P lock lock negotiations*/
*                                        for index leaf pages        */
FLD: QBGLEND  LEN(1) DISP(416)


*******************************************************************
*   QTGS    DSNDQTGS   *   Service Controller Data Sharing Stats - V4R1
*******************************************************************
***********************************************************************
**** QTGS     DSECT                                                     
***********************************************************************

COMP: QTGS_OFFSET =
           WHEN(SM100RTY=100 AND QWS10R8N > 0) ASSIGN(QWS10R8O)
           ELSE                                ASSIGN(99999)
FLD: QTGS     DISP(0) LEN(1) OFFSET(QTGS_OFFSET)
*/********************************************************************/
*/* In the descriptions below, the term "L-lock" refers to a         */
*/* "logical lock", or a lock that is acquired and owned by a        */
*/* DB2 thread.  The term "P-lock" refers to a                       */
*/* "physical lock", or a lock that is acquired and owned the        */
*/* DB2 subsystem (i.e. P-locks are not owned by threads).           */
*/********************************************************************/
FLD: QTGSLPLK LEN(4) TYPE(BIN) DISP(0) /*# Lock requests for P locks.*/
*                                         This is a subset of QTXALOCK
*                                         which contains the total #
*                                         of Lock requests (L-locks
*                                         and P-locks).              */
FLD: QTGSCPLK LEN(4) TYPE(BIN) DISP(4)
                                  /*# Change requests for P locks.*/
*                                         This is a subset of QTXACHG
*                                         which contains the total #
*                                         of Change requests (L-locks
*                                         and P-locks).              */
FLD: QTGSUPLK LEN(4) TYPE(BIN) DISP(8)
                                  /*# Unlock requests for P locks.*/
*                                         This is a subset of QTXAUNLK
*                                         which contains the total #
*                                         of Unlock requests (L-locks
*                                         and P-locks).              */
FLD: QTGSLSLM LEN(4) TYPE(BIN) DISP(12)  /*# lock requests propagated*/
*                                         to XES (L-lock or P-lock)
*                                         synchronously, i.e. under
*                                         caller's execution unit. If
*                                         the request suspends due to
*                                         IRLM latch before going to
*                                         XES, this counter will not
*                                         be incremented             */
FLD: QTGSCSLM LEN(4) TYPE(BIN) DISP(16)
                                  /*# change requests propagated*/
*                                         to XES (L-lock or P-lock)
*                                         synchroneously, i.e. under
*                                         caller's execution unit. If
*                                         the request suspends due to
*                                         IRLM latch before going to
*                                         XES, this counter will not
*                                         be incremented             */
FLD: QTGSUSLM LEN(4) TYPE(BIN) DISP(20)
                                  /*# unlock requests propagated*/
*                                         to XES (L-lock or P-lock)
*                                         synchroneously, i.e. under
*                                         caller's execution unit. If
*                                         the request suspends due to
*                                         IRLM latch before going to
*                                         XES, this counter will not
*                                         be incremented.
*                                         This counter may actually
*                                         be larger than QTXAUNLK
*                                         (# unlocks) due to "generic"
*                                         unlocks.  On a "generic"
*                                         unlock, QTXAUNLK is incre-
*                                         mented only once, while
*                                         QTGSUSLM may be incremented
*                                         multiple times - once for
*                                         each global lock that is
*                                         released by the "generic"
*                                         unlock.
*
*    /****************************************************************/
*    /* The following 3 fields give the counts for the number of     */
*    /* suspends due to global contention for lock requests.  A      */
*    /* "global contention" occurs when inter-system communication   */
*    /* is required to resolve the lock conflict.  This is in        */
*    /* contrast to a "local contention" in which no inter-system    */
*    /* communication is required to resolve the lock conflict - the */
*    /* conflict can be resolved entirely within the local IRLM for  */
*    /* local contention.                                            */
*    /*                                                              */
*    /* The sum of QTGSIGLO, QTGSSGLO and QTGSFLSE gives the total   */
*    /* number of suspends due to global contention.                 */
*    /*                                                              */
*    /* QTXASLOC gives the number of suspends due to local resource  */
*    /* contention.                                                  */
*    /****************************************************************/
FLD: QTGSIGLO LEN(4) TYPE(BIN) DISP(24)
                                  /*# suspends due to IRLM global*/
*                                         resource contention. IRLM
*                                         lock states were in
*                                         conflict                   */
FLD: QTGSSGLO LEN(4) TYPE(BIN) DISP(28)
                                  /*# suspends due to XES global*/
*                                         resource contention but no
*                                         IRLM global resource con-
*                                         tention. XES lock states were
*                                         in conflict but the IRLM lock
*                                         states were not.           */
FLD: QTGSFLSE LEN(4) TYPE(BIN) DISP(32)
                                  /*# of sync to async heuristic*/
*                                        conversions for LOCK requests
*                                        in XES.  This conversion is
*                                        done when XES determines that
*                                        it is more efficient to drive
*                                        the request asynchronously to
*                                        the CF.                     */
FLD: QTGSDRTA LEN(4) TYPE(BIN) DISP(36)     /*# global lock or change*/
*                                         requests denied or suspended
*                                         because of an incompatible
*                                         retained lock              */
FLD: QTGSNTFY LEN(4) TYPE(BIN) DISP(40)      /*# notify messages sent*/
FLD: QTGSNTFR LEN(4) TYPE(BIN) DISP(44)  /*# notify messages received*/
*
FLD: QTGSKIDS LEN(4) TYPE(BIN) DISP(48)     /*# resources (L locks or*/
*                                         P-locks) propagated by IRLM
*                                         to XES asynchroneously to the
*                                         original request.  This
*                                         occurs when new inter-DB2
*                                         interest occurs on a parent
*                                         resource or when a request
*                                         completes after the request-
*                                         or's execution unit has been
*                                         suspended.                 */
FLD: QTGSPPPE LEN(4) TYPE(BIN) DISP(52) /*# times this DB2 was driven*/
*                                         to negotiate a pageset/
*                                         partition P-lock due to
*                                         changing inter-DB2 interest
*                                         levels on the pageset/part */
FLD: QTGSPGPE LEN(4) TYPE(BIN) DISP(56) /*# times this DB2 was driven*/
*                                         to negotiate a page P-lock
*                                         due to inter-DB2 P-lock
*                                         contention                 */
FLD: QTGSOTPE LEN(4) TYPE(BIN) DISP(60) /*# times this DB2 was driven*/
*                                         to negotiate another P-lock
*                                         type (other than pageset/
*                                         partition or page          */
FLD: QTGSCHNP LEN(4) TYPE(BIN) DISP(64)       /*# of CHANGEP requests*/
FLD: QTGSPEMX LEN(4) TYPE(BIN) DISP(68)
                                  /*Max # of engines available for*/
*                                         P-lock exit or Notify exit
*                                         requests                   */
FLD: QTGSPEQW LEN(4) TYPE(BIN) DISP(72)    /*# times an engine is not*/
*                                         available for a P-lock exit
*                                         or a Notify exit request   */
*
FLD: QTGSFLMG LEN(4) TYPE(BIN) DISP(76)
                                  /*# false contentions for LOCK*/
*                                         and UNLOCK requests.
*                                         A false contention
*                                         occurs when different
*                                         resource names hash to the
*                                         same entry in the CF lock
*                                         table.  The CF detects
*                                         contention within the hash
*                                         entry, and XES uses inter-
*                                         system messaging to determine
*                                         that no actual resource
*                                         contention exists.
*                                         Note #1:  when OA12164 and
*                                         PK85159 are applied, this
*                                         counter will report false
*                                         contentions for a member
*                                         against which the accounting
*                                         report is run.
*                                         Note #2:  In the absence
*                                         of OA12164  & PK85159, this
*                                         counter is maintained on
*                                         a per-LPAR basis.  Therefore
*                                         this counter will over-report
*                                         false contentions in cases
*                                         where multiple members from
*                                         the same data sharing group
*                                         run on the same z/OS image.
*                                         'FF'x is returned if data is
*                                         unavailable due to error from
*                                         returned from the XES service
*                                                                    */
FLD: QTGSCREJ LEN(4) TYPE(BIN) DISP(80)
                                  /*# failed DB2 lock requests to*/
*                                         XES to process without delay.
*                                         XES rejects the lock request
*                                         since it could not process it
*                                         synchronously              */
FLD: QTGSFLGS LEN(4) TYPE(BIN) DISP(84) /*Flags that describe various*/
*                                       counters in QTGS section     */
COMP: QTGSFCON = X'80000000'      /*1 QTGSFLMG reports counts per*/
FLD: QTGSEND  LEN(1) DISP(88)


*******************************************************************
*   QLES    DSNDQLES   *   LE STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQLES DSECT                TABLE OF LE in ADMF COUNTERS         
***********************************************************************

COMP: QLES_OFFSET =
           WHEN(SM100RTY=100 AND QWS10R9N > 0) ASSIGN(QWS10R9O)
           ELSE                                ASSIGN(99999)
FLD: DSNDQLES DISP(0) LEN(1) OFFSET(QLES_OFFSET)
                                  /*TABLE OF LE in ADMF COUNTERS*/
FLD: QLES     LEN(8) DISP(0)
FLD: QLHEAD   LEN(4) TYPE(BIN) DISP(0)         /*CONTROL BLOCK HEADER*/
FLD: QLID     TYPE(HALF) DISP(0)  /*CONTROL BLOCK ID*/
FLD: QLLEN    TYPE(HALF) DISP(2)  /*CONTROL BLOCK LENGTH*/
FLD: QLEYE    LEN(4) DISP(4)      /*CONTROL BLOCK EYE CATCHER*/
FLD: QLESTATS LEN(4) TYPE(BIN) DISP(8)                   /*STATISTICS*/
FLD: QLECREAT LEN(4) TYPE(BIN) DISP(8)                          /*(S)*/
FLD: QLETRMST LEN(4) TYPE(BIN) DISP(12)                         /*(S)*/
FLD: QLETRMER LEN(4) TYPE(BIN) DISP(16)                         /*(S)*/
FLD: QLETRMDL LEN(4) TYPE(BIN) DISP(20)                         /*(S)*/
FLD: QLENUMEC LEN(4) TYPE(BIN) DISP(24)                         /*(S)*/
FLD: QLENUMEM LEN(4) TYPE(BIN) DISP(28)                         /*(S)*/
FLD: QLENUMIC LEN(4) TYPE(BIN) DISP(32)                         /*(S)*/
FLD: QLENUMIM LEN(4) TYPE(BIN) DISP(36)                         /*(S)*/
FLD: QLESTGEC LEN(4) TYPE(BIN) DISP(40)                         /*(S)*/
FLD: QLESTGEM LEN(4) TYPE(BIN) DISP(44)                         /*(S)*/
FLD: QLESTGIC LEN(4) TYPE(BIN) DISP(48)                         /*(S)*/
FLD: QLESTGIM LEN(4) TYPE(BIN) DISP(52)                         /*(S)*/
FLD: QLELOWEC LEN(4) TYPE(BIN) DISP(56)                         /*(S)*/
FLD: QLELOWEM LEN(4) TYPE(BIN) DISP(60)                         /*(S)*/
FLD: QLELOWIC LEN(4) TYPE(BIN) DISP(64)                         /*(S)*/
FLD: QLELOWIM LEN(4) TYPE(BIN) DISP(68)                         /*(S)*/
FLD: QLESTG1M LEN(4) TYPE(BIN) DISP(72)                         /*(S)*/
FLD: QLELOW1M LEN(4) TYPE(BIN) DISP(76)                         /*(S)*/
FLD: QLEUSED  LEN(8) DISP(80)     /*(S)*/
FLD: QLETIME  LEN(8) DISP(88)     /*(S)*/
FLD: QLENTRDY LEN(8) DISP(96)     /*(S)*/
FLD: QLETIMEW LEN(8) DISP(104)    /*(S)*/
FLD: QLETIMEI LEN(8) DISP(112)    /*(S)*/
FLD: QLETIMET LEN(8) DISP(120)    /*(S)*/
FLD: QLETIMEM LEN(8) DISP(128)    /*(S)*/
FLD: QLESEND  LEN(4) TYPE(BIN) DISP(168)


*******************************************************************
*   QISJ    DSNDQISJ   *   STARJOIN POOL STATISTICS (S)
*******************************************************************
***********************************************************************
**** QISJ     DSECT                                                     
***********************************************************************

COMP: QISJ_OFFSET =
           WHEN(SM100RTY=100 AND QWS10RAN > 0) ASSIGN(QWS10RAO)
           ELSE                                ASSIGN(99999)
FLD: QISJ     DISP(0) LEN(1) OFFSET(QISJ_OFFSET)
FLD: QISJTRY  LEN(4) TYPE(BIN) DISP(0)                          /*(S)*/
FLD: QISJFAIL LEN(4) TYPE(BIN) DISP(4)                          /*(S)*/
FLD: QISJSIZE LEN(4) TYPE(BIN) DISP(8)                          /*(S)*/
FLD: QISJMAX  LEN(4) TYPE(BIN) DISP(12)                         /*(S)*/
FLD: QISJEND  LEN(4) TYPE(BIN) DISP(16)

*******************************************************************
*   Q8ST                                                          *
*******************************************************************
***********************************************************************
**** Q8ST     DSECT                                                     
***********************************************************************

COMP: Q8ST_OFFSET =
           WHEN(SM100RTY=100 AND QWS10RBN > 0) ASSIGN(QWS10RBO)
           ELSE                                ASSIGN(99999)
FLD: Q8ST     DISP(0) LEN(1) OFFSET(Q8ST_OFFSET)
FLD: Q8STNAME_OFF LEN(2) TYPE(BIN) DISP(0)
                                  /*ACCELERATOR SERVER ID OFFSET*/
FLD: Q8STPRID LEN(8) DISP(2)      /*ACCELERATOR PRODUCT ID*/
FLD: Q8STCONN LEN(8) TYPE(BIN) DISP(16)  /*# OF ACCELERATOR CONNECTS.*/
FLD: Q8STREQ  LEN(8) TYPE(BIN) DISP(24)  /*# OF ACCELERATOR REQUESTS.*/
FLD: Q8STTOUT LEN(8) TYPE(BIN) DISP(32)    /*# OF TIMED OUT REQUESTS.*/
FLD: Q8STFAIL LEN(8) TYPE(BIN) DISP(40)       /*# OF FAILED REQUESTS.*/
FLD: Q8STBYTS LEN(8) TYPE(BIN) DISP(48)            /*# OF BYTES SENT.*/
FLD: Q8STBYTR LEN(8) TYPE(BIN) DISP(56)        /*# OF BYTES RETURNED.*/
FLD: Q8STMSGS LEN(8) TYPE(BIN) DISP(64)         /*# OF MESSAGES SENT.*/
FLD: Q8STMSGR LEN(8) TYPE(BIN) DISP(72)     /*# OF MESSAGES RETURNED.*/
FLD: Q8STBLKS LEN(8) TYPE(BIN) DISP(80)           /*# OF BLOCKS SENT.*/
FLD: Q8STBLKR LEN(8) TYPE(BIN) DISP(88)       /*# OF BLOCKS RETURNED.*/
FLD: Q8STROWS LEN(8) TYPE(BIN) DISP(96)             /*# OF ROWS SENT.*/
FLD: Q8STROWR LEN(8) TYPE(BIN) DISP(104)        /*# OF ROWS RETURNED.*/
FLD: Q8STSCPU TYPE(STCKTIME) DISP(112)
                                  /*ACCELERATOR SERVICES CPU TIME.*/
FLD: Q8STSELA TYPE(STCKTIME) DISP(120)
                                 /*ACCELERATOR SERVICES ELAPSED TIME.*/
FLD: Q8STTCPU TYPE(STCKTIME) DISP(128)  /*ACCEL SVCS TCP/IP CPU TIME.*/
FLD: Q8STTELA TYPE(STCKTIME) DISP(136)
                                  /*ACCEL SVCS TCP/IP ELAPSED TIME.*/
FLD: Q8STACPU TYPE(STCKTIME) DISP(144)
                                  /*ACCUMULATED ACCELERATOR CPU TIME.*/
FLD: Q8STAELA TYPE(STCKTIME) DISP(152)
                              /*ACCUMULATED ACCELERATOR ELAPSED TIME.*/
FLD: Q8STTATE LEN(1) DISP(161)    /*Accelerator state*/
*                           0 = INITIALIZED
*                           1 = ONLINE
*                           2 = PAUSED
*                           3 = OFFLINE
*                           4 = STOPPED
*                           5 = MAINTENANCE
*                           6 = DOWN
*                           7 = UNKNOWN
FLD: Q8STACTV TYPE(HALF) DISP(162)/*Current active requests*/
FLD: Q8STMAXA TYPE(HALF) DISP(164)/*Maximum active requests*/
FLD: Q8STAVGQ03 TYPE(HALF) DISP(166)  /*Avg query queue len lst 3 hrs*/
FLD: Q8STMAXQ TYPE(HALF) DISP(168)
                                  /*Query queue length high watermark*/
FLD: Q8STCCPU TYPE(HALF) DISP(170)/*Average cpu utilization on*/
*                            accelerator coordinator node
FLD: Q8STSKEW TYPE(HALF) DISP(172)/*Data Skew*/
FLD: Q8STWCPU TYPE(HALF) DISP(174)/*Average cpu utilization on*/
*                            accelerator worker nodes
FLD: Q8STWNOD TYPE(HALF) DISP(176)/*Number of active worker nodes*/
FLD: Q8STAVGQ24 TYPE(HALF) DISP(178) /*Avg query queue len lst 24 hrs*/
FLD: Q8STQUEW LEN(8) DISP(184)    /*Average accelerator queue wait*/
*                            elapsed.
FLD: Q8STQUEM LEN(8) DISP(192)    /*Maximum accelerator queue wait*/
*                            elapsed.
FLD: Q8STMIPS LEN(8) DISP(200)    /*Accelerator processing capacity*/
FLD: Q8STCORS LEN(8) DISP(208)    /*Total amount of processors within*/
*                            the accelerator
FLD: Q8STSREQ LEN(8) TYPE(BIN) DISP(216)
                                  /*Total number of successful query*/
*                            requests since accelerator start
FLD: Q8STFREQ LEN(8) TYPE(BIN) DISP(224)
                                  /*Total number of failed query*/
*                            requests since accelerator start
FLD: Q8STFINV LEN(8) TYPE(BIN) DISP(232)
                                  /*Number of failed query requests*/
*                            due to invalid state
FLD: Q8STDSKA LEN(8) DISP(240)    /*Disk storage (MB) available*/
FLD: Q8STDSKU LEN(8) DISP(248)    /*Disk storage (MB) in use*/
FLD: Q8STDSKB TYPE(HALF) DISP(256)/*Disk storage in use for DB*/
FLD: Q8STCPMU LEN(8) DISP(258)
                              /*Physical memory (MB) average usage on*/
*                            accelerator coordinator node
FLD: Q8STNMDS TYPE(HALF) DISP(266)/*V2 Number of Data Slices*/
FLD: Q8STWPMU LEN(8) DISP(268)
                              /*Physical memory (MB) average usage on*/
*                            accelerator worker nodes
FLD: Q8STWSMA LEN(8) DISP(276) /*Shared memory (MB) data available on*/
*                            accelerator worker nodes
FLD: Q8STWSMU LEN(8) DISP(284)
                              /*Shared memory (MB) data average usage*/
*                            on accelerator worker nodes
FLD: Q8STWSMM LEN(8) DISP(292)
                             /*Maximum shared (MB) memory data in use*/
*                            on IWA worker nodes
FLD: Q8STAWAT TYPE(STCKTIME) DISP(300)
                                 /*ACCUMULATED ACCELERATOR WAIT TIME.*/
FLD: Q8STEND  LEN(4) TYPE(BIN) DISP(308)


***********************************************************************
**** Q8STNAME_D DSECT       USE IF Q8STNAME_Off<>0                      
***********************************************************************

COMP: Q8STNAME_D_OFFSET =
           WHEN(SM100RTY=100 AND QWS10RBN > 0 AND Q8STNAME_Off <> 0)
                                  ASSIGN(QWS10RBO + Q8STNAME_Off)
           ELSE                   ASSIGN(99999)
FLD: Q8STNAME_D DISP(0) LEN(1) OFFSET(Q8STNAME_D_OFFSET)
                                  /*USE IF Q8STNAME_Off<>0*/
FLD: Q8STNAME_LEN TYPE(HALF) DISP(0)  /*LENGTH OF THE FOLLOWING FIELD*/
FLD: Q8STNAME_VAR LEN(128) DISP(2)/*ACCELERATOR SERVER NAME*/

***********************************************************************
*                                                                     *
* SMF 100 RECORD  SUBTYPE 4 (?) (IFCID 225) FOLLOWS                   *
*                                                                     *
*  IFCID225 summarizes system storage usage
*  The record is divided into data sections described as follows:
* 
*  Data Section 1: Address Space Summary (QW0225)
*  This data section can be a repeating group.
*  It will report data for DBM1 and DIST
*  address spaces. Use QW0225AN to identify
*  the address space being described.
*  Data Section 2: Thread information (QW02252)
*  Data Section 3: Shared and Common Storage Summary (QW02253)
*  Data Section 4: Statement Cache and xPROC Detail (QW02254)
*  Data Section 5: Pool Details (QW02255)
***********************************************************************
***********************************************************************
**** QWS4     DSECT                                                     
***********************************************************************

COMP: QWS4_OFFSET =
           WHEN(SM100RTY=100 AND QWHSIID = 225) ASSIGN(28)
           ELSE                                 ASSIGN(99999)
FLD: QWS4     DISP(0) LEN(1) OFFSET(QWS4_OFFSET)
* DB2 SELF DEFINING SECTION MACRO FOR IFCID=0255
*
FLD: QWS40PSO LEN(4) TYPE(BIN) DISP(0)
                                  /*OFFSET TO THE PRODUCT SECTION*/
FLD: QWS40PSL LEN(2) TYPE(BIN) DISP(4)
                                  /*LENGTH OF THE PRODUCT SECTION*/
FLD: QWS40PSN LEN(2) TYPE(BIN) DISP(6)   /*NUMBER OF PRODUCT SECTIONS*/
* 
FLD: QWS40R1O LEN(4) TYPE(BIN) DISP(8)   /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R1L LEN(2) TYPE(BIN) DISP(12)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R1N LEN(2) TYPE(BIN) DISP(14)     /*NUMBER OF DATA SECTIONS*/
* 
FLD: QWS40R2O LEN(4) TYPE(BIN) DISP(16)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R2L LEN(2) TYPE(BIN) DISP(20)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R2N LEN(2) TYPE(BIN) DISP(22)     /*NUMBER OF DATA SECTIONS*/
* 
FLD: QWS40R3O LEN(4) TYPE(BIN) DISP(24)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R3L LEN(2) TYPE(BIN) DISP(28)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R3N LEN(2) TYPE(BIN) DISP(30)     /*NUMBER OF DATA SECTIONS*/
* 
FLD: QWS40R4O LEN(4) TYPE(BIN) DISP(32)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R4L LEN(2) TYPE(BIN) DISP(36)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R4N LEN(2) TYPE(BIN) DISP(38)     /*NUMBER OF DATA SECTIONS*/
* 
FLD: QWS40R5O LEN(4) TYPE(BIN) DISP(40)  /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R5L LEN(2) TYPE(BIN) DISP(44)  /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R5N LEN(2) TYPE(BIN) DISP(46)     /*NUMBER OF DATA SECTIONS*/

******************************************************************* 
*   IFCID 0225 * Data Section 1: Address Space Summary
******************************************************************* 
***********************************************************************
**** QW0225 DSECT
***********************************************************************

***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QW0225, USE:
*    INPUT: SMF100
*           NORMWHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R1N > 0)
*           NORMSMF(QWS40R1O)
***********************************************************************
COMP: QW0225_OFFSET =
           WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R1N > 0)
                                  ASSIGN(QWS40R1O)
           ELSE                   ASSIGN(99999)
FLD: QW0225   DISP(0) LEN(1) OFFSET(QW0225_OFFSET)
FLD: QW0225AN LEN(4) DISP(0)    /*! Address space name (DBM1 or DIST)*/
FLD: QW0225RG LEN(4) TYPE(BIN) DISP(4)   /*! MVS extended region size*/
FLD: QW0225LO LEN(4) TYPE(BIN) DISP(8)     /*! MVS 24 bit low private*/
FLD: QW0225HI LEN(4) TYPE(BIN) DISP(12)   /*! MVS 24 bit high private*/
FLD: QW0225EL LEN(4) TYPE(BIN) DISP(16)
                                  /*! MVS 31 bit extended low private*/
FLD: QW0225EH LEN(4) TYPE(BIN) DISP(20)
                                 /*! MVS 31 bit extended high private*/
FLD: QW0225TP LEN(4) TYPE(BIN) DISP(24)
                    /*! Current high address of 24 bit private region*/
FLD: QW0225EP LEN(4) TYPE(BIN) DISP(28)
                    /*! Current high address of 31 bit private region*/
FLD: QW0225CR LEN(4) TYPE(BIN) DISP(32)
                        /*! 31 bit storage reserved for must complete*/
FLD: QW0225MV LEN(4) TYPE(BIN) DISP(36)
                                  /*! 31 bit storage reserved for MVS*/
FLD: QW0225SO LEN(4) TYPE(BIN) DISP(40)
                              /*! Storage cushion warning to contract*/
FLD: QW0225GS LEN(4) TYPE(BIN) DISP(44)
                                  /*! Total 31 bit getmained stack*/
FLD: QW0225SU LEN(4) TYPE(BIN) DISP(48) /*! Total 31 bit stack in use*/
FLD: QW0225VR LEN(4) TYPE(BIN) DISP(52)
                               /*! Total 31 bit variable pool storage*/
FLD: QW0225FX LEN(4) TYPE(BIN) DISP(56)
                                  /*! Total 31 bit fixed pool storage*/
FLD: QW0225GM LEN(4) TYPE(BIN) DISP(60)
                                  /*! Total 31 bit getmained storage*/
FLD: QW0225AV LEN(4) TYPE(BIN) DISP(64)
                               /*! Amount of available 31 bit storage*/
FLD: QW0225VA LEN(8) TYPE(BIN) DISP(72)
                       /*! Total 64 bit private variable pool storage*/
FLD: QW0225FA LEN(8) TYPE(BIN) DISP(80)
                          /*! Total 64 bit private fixed pool storage*/
FLD: QW0225GA LEN(8) TYPE(BIN) DISP(88)
                           /*! Total 64 bit private getmained storage*/
FLD: QW0225SM LEN(8) TYPE(BIN) DISP(96)
                         /*! Total 64 bit private storage for storage*/
* ! manager control structures
FLD: QW0225RL LEN(8) TYPE(BIN) DISP(104)
                              /*! Number of real 4K frames in use for*/
* ! 31 and 64-bit private
FLD: QW0225AX LEN(8) TYPE(BIN) DISP(112)
                              /*! Number of 4K auxiliary slots in use*/
* ! for 31 and 64-bit private
FLD: QW0225HVPAGESINREAL LEN(8) TYPE(BIN) DISP(120)
                              /*! Number of real 4K frames is use for*/
* ! 64-bit private (available in
* ! >= z/OS 1.11)
FLD: QW0225HVAUXSLOTS LEN(8) TYPE(BIN) DISP(128)
                              /*! Number of 4K auxiliary slots in use*/
* ! for 64-bit private (available in
* ! >= z/OS 1.11)
FLD: QW0225HVGPAGESINREAL LEN(8) TYPE(BIN) DISP(136)
                            /*! High water mark for number of real 4K*/
* ! frames is use for 64-bit private
* ! (available in >= z/OS 1.11)
FLD: QW0225HVGAUXSLOTS LEN(8) TYPE(BIN) DISP(144)
                           /*! High water mark for 4K auxiliary slots*/
* ! in use for 64-bit private
* ! (available in >= z/OS 1.11)
*

******************************************************************* 
*   IFCID 0225 Data Section 2: Thread information
******************************************************************* 
***********************************************************************
**** QW02252 DSECT
***********************************************************************

COMP: QW02252_OFFSET =
           WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R2N > 0)
                                  ASSIGN(QWS40R2O)
           ELSE                   ASSIGN(99999)
FLD: QW02252  DISP(0) LEN(1) OFFSET(QW02252_OFFSET)
FLD: QW0225AT LEN(4) TYPE(BIN) DISP(0)        /*! # of active threads*/
FLD: QW0225DB LEN(4) TYPE(BIN) DISP(4)
                               /*! # of active and disconnected DBATs*/
FLD: QW0225CE LEN(4) TYPE(BIN) DISP(8)       /*! # of castout engines*/
FLD: QW0225DW LEN(4) TYPE(BIN) DISP(12)
                                  /*! # of deferred write engines*/
FLD: QW0225GW LEN(4) TYPE(BIN) DISP(16)    /*! # of GBP write engines*/
FLD: QW0225PF LEN(4) TYPE(BIN) DISP(20)     /*! # of prefetch engines*/
FLD: QW0225PL LEN(4) TYPE(BIN) DISP(24)
                                  /*! # of P lock/notify exit engines*/
*
******************************************************************* 
*   IFCID 0225 Data Section 3: Shared and Common Storage Summary
******************************************************************* 
***********************************************************************
**** QW02253 DSECT
***********************************************************************

COMP: QW02253_OFFSET =
           WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R3N > 0)
                                  ASSIGN(QWS40R3O)
           ELSE                   ASSIGN(99999)
FLD: QW02253  DISP(0) LEN(1) OFFSET(QW02253_OFFSET)
FLD: QW0225EC LEN(4) TYPE(BIN) DISP(0)      /*! MVS extended CSA size*/
FLD: QW0225FC LEN(4) TYPE(BIN) DISP(4)
                           /*! Total 31 bit common fixed pool storage*/
FLD: QW0225VC LEN(4) TYPE(BIN) DISP(8)
                        /*! Total 31 bit common variable pool storage*/
FLD: QW0225GC LEN(4) TYPE(BIN) DISP(12)
                            /*! Total 31 bit common getmained storage*/
FLD: QW0225FCG LEN(8) TYPE(BIN) DISP(16)
                           /*! Total 64 bit common fixed pool storage*/
FLD: QW0225VCG LEN(8) TYPE(BIN) DISP(24)
                        /*! Total 64 bit common variable pool storage*/
FLD: QW0225GCG LEN(8) TYPE(BIN) DISP(32)
                            /*! Total 64 bit common getmained storage*/
FLD: QW0225SMC LEN(8) TYPE(BIN) DISP(40)
                                  /*! Total 64 bit common storage for*/
* ! storage manager control structures
FLD: QW0225SV LEN(8) TYPE(BIN) DISP(48)
                        /*! Total 64 bit shared variable pool storage*/
FLD: QW0225SF LEN(8) TYPE(BIN) DISP(56)
                           /*! Total 64 bit shared fixed pool storage*/
FLD: QW0225SG LEN(8) TYPE(BIN) DISP(64)
                            /*! Total 64 bit shared getmained storage*/
FLD: QW0225SMS LEN(8) TYPE(BIN) DISP(72)
                                  /*! Total 64 bit shared storage for*/
* ! storage manager control structures
FLD: QW0225GSG_SYS LEN(8) TYPE(BIN) DISP(80)
                           /*! Total 64 bit shared system agent stack*/
FLD: QW0225SUG_SYS LEN(8) TYPE(BIN) DISP(88)
                           /*! Total 64 bit shared system agent stack*/
* ! in use
FLD: QW0225GSG LEN(8) TYPE(BIN) DISP(96)
                             /*! Total 64 bit shared non system agent*/
* ! stack
FLD: QW0225SUG LEN(8) TYPE(BIN) DISP(104)
                             /*! Total 64 bit shared non system agent*/
* ! stack in use
FLD: QW0225SHRNMOMB LEN(4) TYPE(BIN) DISP(116)
                                  /*! Number of shared memory objects*/
* ! allocated for this MVS LPAR
FLD: QW0225SHRPAGES LEN(8) TYPE(BIN) DISP(120)
                             /*! Number of 64 bit shared memory pages*/
* ! allocated for this MVS LPAR (this
* ! count includes hidden pages)
FLD: QW0225SHRGBYTES LEN(8) TYPE(BIN) DISP(128)
                             /*! High water mark for number of 64 bit*/
* ! shared bytes for this MVS LPAR
FLD: QW0225SHRINREAL LEN(8) TYPE(BIN) DISP(136)
                             /*! Number of 64 bit shared pages backed*/
* ! in real storage (4K pages) for this
* ! MVS LPAR
FLD: QW0225SHRAUXSLOTS LEN(8) TYPE(BIN) DISP(144)
                               /*! Number of auxiliary slots used for*/
* ! 64-bit shared storage for this
* ! MVS LPAR
FLD: QW0225SHRPAGEINS LEN(8) TYPE(BIN) DISP(152)
                                  /*! Number of 64 bit shared pages*/
* ! paged in from auxiliary storage for
* ! this MVS LPAR
FLD: QW0225SHRPAGEOUTS LEN(8) TYPE(BIN) DISP(160)
                                  /*! Number of 64 bit shared pages*/
* ! paged out to auxiliary storage
* ! for this MVS LPAR
*
******************************************************************* 
*   IFCID 0225 Data Section 4: Statement Cache and xPROC Detail
******************************************************************* 
***********************************************************************
**** QW02254 DSECT
***********************************************************************

COMP: QW02254_OFFSET =
           WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R4N > 0)
                                  ASSIGN(QWS40R4O)
           ELSE                   ASSIGN(99999)
FLD: QW02254  DISP(0) LEN(1) OFFSET(QW02254_OFFSET)
FLD: QW0225SC LEN(4) TYPE(BIN) DISP(0)
                           /*! Total 31 bit xPROC storage for dynamic*/
* ! SQL used by active threads
* ! (31-bit DBM1 private variable pool)
FLD: QW0225LS LEN(4) TYPE(BIN) DISP(4)
                       /*! Allocated 31 bit xPROC storage for dynamic*/
* ! SQL used by active threads
FLD: QW0225SX LEN(4) TYPE(BIN) DISP(8)
                            /*! Total 31 bit xPROC storage for static*/
* ! SQL statements
* ! (31-bit DBM1 private variable pool)
FLD: QW0225HS LEN(4) TYPE(BIN) DISP(12)
                       /*! High water mark allocated for 31 bit xPROC*/
* ! storage for dynamic SQL used by active
* ! threads
FLD: QW0225LC LEN(4) TYPE(BIN) DISP(16)
                      /*! # of statements in 64 bit agent local pools*/
* ! (64-bit shared agent local variable pools)
FLD: QW0225HC LEN(4) TYPE(BIN) DISP(20)
                        /*! High water mark # of statements in 64 bit*/
* ! agent local pools at high storage time
* ! (64-bit shared agent local variable pools)
FLD: QW0225L2 LEN(8) TYPE(BIN) DISP(24)
                      /*! Allocated statement cache storage in 64 bit*/
* ! agent local pools
* ! (64-bit shared agent local variable pools)
FLD: QW0225H2 LEN(8) TYPE(BIN) DISP(32)
                          /*! High water mark for allocated statement*/
* ! cache storage in 64-bit agent local pools
* ! (64-bit shared agent local variable pools)
FLD: QW0225HT TYPE(STCKTIME) DISP(40)
                         /*! Timestamp of high water mark for storage*/
* ! allocated in 64-bit agent local pools
* ! since the last IFCID225 was written
* ! (64-bit shared agent local variable pools)
FLD: QW0225HT_D LEN(8) TYPE(STCKDATE) DISP(QW0225HT) /* Date */   
FLD: QW0225S2 LEN(8) TYPE(BIN) DISP(48)
                                /*! Total 64 bit STMT CACHE BLOCKS 2G*/
* ! storage
* ! (64-bit shared variable pool)
FLD: QW0225F1 LEN(8) TYPE(BIN) DISP(56)                       /*! (S)*/
FLD: QW0225F2 LEN(8) TYPE(BIN) DISP(64)                       /*! (S)*/

******************************************************************* 
*   IFCID 0225 Data Section 5: Pool Details
******************************************************************* 
***********************************************************************
**** QW02255 DSECT
***********************************************************************

COMP: QW02255_OFFSET =
           WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R5N > 0)
                                  ASSIGN(QWS40R5O)
           ELSE                   ASSIGN(99999)
FLD: QW02255  DISP(0) LEN(1) OFFSET(QW02255_OFFSET)
FLD: QW0225AL LEN(4) TYPE(BIN) DISP(0)  /*! Total agent local storage*/
* ! (31-bit DBM1 private variable pools)
FLD: QW0225AS LEN(4) TYPE(BIN) DISP(4) /*! Total system agent storage*/
* ! (31-bit DBM1 private variable pools)
FLD: QW0225ALG LEN(8) TYPE(BIN) DISP(8) /*! Total agent local storage*/
* ! (64-bit shared variable pools)
FLD: QW0225ASG LEN(8) TYPE(BIN) DISP(16)
                                  /*! Total system agent storage*/
* ! (64-bit shared variable pools)
FLD: QW0225BB LEN(8) TYPE(BIN) DISP(24)
                              /*! Total buffer manager storage blocks*/
* ! (31-bit DBM1 private variable pool)
FLD: QW0225RP LEN(8) TYPE(BIN) DISP(32)    /*! Total RID pool storage*/
* ! (64-bit shared fixed pool)
FLD: QW0225CD LEN(8) TYPE(BIN) DISP(40)
                             /*! Total compression dictionary storage*/
* ! (64-bit DBM1 private getmained)
FLD: SMF100_END LEN(1) OFFSET(0)

 


 

Sample Report from SMF 100 Records (IFCID=1)
Showing Control Address Space Statistics


The sample SMF report below was created with
Spectrum SMF Writer, the low-cost 4GL SMF report writer. It reads as input the SMF file and selects just the type 100 DB2 accounting records with IFCID = 1. (See SMF 100 record layout.) It then prints a report line for each address space found in these DB2 statistics records. (Note that each SMF record has a variable number of the QWSA statistical sections containing the address space information.) The report shows timing information about those DB2 address spaces.

All of this with just a couple of dozen lines of code!
Why not install a Spectrum SMF Writer trial right now and start making your own SMF reports!

These Spectrum SMF Writer Statements:


OPTION: STCKADJ(0)  /* DON'T CONVERT STCK TIMES TO GMT */
INPUT: SMF100  NORMWHEN(SM100RTY = 100 AND QWHSIID =1)
               NORMALIZE(QWSA_SECTION, QWS00R1N)
TITLE: 'CONTROL ADDRESS SPACES STATISTICS'
TITLE: 'FROM SMF100 IFCID=1 RECORDS: QWSA SEGMENTS'
INC: SM100RTY = 100    AND QWHSIID =1
COL: SM100DTE('SMF DATE')  SM100TME('SMF TIME')
     SM100RTY(3 'REC')
     QWHSIID(5 'IFCID')
     QWSAPROC('PROC|NAME')
     QWSAEJST('JOB STEP|TIMER')
     QWSASRBT('SRB TIMER')
     QWSAASID('ASID')
     QWSAASCB('ASCB|TOKEN')
     QWSAPSRB('PREEMTABLE|SRB TIMER' BIZ)
     QWSAPSRB_ZIIP('PREEMTABLE/|SRB TIMER|ON ZIIP' BIZ)

 

Produce This SMF Report:


                                         CONTROL ADDRESS SPACES STATISTICS
                                    FROM SMF100 IFCID=1 RECORDS: QWSA SEGMENTS
                                                                                                    PREEMTABLE
                                PROC    JOB STEP                                    PREEMTABLE       SRB TIMER
 SMF DATE  SMF TIME   REC IFCID NAME      TIMER         SRB TIMER        ASID        SRB TIMER        ON ZIIP
 ________ ___________ ___ _____ ____ _______________ _______________ ____________ _______________ _______________

 06/12/09 12:03:46.55 100     1 PROD 00:00:26.353201 00:00:06.418556          268
 06/12/09 12:03:46.55 100     1 DB29 00:00:00.984284 00:00:02.309871          289
 06/12/09 12:03:46.55 100     1 SLLP 00:00:00.190581 00:00:00.388122          292
 06/12/09 12:03:46.55 100     1 TA21 00:00:00.062769 00:00:14.998279          276
 06/12/09 12:03:51.48 100     1 PROD 00:00:26.192744 00:00:06.612312          269
 06/12/09 12:03:51.48 100     1 DB29 00:00:01.014337 00:00:01.863685          291
 06/12/09 12:03:51.48 100     1 SLLP 00:00:00.206780 00:00:00.382417          297
 06/12/09 12:03:51.48 100     1 TA21 00:00:00.058647 00:00:14.996602          275
 06/12/09 12:03:52.19 100     1 PROD 00:00:28.926771 00:01:12.779766          271
 06/12/09 12:03:52.19 100     1 DB29 00:00:02.513809 00:00:56.396282          294 00:00:01.273490
 06/12/09 12:03:52.19 100     1 SLLP 00:00:01.288933 00:06:03.825810          298 00:05:58.706745 00:00:00.002479
 06/12/09 12:03:52.19 100     1 TA21 00:00:00.057327 00:02:23.828467          277
 06/12/09 12:03:52.83 100     1 PROD 00:00:25.490909 00:00:05.883280          267
 06/12/09 12:03:52.83 100     1 DB29 00:00:00.911352 00:00:00.790773          288
 06/12/09 12:03:52.83 100     1 SLLP 00:00:00.178934 00:00:00.381876          279
 06/12/09 12:03:52.83 100     1 TA21 00:00:00.058005 00:00:14.318580          270
 06/12/09 12:03:54.35 100     1 PROD 00:00:25.520822 00:00:10.007706          272
 06/12/09 12:03:54.35 100     1 DB29 00:00:01.856049 00:00:02.723942          280
 06/12/09 12:03:54.35 100     1 SLLP 00:00:00.215897 00:00:03.138022          290 00:00:02.454649
 06/12/09 12:03:54.35 100     1 TA21 00:00:00.058069 00:00:15.399257          274
 06/12/09 12:03:56.47 100     1 PROD 00:00:42.251758 00:04:54.637468          273 00:00:00.000029
 06/12/09 12:03:56.47 100     1 DB29 00:00:29.802770 02:37:51.911378          299 00:00:02.440131
 06/12/09 12:03:56.47 100     1 SLLP 00:00:10.836484 00:28:12.029379          304 00:27:33.412688 00:00:08.853904
 06/12/09 12:03:56.47 100     1 TA21 00:00:00.059007 00:02:20.790957          278
 06/12/09 12:28:21.16 100     1 PROD 00:00:26.368131 00:00:51.423475          289
 06/12/09 12:28:21.16 100     1 DB29 00:00:02.755845 00:01:23.944388          291 00:00:01.123953
 06/12/09 12:28:21.16 100     1 SLLP 00:00:02.027863 00:02:09.235654          292 00:02:05.506409 00:00:00.344498
 06/12/09 12:28:21.16 100     1 TA21 00:00:00.058659 00:02:08.357462          290
 06/12/09 12:29:07.57 100     1 PROD 00:01:16.265914 00:11:35.909179          298
 06/12/09 12:29:07.57 100     1 DB29 00:00:30.650497 08:19:41.220897          300 00:00:08.804316 00:00:00.000060
 06/12/09 12:29:07.57 100     1 SLLP 00:00:00.493098 00:01:21.454082          301 00:01:06.880166 00:00:00.168639
 06/12/09 12:29:07.57 100     1 TA21 00:00:00.062084 00:04:18.456757          299

 *** GRAND TOTAL (    32 ITEMS)

See other sample SMF reports.

Copyright 2017.
Pacific Systems Group.
All rights reserved.
Home | Products | Prices | Documentation | 30-Day Trials | Customer Reviews | Company | FAQ | Sample Reports | SMF Records
Send Your Comments or Questions