SMF Type 100 Record
This table shows the record layout for type 100 SMF records
(DATABASE 2 Statistics).
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) | |
|
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.
|
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.
|
File Definition for Type 100 SMF Records DATABASE 2 Statistics
***********************************************************************
* SPECTRUM SMF WRITER -- FILE DEFINITION STATEMENTS *
* SMF TYPE 100 RECORD - "DATABASE 2 STATISTICS" *
***********************************************************************
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) 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(FULL) /*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: 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*/
* /*THE FOLLOWING FIELDS REPEAT FOR EACH DATA ITEM */
FLD: QWHTDATA TYPE(FULL) /*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*/
***********************************************************************
* 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*/
FLD: QWS10END LEN(1) DISP(88) /*END OF THE SELF DEFINING SECTION*/
*
*******************************************************************
* QWSA DSNDQWSA * CONTROL ADDRESS SPACES STATISTICS
*******************************************************************
***********************************************************************
**** QWSA DSECT
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QWSA, USE:
* INPUT: SMF100
* NORMALIZE(QWSA, QWS00R1N)
***********************************************************************
COMP: QWSA_OFFSET =
WHEN(SM100RTY=100 AND QWS00R1N > 0) ASSIGN(QWS00R1O)
ELSE ASSIGN(99999)
FLD: QWSA DISP(0) LEN(44) 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
* NORMALIZE(QWSB, QWS00R2N)
***********************************************************************
COMP: QWSB_OFFSET =
WHEN(SM100RTY=100 AND QWS00R2N > 0) ASSIGN(QWS00R2O)
ELSE ASSIGN(99999)
FLD: QWSB DISP(0) LEN(28) 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
* NORMALIZE(QWSC, QWS00R3N)
***********************************************************************
COMP: QWSC_OFFSET =
WHEN(SM100RTY=100 AND QWS00R3N > 0) ASSIGN(QWS00R3O)
ELSE ASSIGN(99999)
FLD: QWSC DISP(0) LEN(24) 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) /*CONTROL BLOCK HEADER*/
FLD: QSSTID LEN(2) DISP(0) /*CONTROL BLOCK ID*/
FLD: QSSTLEN TYPE(HALF) DISP(2) /*LENGTH OF CONTROL BLOCK*/
FLD: QSSTDESC LEN(4) DISP(4) /*EBCDIC EYE CATCHER*/
FLD: QSSTDATA LEN(4) TYPE(BIN) DISP(8) /*STATISTICAL COUNTERS*/
FLD: QSSTGPLF LEN(4) TYPE(BIN) DISP(8) /*(S)*/
FLD: QSSTFPLF LEN(4) TYPE(BIN) DISP(12) /*(S)*/
FLD: QSSTFREF LEN(4) TYPE(BIN) DISP(16) /*(S)*/
FLD: QSSTEXPF LEN(4) TYPE(BIN) DISP(20) /*(S)*/
FLD: QSSTCONF LEN(4) TYPE(BIN) DISP(24) /*(S)*/
FLD: QSSTGPLV LEN(4) TYPE(BIN) DISP(28) /*(S)*/
FLD: QSSTFPLV LEN(4) TYPE(BIN) DISP(32) /*(S)*/
FLD: QSSTFREV LEN(4) TYPE(BIN) DISP(36) /*(S)*/
FLD: QSSTEXPV LEN(4) TYPE(BIN) DISP(40) /*(S)*/
FLD: QSSTCONV LEN(4) TYPE(BIN) DISP(44) /*(S)*/
FLD: QSSTGETM LEN(4) TYPE(BIN) DISP(48) /*(S)*/
FLD: QSSTFREM LEN(4) TYPE(BIN) DISP(52) /*(S)*/
FLD: QSSTRCNZ LEN(4) TYPE(BIN) DISP(56) /*(S)*/
FLD: QSSTCONT LEN(4) TYPE(BIN) DISP(60) /*(S)*/
FLD: QSSTCRIT LEN(4) TYPE(BIN) DISP(64) /*(S)*/
FLD: QSSTABND LEN(4) TYPE(BIN) DISP(68) /*(S)*/
FLD: QSST_SGETM LEN(4) TYPE(BIN) DISP(72) /*(S)*/
FLD: QSST_SGETR LEN(4) TYPE(BIN) DISP(76) /*(S)*/
FLD: QSST_SGETEXT LEN(4) TYPE(BIN) DISP(80) /*(S)*/
FLD: QSST_SFREEM LEN(4) TYPE(BIN) DISP(84) /*(S)*/
FLD: QSST_SFREER LEN(4) TYPE(BIN) DISP(88) /*(S)*/
FLD: QSSTEND LEN(1) DISP(92) /*END OF CONTROL BLOCK*/
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 LEN(16) DISP(0) /*%U LOCATION NAME OF THE 'REMOTE'*/
* SITE WITH WHICH THE
* INFORMATION IS ASSOCIATED.
* Truncated if QLSTLOCN_Off¬=0
FLD: QLSTSQLS LEN(4) TYPE(BIN) DISP(16)
/*NUMBER OF SQL STATEMENTS SENT*/
* TO THE REMOTE SITE.
FLD: QLSTSQLR LEN(4) TYPE(BIN) DISP(20) /*NUMBER OF SQL STATEMENTS*/
* RECEIVED FROM THE REMOTE SITE.
FLD: QLSTROWS LEN(4) TYPE(BIN) DISP(24)
/*NUMBER OF ROWS OF DATA SENT TO THE*/
* REMOTE SITE (INCLUDES THE SQLDA)
FLD: QLSTROWR LEN(4) TYPE(BIN) DISP(28) /*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: QLSTBYTS LEN(4) TYPE(BIN) DISP(32)
/*NUMBER OF BYTES OF DATA SENT*/
* TO THE REMOTE SITE.
FLD: QLSTBYTR LEN(4) TYPE(BIN) DISP(36) /*NUMBER OF BYTES OF DATA*/
* RECEIVED FROM THE REMOTE SITE.
FLD: QLSTCNVS LEN(4) TYPE(BIN) DISP(40)
/*NUMBER OF CONVERSATIONS THAT*/
* WERE INITIATED FROM THIS
* SITE TO THE REMOTE SITE.
FLD: QLSTCNVR LEN(4) TYPE(BIN) DISP(44)
/*NUMBER OF CONVERSATIONS THAT*/
* WERE INITIATED FROM THE
* REMOTE SITE TO THIS SITE.
FLD: QLSTMSGS LEN(4) TYPE(BIN) DISP(48) /*NUMBER OF MESSAGES SENT TO*/
* THE REMOTE SITE.
FLD: QLSTMSGR LEN(4) TYPE(BIN) DISP(52) /*NUMBER OF MESSAGES RECEIVED*/
* FROM THE REMOTE SITE.
FLD: QLSTTRNS LEN(4) TYPE(BIN) DISP(56)
/*NUMBER OF DATABASE ACCESS THREAD ALLOCATION*/
* REQUESTS SENT TO THE REMOTE SITE
* (MEANINGFUL AT AR ONLY).
FLD: QLSTTRNR LEN(4) TYPE(BIN) DISP(60)
/*NUMBER OF DATABASE ACCESS THREAD ALLOCATION*/
* REQUESTS RECEIVED FROM THE REMOTE SITE
* (MEANINGFUL AT AS ONLY).
FLD: QLSTCOMS LEN(4) TYPE(BIN) DISP(64)
/*NUMBER OF COMMIT REQUESTS SENT TO THE*/
* SERVER (SINGLE-PHASE COMMIT
* PROTOCOL ONLY).
FLD: QLSTCOMR LEN(4) TYPE(BIN) DISP(68)
/*NUMBER OF COMMIT REQUESTS RECEIVED FROM THE*/
* REQUESTER (SINGLE-PHASE COMMIT
* PROTOCOL ONLY).
FLD: QLSTABRS LEN(4) TYPE(BIN) DISP(72)
/*NUMBER OF ABORT REQUESTS SENT TO THE SERVER*/
* (SINGLE-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTABRR LEN(4) TYPE(BIN) DISP(76)
/*NUMBER OF ABORT REQUESTS RECEIVED FROM THE*/
* REQUESTER (SINGLE-PHASE COMMIT
* PROTOCOL ONLY).
FLD: QLSTCNVQ LEN(4) TYPE(BIN) DISP(80)
/*NUMBER OF CONVERSATION REQUESTS*/
* QUEUED BY DDF WAITING FOR
* ALLOCATION.
FLD: QLSTCBLB LEN(4) TYPE(BIN) DISP(84)
/*NUMBER OF TIMES A SWITCH WAS MADE FROM*/
* CONTINUOUS BLOCK MODE TO LIMITED
* BLOCK MODE (SYSTEM DIRECTED ACCESS
* ONLY).
FLD: QLSTRBND LEN(4) TYPE(BIN) DISP(88)
/*NUMBER OF SQL STATEMENTS THAT WERE BOUND*/
* FOR REMOTE ACCESS (SYSTEM DIRECTED
* ACCESS ONLY).
FLD: QLSTBROW LEN(4) TYPE(BIN) DISP(92)
/*NUMBER OF ROWS IN THE MESSAGE BUFFER IF*/
* BLOCK FETCH IS BEING USED.
FLD: QLSTBTBF LEN(4) TYPE(BIN) DISP(96)
/*NUMBER OF BLOCKS TRANSMITTED USING BLOCK*/
* FETCH (SERVER SITE ONLY).
FLD: QLSTBRBF LEN(4) TYPE(BIN) DISP(100)
/*NUMBER OF BLOCKS RECEIVED USING BLOCK*/
* FETCH (REQUESTER SITE ONLY).
FLD: QLSTPRSE LEN(4) TYPE(BIN) DISP(104)
/*NUMBER OF PREPARE REQUESTS SENT TO THE*/
* PARTICIPANT
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTPRRC LEN(4) TYPE(BIN) DISP(108)
/*NUMBER OF PREPARE REQUESTS RECEIVED FROM THE*/
* COORDINATOR
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTLASE LEN(4) TYPE(BIN) DISP(112)
/*NUMBER OF LAST AGENT REQUESTS SENT TO THE*/
* COORDINATOR
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTLARC LEN(4) TYPE(BIN) DISP(116)
/*NUMBER OF LAST AGENT REQUESTS RECEIVED FROM THE*/
* INITIATOR
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTCRSE LEN(4) TYPE(BIN) DISP(120)
/*NUMBER OF COMMITED REQUESTS SENT TO THE*/
* PARTICIPANT
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTCRRC LEN(4) TYPE(BIN) DISP(124)
/*NUMBER OF COMMITED REQUESTS RECEIVED FROM THEE*/
* COORDINATOR
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTBKSE LEN(4) TYPE(BIN) DISP(128)
/*NUMBER OF BACKOUT REQUESTS SENT TO THE*/
* PARTICIPANT
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTBKRC LEN(4) TYPE(BIN) DISP(132)
/*NUMBER OF BACKOUT REQUESTS RECEIVED FROM THE*/
* COORDINATOR
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTRRSE LEN(4) TYPE(BIN) DISP(136)
/*NUMBER OF FORGET RESPONSES SENT TO THE*/
* COORDINATOR
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTRRRC LEN(4) TYPE(BIN) DISP(140)
/*NUMBER OF FORGET RESPONSES RECEIVED FROM THE*/
* PARTICIPANT
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTVYSE LEN(4) TYPE(BIN) DISP(144)
/*NUMBER OF REQUEST COMMIT RESPONSES SENT TO THE*/
* COORDINATOR
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTVYRC LEN(4) TYPE(BIN) DISP(148)
/*NUMBER OF REQUEST COMMIT RESPONSES RECEIVED*/
* FROM THE PARTICIPANT
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTVNSE LEN(4) TYPE(BIN) DISP(152)
/*NUMBER OF BACKOUT RESPONSES SENT TO THE*/
* COORDINATOR
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTVNRC LEN(4) TYPE(BIN) DISP(156)
/*NUMBER OF BACKOUT RESPONSES RECEIVED FROM THE*/
* PARTICIPANT
* (TWO-PHASE COMMIT PROTOCOL ONLY).
FLD: QLSTINDT LEN(4) TYPE(BIN) DISP(160)
/*NUMBER OF THREADS THAT BECAME INDOUBT WITH THE*/
* REMOTE LOCATION AS THE COORDINATOR.
FLD: QLSTCPTR LEN(4) TYPE(BIN) DISP(164)
/*NUMBER OF COMMIT OPERATIONS PERFORMED WITH THE*/
* REMOTE LOCATION AS COORDINATOR.
FLD: QLSTRBTR LEN(4) TYPE(BIN) DISP(168)
/*NUMBER OF ROLLBACK OPERATIONS PERFORMED WITH*/
* THE REMOTE LOCATION AS COORDINATOR.
FLD: QLSTLOCN_OFF TYPE(HALF) DISP(172) /*Offset from QLST to*/
* LOCATION NAME OF THE 'REMOTE'
* SITE WITH WHICH THE
* INFORMATION IS ASSOCIATED.
* If QLSTLOCN truncated
FLD: QLSTEND LEN(4) TYPE(BIN) DISP(176)
*
*
***********************************************************************
**** 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: 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*/
* /* WAS QUEUED DUE TO HAVING */
* /* REACHED THE ZPARM MAX FOR */
* /* ACTIVE REMOTE THREADS */
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) /*THE NUMBER OF CONVERSATIONS*/
* /* DEALLOCATED BECAUSE THE */
* /* ZPARM LIMIT FOR MAXIMUM */
* /* CONNECTED REMOTE THREADS */
* /* REACHED. */
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) /*THE CURRENT NUMBER OF*/
* /* ACTIVE DBATs */
FLD: QDSTHWAT LEN(4) TYPE(BIN) DISP(36) /*THE MAXIMUM NUMBER OF*/
* /* ACTIVE DBATs THAT */
* /* EXISTED (HIGH WATER MARK) */
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 CONNECTIONS THAT*/
* /* WERE TERMINATED RATHER THAN*/
* /* MADE TYPE 1 INACTIVE */
* /* BECAUSE MAX TYPE 1 INACTIVE*/
* /* WAS REACHED. */
FLD: QDSTCIN2 LEN(4) TYPE(BIN) DISP(48) /*CURRENT NUMBER OF TYPE 2*/
* /* INACTIVE THREADS */
FLD: QDSTMIN2 LEN(4) TYPE(BIN) DISP(52) /*MAXIMUM NUMBER OF TYPE 2*/
* /* INACTIVE THREADS (HIGH */
* /* WATER MARK). */
FLD: QDSTQIN2 LEN(4) TYPE(BIN) DISP(56) /*NUMBER OF QUEUED RECEIVE*/
* /* REQUESTS FOR A TYPE 2 */
* /* INACTIVE THREAD AND NUMBER */
* /* OF REQUESTS FOR NEW */
* /* CONNECTIONS THAT WERE */
* /* RECEIVED AFTER MAX REMOTE */
* /* ACTIVE WAS REACHED. */
FLD: QDSTNQR2 LEN(4) TYPE(BIN) DISP(60) /*CURRENT NUMBER OF TYPE 2*/
* /* INACTIVE THREADS THAT ARE */
* /* QUEUED WAITING TO PROCESS. */
* /* THIS INCLUDES BOTH RECEIVE */
* /* REQUESTS THAT COMPLETED */
* /* FOR A TYPE 2 INACTIVE */
* /* THREAD AS WELL AS REQUESTS */
* /* FOR NEW CONNECTIONS THAT */
* /* WERE RECEIVED AFTER MAX */
* /* REMOTE ACTIVE WAS REACHED. */
FLD: QDSTMQR2 LEN(4) TYPE(BIN) DISP(64) /*MAXIMUM NUMBER OF TYPE 2*/
* /* INACTIVE THREADS THAT WERE */
* /* QUEUED WAITING FOR A DATA */
* /* BASE ACCESS THREAD. THIS */
* /* INCLUDES BOTH RECEIVE */
* /* REQUESTS THAT COMPLETED FOR*/
* /* A TYPE 2 INACTIVE THREAD AS*/
* /* WELL AS REQUESTS FOR NEW */
* /* CONNECTIONS THAT WERE */
* /* RECEIVED AFTER MAX REMOTE */
* /* ACTIVE WAS REACHED. (HIGH */
* /* WATER MARK) */
FLD: QDSTNADS LEN(4) TYPE(BIN) DISP(68) /*CURRENT NUMBER OF ACTIVE*/
* /* DATABASE ACCESS THREAD */
* /* SLOTS THAT ARE NOT IN USE. */
* /* THE SLOT WILL BE ASSIGNED */
* /* WHEN EITHER A QUEUED */
* /* RECEIVE REQUEST COMPLETES */
* /* OR A REQUEST FOR A NEW */
* /* CONNECTION IS RECEIVED. */
FLD: QDSTMADS LEN(4) TYPE(BIN) DISP(72) /*MAXIMUM NUMBER OF DATABASE*/
* /* ACCESS THREAD SLOTS THAT */
* /* WERE NOT IN USE BECAUSE NO */
* /* PROCESSING WAS REQUIRED */
* /* EITHER TO COMPLETE A QUEUED*/
* /* RECEIVE REQUEST OR TO */
* /* ESTABLISH A NEW CONNECTION.*/
* /* (HIGH WATER MARK). */
FLD: QDSTNDBA LEN(4) TYPE(BIN) DISP(76) /*THE NUMBER OF REQUESTS THAT*/
* /* REQUIRED A DATA BASE ACCESS*/
* /* THREAD TO PROCESS THE */
* /* REQUEST. NOTE THAT THIS */
* /* DOES NOT INCLUDE DATA BASE */
* /* ACCESS THREADS CREATED TO */
* /* REPLACE POOL THREADS THAT */
* /* TERMINATED BECAUSE THEY */
* /* REACHED THEIR REUSE LIMIT. */
FLD: QDSTPOOL LEN(4) TYPE(BIN) DISP(80) /*THE NUMBER OF REQUESTS*/
* /* THAT WERE SATISFIED BY */
* /* ASSIGNING A POOL THREAD TO */
* /* PROCESS THE REQUEST. */
FLD: QDSTEND LEN(1) DISP(84)
*******************************************************************
* 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(4) TYPE(BIN) DISP(8) /*OVERLAY ON QXSTATS*/
FLD: QXSTATS LEN(4) TYPE(BIN) DISP(8) /*ACCOUNTING STATISTICS*/
FLD: QXSELECT LEN(4) TYPE(BIN) DISP(8) /*# OF SELECTS*/
FLD: QXINSRT LEN(4) TYPE(BIN) DISP(12) /*# OF INSERTS*/
FLD: QXUPDTE LEN(4) TYPE(BIN) DISP(16) /*# OF UPDATES*/
FLD: QXDELET LEN(4) TYPE(BIN) DISP(20) /*# OF DELETES*/
FLD: QXDESC LEN(4) TYPE(BIN) DISP(24) /*# OF DESCRIBES*/
FLD: QXPREP LEN(4) TYPE(BIN) DISP(28) /*# OF PREPARES*/
FLD: QXOPEN LEN(4) TYPE(BIN) DISP(32) /*# OF OPENS*/
FLD: QXCLOSE LEN(4) TYPE(BIN) DISP(36) /*# OF CLOSES*/
FLD: QXCRTAB LEN(4) TYPE(BIN) DISP(40) /*# OF CREATE TABLE*/
FLD: QXCRINX LEN(4) TYPE(BIN) DISP(44) /*# OF CREATE INDEX*/
FLD: QXCTABS LEN(4) TYPE(BIN) DISP(48) /*# OF CREATE TABLESPACE*/
FLD: QXCRSYN LEN(4) TYPE(BIN) DISP(52) /*# OF CREATE SYNONYM*/
FLD: QXCRDAB LEN(4) TYPE(BIN) DISP(56) /*# OF CREATE DATABASE*/
FLD: QXCRSTG LEN(4) TYPE(BIN) DISP(60) /*# OF CREATE STORAGE GROUP*/
FLD: QXDEFVU LEN(4) TYPE(BIN) DISP(64) /*# OF CREATE VIEW*/
FLD: QXDRPIX LEN(4) TYPE(BIN) DISP(68) /*# OF DROP INDEX*/
FLD: QXDRPTA LEN(4) TYPE(BIN) DISP(72) /*# OF DROP TABLE*/
FLD: QXDRPTS LEN(4) TYPE(BIN) DISP(76) /*# OF DROP TABLESPACE*/
FLD: QXDRPDB LEN(4) TYPE(BIN) DISP(80) /*# OF DROP DATABASE*/
FLD: QXDRPSY LEN(4) TYPE(BIN) DISP(84) /*# OF DROP SYNONYM*/
FLD: QXDRPST LEN(4) TYPE(BIN) DISP(88) /*# OF DROP STORAGE GROUP*/
FLD: QXDRPVU LEN(4) TYPE(BIN) DISP(92) /*# OF DROP VIEW*/
FLD: QXALTST LEN(4) TYPE(BIN) DISP(96) /*# OF ALTER STORAGE GROUP*/
FLD: QXFETCH LEN(4) TYPE(BIN) DISP(100) /*# OF FETCHS*/
FLD: QXALTTS LEN(4) TYPE(BIN) DISP(104) /*# OF ALTER TABLESPACE*/
FLD: QXALTTA LEN(4) TYPE(BIN) DISP(108) /*# OF ALTER TABLE*/
FLD: QXALTIX LEN(4) TYPE(BIN) DISP(112) /*# OF ALTER INDEX*/
FLD: QXCMTON LEN(4) TYPE(BIN) DISP(116) /*# OF COMMENT ON*/
FLD: QXLOCK LEN(4) TYPE(BIN) DISP(120) /*# OF LOCK TABLE*/
FLD: QXGRANT LEN(4) TYPE(BIN) DISP(124) /*# OF GRANT*/
FLD: QXREVOK LEN(4) TYPE(BIN) DISP(128) /*# OF REVOKE*/
FLD: QXINCRB LEN(4) TYPE(BIN) DISP(132)
/*# OF INCREMENTAL BINDS EXCLUDING PREPARES*/
FLD: QXLABON LEN(4) TYPE(BIN) DISP(136) /*# OF LABEL ON*/
FLD: QXSETSQL LEN(4) TYPE(BIN) DISP(140) /*# OF Set Current SQLID 1*/
FLD: QXCRALS LEN(4) TYPE(BIN) DISP(144) /*# OF CREATE ALIAS 2*/
FLD: QXDRPAL LEN(4) TYPE(BIN) DISP(148) /*# OF DROP ALIAS 2*/
FLD: QXMIAP LEN(4) TYPE(BIN) DISP(152)
/*# 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(4) TYPE(BIN) DISP(156)
/*# 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(4) TYPE(BIN) DISP(160)
/*# 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(4) TYPE(BIN) DISP(164)
/*# OF Set Host Variable statements, we 6*/
* don't trace the contents of the special 6
* register. 6
FLD: QXALDAB LEN(4) TYPE(BIN) DISP(168) /*# OF ALTER DATABASE 7*/
FLD: QXDRPPKG LEN(4) TYPE(BIN) DISP(172)
/*# OF DROP PACKAGE STATEMENTS 8*/
FLD: QXDSCRTB LEN(4) TYPE(BIN) DISP(176)
/*# OF DESCRIBE TABLE STATEMENTS 8*/
FLD: QXMAXDEG LEN(4) TYPE(BIN) DISP(180)
/*Maximum degree of parallelism among the A*/
* parallel groups to indicate the extent to A
* which query parallelism applies. A
FLD: QXTOTGRP LEN(4) TYPE(BIN) DISP(184)
/*Total number of parallel groups executed A*/
FLD: QXDEGCUR LEN(4) TYPE(BIN) DISP(188)
/*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(4) TYPE(BIN) DISP(192)
/*Total number of parallel groups which fellA*/
* back to sequential mode due to lack of A
* ESA sort support. A
FLD: QXDEGBUF LEN(4) TYPE(BIN) DISP(196)
/*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(4) TYPE(BIN) DISP(200)
/*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(4) TYPE(BIN) DISP(204)
/*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(4) TYPE(BIN) DISP(208)
/*# of CONNECT type 1 statements executed B*/
FLD: QXCON2 LEN(4) TYPE(BIN) DISP(212)
/*# of CONNECT type 2 statements executed B*/
FLD: QXREL LEN(4) TYPE(BIN) DISP(216)
/*# of RELEASE statements executed B*/
FLD: QXSETCON LEN(4) TYPE(BIN) DISP(220)
/*# of SET CONNECTION statements executed B*/
FLD: QXSETCDG LEN(4) TYPE(BIN) DISP(224)
/*# of SET CURRENT DEGREE statements A*/
* executed
FLD: QXSETCRL LEN(4) TYPE(BIN) DISP(228)
/*# of SET CURRENT RULES statements D*/
FLD: QXCALL LEN(4) TYPE(BIN) DISP(232)
/*# of SQL CALL statements executed F*/
FLD: QXCALLAB LEN(4) TYPE(BIN) DISP(236)
/*# of times a stored procedure ABENDed F*/
FLD: QXCALLTO LEN(4) TYPE(BIN) DISP(240)
/*# of times an SQL CALL statement timed F*/
* out waiting to be scheduled F
FLD: QXCALLRJ LEN(4) TYPE(BIN) DISP(244)
/*# of times an SQL CALL statement was F*/
* rejected F
FLD: QXDEGENC LEN(4) TYPE(BIN) DISP(248)
/*Total number of parallel groups executed G*/
* in sequential mode due to the unavailable G
* enclave G
FLD: QXRLFDPA LEN(1) DISP(252)
/*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(4) TYPE(BIN) DISP(256)
/*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(4) TYPE(BIN) DISP(260)
/*Total number of parallel groups executed K*/
* on a single DB2 due to repeatable-read K
* or read-stability isolation. K
FLD: QXCRGTT LEN(4) TYPE(BIN) DISP(264)
/*# OF CREATE GLOBAL TEMPORARY TABLE M*/
FLD: QXSTREOP LEN(4) TYPE(BIN) DISP(268)
/*Total number of times reoptimization N*/
* occurs. This field does not apply to N
* IFCID 0002. N
FLD: QXXCBPNX LEN(4) TYPE(BIN) DISP(272)
/*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(4) TYPE(BIN) DISP(276)
/*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(4) TYPE(BIN) DISP(280)
/*Number of ASSOCIATE LOCATOR statements P*/
* executed P
FLD: QXALOCC LEN(4) TYPE(BIN) DISP(284)
/*Number of ALLOCATE CURSOR statements P*/
* statements executed P
FLD: QXSTFND LEN(4) TYPE(BIN) DISP(288)
/*The number of times a PREPARE request P*/
* was satisfied by making a copy from the P
* prepared statement cache P
FLD: QXSTNFND LEN(4) TYPE(BIN) DISP(292)
/*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(4) TYPE(BIN) DISP(296)
/*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(4) TYPE(BIN) DISP(300)
/*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(4) TYPE(BIN) DISP(304)
/*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(4) TYPE(BIN) DISP(308)
/*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(4) TYPE(BIN) DISP(312) /*# OF RENAME TABLE Q*/
FLD: QXCTRIG LEN(4) TYPE(BIN) DISP(316) /*# OF CREATE TRIGGER R*/
FLD: QXDRPTR LEN(4) TYPE(BIN) DISP(320) /*# OF DROP TRIGGER R*/
FLD: QXSETPTH LEN(4) TYPE(BIN) DISP(324)
/*# OF SET CURRENT PATH statements S*/
FLD: QXDRPFN LEN(4) TYPE(BIN) DISP(328)
/*# OF DROP USER DEFINED FUNCTION T*/
FLD: QXDRPPR LEN(4) TYPE(BIN) DISP(332) /*# OF DROP PROCEDURE T*/
FLD: QXCDIST LEN(4) TYPE(BIN) DISP(336)
/*# OF CREATE DISTINCT TYPE statements U*/
FLD: QXDDIST LEN(4) TYPE(BIN) DISP(340)
/*# OF DROP DISTINCT TYPE statements U*/
FLD: QXCRUDF LEN(4) TYPE(BIN) DISP(344)
/*# OF CREATE FUNCTION statements V*/
FLD: QXCRPRO LEN(4) TYPE(BIN) DISP(348)
/*# OF CREATE PROCEDURE statements c*/
FLD: QXHOLDL LEN(4) TYPE(BIN) DISP(352)
/*# OF HOLD LOCATOR statements W*/
FLD: QXFREEL LEN(4) TYPE(BIN) DISP(356)
/*# OF FREE LOCATOR statements W*/
FLD: QXREPOP1 LEN(4) TYPE(BIN) DISP(360)
/*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(4) TYPE(BIN) DISP(364)
/*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(4) TYPE(BIN) DISP(368)
/*# OF CREATE AUX TABLE statements c*/
FLD: QXSTLOBV LEN(4) TYPE(BIN) DISP(372)
/*Max storage used for LOB values Y*/
* In KB for accounting, in MB for statisticsY
FLD: QXALUDF LEN(4) TYPE(BIN) DISP(376)
/*# OF ALTER FUNCTION statements Z*/
FLD: QXALPRO LEN(4) TYPE(BIN) DISP(380)
/*# OF ALTER PROCEDURE statements Z*/
FLD: QXROIMAT LEN(4) TYPE(BIN) DISP(384)
/*# of times that direct row access was a*/
* successful
FLD: QXROIIDX LEN(4) TYPE(BIN) DISP(388)
/*# of times an attempt to use direct row a*/
* access reverted to using an index to a
* locate a record
FLD: QXROITS LEN(4) TYPE(BIN) DISP(392)
/*# 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(4) TYPE(BIN) DISP(396)
/*# of times a statement trigger was b*/
* activated b
FLD: QXROWTRG LEN(4) TYPE(BIN) DISP(400)
/*# of times a row trigger was activated b*/
FLD: QXTRGERR LEN(4) TYPE(BIN) DISP(404)
/*# of times an SQL error occurred during b*/
* execution of a triggered action b
FLD: QXCASCDP LEN(4) TYPE(BIN) DISP(408)
/*The maximum level of nested SQL b*/
* cascading. This includes cascading b
* due to triggers, UDFs and stored b
* procedures. b
FLD: QXCAUD LEN(4) TYPE(BIN) DISP(412)
/*# of user defined functions executed d*/
FLD: QXCAUDAB LEN(4) TYPE(BIN) DISP(416) /*# of times a UDF ABENDed d*/
FLD: QXCAUDTO LEN(4) TYPE(BIN) DISP(420)
/*# of times a UDF timed out waiting to d*/
* be scheduled d
FLD: QXCAUDRJ LEN(4) TYPE(BIN) DISP(424)
/*# of times a UDF was rejected d*/
FLD: QXSETCPR LEN(4) TYPE(BIN) DISP(428)
/*# SET CURRENT PRECISION statements e*/
* executed e
FLD: QXDCLGTT LEN(4) TYPE(BIN) DISP(432)
/*# of DECLARE GLOBAL TEMPORARY TABLE stmts f*/
FLD: QXDEGDTT LEN(4) TYPE(BIN) DISP(436)
/*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(4) TYPE(BIN) DISP(440) /*# OF CREATE SEQUENCES*/
FLD: QXALTSEQ LEN(4) TYPE(BIN) DISP(444) /*# OF ALTER SEQUENCES*/
FLD: QXDROSEQ LEN(4) TYPE(BIN) DISP(448) /*# OF DROP SEQUENCES*/
FLD: QXPRRESI LEN(4) TYPE(BIN) DISP(452)
/*# 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(4) TYPE(BIN) DISP(456) /*# of ALTER VIEW j*/
FLD: QXALTJR LEN(4) TYPE(BIN) DISP(460) /*# OF ALTER JAR k*/
FLD: QXMERGE LEN(4) TYPE(BIN) DISP(464)
/*# OF times MERGE statement was executed m*/
FLD: QXTRTBL LEN(4) TYPE(BIN) DISP(468)
/*# of times TRUNCATE TABLE was executed n*/
FLD: QXCRROL LEN(4) TYPE(BIN) DISP(472) /*# OF CREATE ROLE o*/
FLD: QXDRPROL LEN(4) TYPE(BIN) DISP(476) /*# OF DROP ROLE o*/
FLD: QXCRCTX LEN(4) TYPE(BIN) DISP(480)
/*# OF CREATE TRUSTED CONTEXT o*/
FLD: QXALTCTX LEN(4) TYPE(BIN) DISP(484)
/*# OF ALTER TRUSTED CONTEXT o*/
FLD: QXDRPCTX LEN(4) TYPE(BIN) DISP(488)
/*# OF DROP TRUSTED CONTEXT o*/
FLD: QXRNIX LEN(4) TYPE(BIN) DISP(492) /*# OF RENAME INDEX u*/
FLD: QXSTXMLV LEN(4) TYPE(BIN) DISP(496)
/*# Max storage used for XML values q*/
FLD: QXRWSFETCHD LEN(8) TYPE(BIN) DISP(504)
/*# Number of Rows Fetched @161*/
FLD: QXRWSINSRTD LEN(8) TYPE(BIN) DISP(512)
/*# Number of Rows Inserted @161*/
FLD: QXRWSUPDTD LEN(8) TYPE(BIN) DISP(520)
/*# Number of Rows Updated @161*/
FLD: QXRWSDELETD LEN(8) TYPE(BIN) DISP(528)
/*# Number of Rows Deleted @161*/
FLD: QXSTEND LEN(4) TYPE(BIN) DISP(536) /*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: QBSTGET LEN(4) TYPE(BIN) DISP(4)
/*# OF GET PAGE REQUESTS. INCLUDES BOTH*/
* CONDITIONAL AND NON-CONDITIONAL,
* SUCCESSFUL AND UNSUCCESSFUL REQUESTS
FLD: QBSTRIO LEN(4) TYPE(BIN) DISP(8)
/*# OF SYNC. READ I/O OPERATIONS PERFORMED*/
FLD: QBSTDWV LEN(4) TYPE(BIN) DISP(12)
/*# OF TIMES VERTICAL DEFERRED WRITE*/
* THRESHOLD REACHED
FLD: QBSTXFL LEN(4) TYPE(BIN) DISP(16)
/*# OF GETPAGE FAILURES DUE TO VPOOL FULL*/
FLD: QBSTXFV LEN(4) TYPE(BIN) DISP(20)
/*# OF EXPANSION FAILURE DUE TO SHORTAGE OF*/
* VIRTUAL STORAGE
FLD: QBSTSWS LEN(4) TYPE(BIN) DISP(24)
/*# OF SETW ISSUED FOR SYSTEM PAGES*/
FLD: QBSTPWS LEN(4) TYPE(BIN) DISP(32)
/*# OF PAGE WRITES FOR SYSTEM PAGES*/
FLD: QBSTWIO LEN(4) TYPE(BIN) DISP(40)
/*# OF ASYNC. WRITE I/O OPERATIONS PERFORMED*/
FLD: QBSTCBA LEN(4) TYPE(BIN) DISP(44) /*# OF CURRENT ACTIVE BUFFERS*/
FLD: QBSTRPI LEN(4) TYPE(BIN) DISP(48)
/*# OF PAGE IN REQUIRED FOR READ I/O*/
FLD: QBSTWPI LEN(4) TYPE(BIN) DISP(52)
/*# OF PAGE IN REQUIRED FOR WRITE I/O*/
FLD: QBSTDSO LEN(4) TYPE(BIN) DISP(56)
/*# OF DATA SETS OPENED SUCCESSFULLY*/
FLD: QBSTIMW LEN(4) TYPE(BIN) DISP(60)
/*# OF IMMED (SYNCHRONOUS) WRITE I/OS*/
FLD: QBSTSEQ LEN(4) TYPE(BIN) DISP(64) /*# OF SEQ PREFETCH REQUESTED*/
FLD: QBSTSPP LEN(4) TYPE(BIN) DISP(68)
/*# OF PAGE READ DUE TO SEQ PREFETCH*/
FLD: QBSTSPD LEN(4) TYPE(BIN) DISP(72)
/*# OF SEQ PREFETCH DISABLED DUE TO*/
* UNAVAILABLE BUFFER RESOURCES
FLD: QBSTREE LEN(4) TYPE(BIN) DISP(76)
/*# OF SEQ PREFETCH DISABLED DUE TO*/
* UNAVAILABLE READ ENGINE
FLD: QBSTDWT LEN(4) TYPE(BIN) DISP(84)
/*# OF TIMES THAT DEFERRED WRITE THRESHOLD*/
* IS REACHED
FLD: QBSTDMC LEN(4) TYPE(BIN) DISP(88)
/*# OF TIMES THAT THE DATA MANAGER BUFFER*/
* CRITICAL THRESHOLD HAS BEEN REACHED
FLD: QBSTMIG LEN(4) TYPE(BIN) DISP(92)
/*# OF TIMES THAT MIGRATED DATA SETS*/
* ENCOUNTERED
FLD: QBSTRTO LEN(4) TYPE(BIN) DISP(96) /*# OF RECALL TIMEOUTS*/
FLD: QBSTPIO LEN(4) TYPE(BIN) DISP(100)
/*# OF SEQ PREFETCH (ASYNCHRONOUS) READ I/OS*/
FLD: QBSTWKPD LEN(4) TYPE(BIN) DISP(104)
/*# OF WK PREFETCH ABORTED DUE TO A ZERO*/
* PREFETCH QUANTITY
FLD: QBSTMAX LEN(4) TYPE(BIN) DISP(108)
/*# OF WK FILE CANNOT BE CREATED DUE TO*/
* INSUFFICIENT BUFFER RESOURCES
FLD: QBSTWFM LEN(4) TYPE(BIN) DISP(112)
/*MAXIMUM WORKFILES EVER BEEN ALLOCATED*/
* DURING THE SORT/MERGE PROCESSING
FLD: QBSTWDRP LEN(4) TYPE(BIN) DISP(116)
/*# OF PAGES FOR WHICH DESTRUCTIVE READ WAS*/
* REQUESTED
FLD: QBSTWBVQ LEN(4) TYPE(BIN) DISP(120)
/*# OF PAGES DEQUEUED FROM DATA SET DEFERRED*/
* WRITE QUEUE FOR DESTRUCTIVE READ REQUEST
FLD: QBSTWFR LEN(4) TYPE(BIN) DISP(124)
/*COUNT OF REQUESTS TO QUERY FOR WORFILES*/
* IN THE PROCESS OF SORT/MERGE
FLD: QBSTWFT LEN(4) TYPE(BIN) DISP(128)
/*SUM OF WORKFILES THAT HAVE BEEN REQUESTED*/
* DURING THE SORT/MERGE PROCESSING
FLD: QBSTWFD LEN(4) TYPE(BIN) DISP(132)
/*SUM OF WORKFILES THAT HAVE BEEN DENIED*/
* DURING THE SORT/MERGE PROCESSING
FLD: QBSTWFF LEN(4) TYPE(BIN) DISP(136)
/*# OF TIMES SORT/MERGE COULD NOT BE*/
* EFFICIENTLY PERFORMED DUE TO THE BUFFER
* SHORTAGE
FLD: QBSTLPF LEN(4) TYPE(BIN) DISP(140)
/*# OF LIST PREFETCH REQUESTED*/
* CONCURRENT PREFETCH AGAINST SAME PAGESET
FLD: QBSTDPF LEN(4) TYPE(BIN) DISP(144)
/*# OF DYNAMIC PREFETCH REQUESTED*/
FLD: QBSTVPA LEN(4) TYPE(BIN) DISP(148)
/*# OF SUCCESSFUL VPOOL EXP/CONTRATION*/
FLD: QBSTPCO LEN(4) TYPE(BIN) DISP(152)
/*# OF PG on 'unlock castout'*/
FLD: QBSTCIO LEN(4) TYPE(BIN) DISP(156) /*# OF I/O on castout*/
FLD: QBSTVPL LEN(4) TYPE(BIN) DISP(180)
/*# OF BUFFERS ALLOCATED FOR VIRTUAL POOL*/
FLD: QBSTDPP LEN(4) TYPE(BIN) DISP(188)
/*# OF PAGE READ DUE TO DYNAMIC PREFETCH*/
FLD: QBSTLPP LEN(4) TYPE(BIN) DISP(192)
/*# OF PAGE READ DUE TO LIST PREFETCH*/
FLD: QBSTDIO LEN(4) TYPE(BIN) DISP(196)
/*# OF DYNAMIC PREFETCH (ASYNCHRONOUS)*/
* READ I/OS
FLD: QBSTLIO LEN(4) TYPE(BIN) DISP(200)
/*# OF LIST PREFETCH (ASYNCHRONOUS) READ I/O*/
FLD: QBSTSGT LEN(4) TYPE(BIN) DISP(204)
/*# OF GET PAGE ISSUED BY SEQUENTIAL REQUEST*/
FLD: QBSTSIO LEN(4) TYPE(BIN) DISP(208)
/*# OF SYNC. READ I/O OPERATIONS PERFORMED*/
* BY SEQUENTIAL REQUESTS
FLD: QBSTDWC LEN(4) TYPE(BIN) DISP(212) /*RESERVED KEF0230*/
FLD: QBSTDWX LEN(4) TYPE(BIN) DISP(216) /*RESERVED KEF0230*/
FLD: QBSTALX LEN(4) TYPE(BIN) DISP(220) /*RESERVED KEF0230*/
FLD: QBSTNGT LEN(4) TYPE(BIN) DISP(224)
/*# OF UNSUCCESSFUL GETPAGE DUE TO CONDI*/
* TIONAL GETPAGE REQUEST
FLD: QBSTXIS LEN(4) TYPE(BIN) DISP(228)
/*HIGHEST PREFETCH I/O STREAMS HAVE EVER BEEN*/
* ALLOCATED
FLD: QBSTJIS LEN(4) TYPE(BIN) DISP(232)
/*# 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(4) TYPE(BIN) DISP(236)
/*TOTAL # OF NEGOTIATIONS BETWEEN BM AND RDS*/
* RUNTIME TO SUPPORT PARALLELISM
FLD: QBSTPQF LEN(4) TYPE(BIN) DISP(240)
/*# OF TIMES PARALLELISM HAS BEEN DOWN*/
* GRADED DUE TO THE SHORTAGE OF BUFFERPOOL
FLD: QBSTPL1 LEN(4) TYPE(BIN) DISP(244)
/*TOTAL # OF OCCURRENCES WHEN PREFETCH QTY*/
* DECREASED FROM NORMAL TO HALF OF NORMAL.
* NORMAL IS BASED ON THE BUFFER POOL SIZE
FLD: QBSTPL2 LEN(4) TYPE(BIN) DISP(248)
/*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: QBSTLPL LEN(4) TYPE(BIN) DISP(272)
/*# of times one or more pages were*/
* added to LPL
FLD: QBSTEND LEN(4) TYPE(BIN) DISP(276)
*******************************************************************
* 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: QIHEAD LEN(4) TYPE(BIN) DISP(0) /*CONTROL BLOCK HEADER*/
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: QISTWFMU LEN(4) TYPE(BIN) DISP(36) /*Maximum total storage used*/
* /* in workfile db (MB) */
FLD: QISTWFCU LEN(4) TYPE(BIN) DISP(40) /*Current total whole MBs of*/
* /* storage used in WF db. */
FLD: QISTWFCK LEN(4) TYPE(BIN) DISP(44) /*Current total fractional*/
* /* MBs of storage used, in KB.*/
FLD: QISTWFMX LEN(4) TYPE(BIN) DISP(48) /*Maximum allowable storage*/
* /* usage limit per agent (MB) */
FLD: QISTWFNE LEN(4) TYPE(BIN) DISP(52) /*Number of times the maximum*/
* /* allowable storage usage */
* /* limit was exceeded */
FLD: QISTWF04 LEN(4) TYPE(BIN) DISP(56) /*Total 4KB tablespace*/
* /* storage used - whole MBs */
FLD: QISTW04K LEN(4) TYPE(BIN) DISP(60) /*Total 4KB tablespace*/
* /* storage used - fractional */
* /* MBs expressed in KBs. */
FLD: QISTWF32 LEN(4) TYPE(BIN) DISP(64) /*Total 32KB tablespace*/
* /* storage used - whole MBs */
FLD: QISTW32K LEN(4) TYPE(BIN) DISP(68) /*Total 32KB tablespace*/
* /* storage used - fractional */
* /* MBs expressed in KBs. */
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: QISTEND LEN(4) TYPE(BIN) DISP(80)
* SCC STATISTICS DATA FOR TYPE 100 SUBTYPE 1 RECORD
* SCC ACCOUNTING DATA FOR TYPE 101 SUBTYPE 0 RECORD
*******************************************************************
* 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) /*NUMBER OF PAGES IN EDM POOL*/
* /*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)
/*# OF PAGES USED FOR CT BELOW BAR*/
FLD: QISEFREE LEN(4) TYPE(BIN) DISP(20) /*# OF FREE PG IN FREE CHAIN*/
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) /*# OF PAGES USED FOR PT*/
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: QISEEND LEN(4) TYPE(BIN) DISP(148) /*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: QBGLGG LEN(4) TYPE(BIN) DISP(4) /*GetPages for GBP Dep pages*/
FLD: QBGLXD LEN(4) TYPE(BIN) DISP(8)
/*# of GBP reads under the user*/
* task that were
* necessary due to buffer cross
* invalidation (XI) in which
* data was returned */
FLD: QBGLXR LEN(4) TYPE(BIN) DISP(12)
/*# 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(4) TYPE(BIN) DISP(20)
/*# 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(4) TYPE(BIN) DISP(24)
/*# 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(4) TYPE(BIN) DISP(32) /*# of changed pages written*/
* under a user's execution */
* unit (via WAR or WARM) */
FLD: QBGLWC LEN(4) TYPE(BIN) DISP(36) /*# of clean pages written*/
* under a user's execution
* unit (via WAR or WARM) */
FLD: QBGLCT LEN(4) TYPE(BIN) DISP(40)
/*# of times castout was initiated*/
* due to the castout class
* threshold being detected. */
FLD: QBGLGT LEN(4) TYPE(BIN) DISP(44)
/*# of times castout was initiated*/
* due to the group buffer pool
* castout threshold being
* detected. */
FLD: QBGLWM LEN(4) TYPE(BIN) DISP(48) /*# of Write and Register*/
* Multiple (WARM) requests.
* Multiple pages written per
* request. */
FLD: QBGLWS LEN(4) TYPE(BIN) DISP(52) /*# of Write and Register*/
* (WAR) requests. One page
* written per request. */
FLD: QBGLEX LEN(4) TYPE(BIN) DISP(56)
/*# of explicit cross invalidate*/
FLD: QBGLAW LEN(4) TYPE(BIN) DISP(60) /*# of changed pages written*/
* under a system execution
* unit (via WAR or WARM). */
FLD: QBGLRC LEN(4) TYPE(BIN) DISP(64) /*# 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(4) TYPE(BIN) DISP(68) /*# Read For Castout Multiple*/
* RFCOM) requests. Multiple
* pages read per request. */
FLD: QBGLCR LEN(4) TYPE(BIN) DISP(72)
/*# of Read For Castout (RFCO)*/
* requests. One page read
* per request. */
FLD: QBGLWP LEN(4) TYPE(BIN) DISP(76) /*# of pages written via WARM*/
FLD: QBGLWF LEN(4) TYPE(BIN) DISP(80)
/*# of GBP write requests that*/
* could not complete due to a
* lack of GBP storage resour-
* ces. */
FLD: QBGLOS LEN(4) TYPE(BIN) DISP(84)
/*# of IXLCACHE 'read stgstats'*/
* requests. */
FLD: QBGLAC LEN(4) TYPE(BIN) DISP(88) /*# of changed pages written*/
* under a system execution
* unit (via WAR or WARM). */
FLD: QBGLAX LEN(4) TYPE(BIN) DISP(92)
/*# 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(4) TYPE(BIN) DISP(96)
/*# of pages retrieved from the*/
* group buffer pool
* as a result of feedback from
* RPL. */
FLD: QBGLCK LEN(4) TYPE(BIN) DISP(104)
/*# of GBP checkpoints triggered*/
* by this member. */
FLD: QBGLUN LEN(4) TYPE(BIN) DISP(112)
/*# IXLCACHE 'unlock castout'*/
* requests. */
FLD: QBGLCC LEN(4) TYPE(BIN) DISP(116)
/*# IXLCACHE 'read castout class'*/
* requests */
FLD: QBGLCS LEN(4) TYPE(BIN) DISP(120)
/*# IXLCACHE 'read castout stats'*/
* requests */
FLD: QBGLDN LEN(4) TYPE(BIN) DISP(124) /*# IXLCACHE 'delete name'*/
* requests */
FLD: QBGLRD LEN(4) TYPE(BIN) DISP(128) /*# IXLCACHE 'read dirinfo'*/
* requests */
FLD: QBGLRG LEN(4) TYPE(BIN) DISP(132)
/*# of 'register page' requests*/
FLD: QBGLDG LEN(4) TYPE(BIN) DISP(136) /*# of 'unregister page'*/
* requests */
FLD: QBGL2F LEN(4) TYPE(BIN) DISP(144)
/*# writes of changed pages to*/
* the secondary GBP that
* failed due to a lack of
* storage. */
FLD: QBGL2S LEN(4) TYPE(BIN) DISP(148)
/*# completion checks for writes*/
* to the secondary GBP that
* were suspended because the
* write had not yet completed.*/
FLD: QBGL2D LEN(4) TYPE(BIN) DISP(152)
/*# IXLCACHE 'delete name list'*/
* requests to the secondary
* GBP. */
FLD: QBGL2R LEN(4) TYPE(BIN) DISP(156)
/*# IXLCACHE 'read castout stats'*/
* requests to the secondary
* GBP. */
FLD: QBGL2N LEN(4) TYPE(BIN) DISP(160) /*# IXLCACHE 'delete name'*/
* requests to the secondary
* GBP. */
FLD: QBGLHS LEN(4) TYPE(BIN) DISP(164)
/*# Asynch IXLCACHE invocations*/
* for primary GBP. */
FLD: QBGL2H LEN(4) TYPE(BIN) DISP(168)
/*# Asynch IXLCACHE invocations*/
* for secondary GBP. */
FLD: QBGLP1 LEN(4) TYPE(BIN) DISP(172)
/*# page P lock lock requests for*/
* space map pages */
FLD: QBGLP2 LEN(4) TYPE(BIN) DISP(176)
/*# page P lock lock requests for*/
* data pages */
FLD: QBGLP3 LEN(4) TYPE(BIN) DISP(180)
/*# page P lock lock requests for*/
* index leaf pages */
FLD: QBGLU1 LEN(4) TYPE(BIN) DISP(184)
/*# page P lock unlock requests*/
FLD: QBGLS1 LEN(4) TYPE(BIN) DISP(188)
/*# page P lock lock suspensions*/
* for space map pages */
FLD: QBGLS2 LEN(4) TYPE(BIN) DISP(192)
/*# page P lock lock suspensions*/
* for data pages */
FLD: QBGLS3 LEN(4) TYPE(BIN) DISP(196)
/*# page P lock lock suspensions*/
* for index leaf pages */
FLD: QBGLN1 LEN(4) TYPE(BIN) DISP(200)
/*# page P lock lock negotiations*/
* for space map pages */
FLD: QBGLN2 LEN(4) TYPE(BIN) DISP(204)
/*# page P lock lock negotiations*/
* for data pages */
FLD: QBGLN3 LEN(4) TYPE(BIN) DISP(208)
/*# page P lock lock negotiations*/
* for index leaf pages */
FLD: QBGLEND LEN(1) DISP(212)
*******************************************************************
* 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)
/*# Summation of sync to async*/
* heuristic conversions for LOCK
* requests. 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
* encountered on this z/OS
* image. 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 that
* 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
* the ?IXLMG service. */
FLD: QTGSEND LEN(1) DISP(80)
*******************************************************************
* 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)
FLD: SMF100_END LEN(1) OFFSET(0) |
All of this with just a couple of dozen lines of code!
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.
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)
