SMF Type 100 Record
This table shows the record layout for type 100 SMF records
(DATABASE 2 Statistics - DB2 V10).
List of other SMF record layouts available.
List of sample SMF reports.
Purpose: DATABASE 2 (DB2) writes record type 100 to record transaction data collected at event monitoring points.
It's easy to report on SMF 100 data! (Jump to sample reports) | |
|
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 - DB2 V10
***********************************************************************
* SPECTRUM SMF WRITER -- FILE DEFINITION STATEMENTS *
* SMF TYPE 100 RECORD - "DATABASE 2 STATISTICS - DB2 V10" *
***********************************************************************
FLD: QWST LEN(4) TYPE(BIN) DISP(0) /*SMF 100 RECORD IFCID 0*/
*******************************************************************
* SMF COMMON HEADER MAPPING MACRO FOR STATISTICS TYPE 100
*******************************************************************
*
FLD: SM100BKE LEN(4) DISP(0)
/*END OF BLOCK ADDRESS WHEN COLLECTING DATA*/
FLD: SM100LEN LEN(2) DISP(0) /*SM100 TOTAL LENGTH*/
FLD: SM100SGD LEN(2) DISP(2) /*ZZ BYTES*/
FLD: SM100FLG LEN(1) DISP(4) /*SYSTEM INDICATOR*/
FLD: SM100RTY LEN(1) TYPE(BIN) DISP(5) /*RECORD TYPE X'64'*/
FLD: SM100TME LEN(4) TYPE(B-SECS) DISP(6) DEC(2)
/*TIME SMF MOVED RECORD*/
FLD: SM100DTE TYPE(P-CYYDDD) DISP(10) /*DATE SMF MOVED RECORD*/
FLD: SM100SID LEN(4) DISP(14) /*SYSTEM ID (SID)*/
FLD: SM100SSI LEN(4) DISP(18) /*SUBSYSTEM ID*/
FLD: SM100STF LEN(1) DISP(22) /*RESERVED*/
FLD: SM100RI LEN(1) DISP(23) /*RESERVED*/
FLD: SM100SEQ LEN(4) DISP(24) /*RESERVED*/
FLD: SM100BUF LEN(4) DISP(24) /*TEMPORARY POINTER TO BUFFER AREA*/
FLD: SM100END LEN(1) DISP(28) /*START OF THE SELF DEFINING SECTION*/
*
FLD: SM100PSO LEN(4) TYPE(BIN) DISP(28)
/*OFFSET TO THE PRODUCT SECTION*/
FLD: SM100PSL LEN(2) TYPE(BIN) DISP(32)
/*LENGTH OF THE PRODUCT SECTION*/
FLD: SM100PSN LEN(2) TYPE(BIN) DISP(34) /*NUMBER OF PRODUCT SECTIONS*/
*
* STANDARD HEADER MAPPED BY DSNDQWHS
***********************************************************************
* QWHS DSNDQWHS * STANDARD HEADER ALWAYS APPEARS
* QWHC DSNDQWHC * CORRELATION HEADER MAY APPEAR
* QWHT DSNDQWHT * TRACE HEADER MAY APPEAR
* QWHU DSNDQWHU * CPU HEADER MAY APPEAR
* QWHD DSNDQWHD * DISTRIBUTED HEADER MAY APPEAR
* QWHA DSNDQWHA * DATA SHARING HEADER
***********************************************************************
**** QWHS DSECT
COMP: QWHS_OFFSET =
WHEN(SM100RTY=100 AND SM100PSN > 0) ASSIGN(SM100PSO)
ELSE ASSIGN(99999)
FLD: QWHS DISP(0) LEN(1) OFFSET(QWHS_OFFSET)
*
***********************************************************************
* PRODUCT SECTION
* THIS SECTION CONTAINS 1 OR MORE HEADERS. EACH HEADER CONTAINS
* HEADER LENGTH, A HEADER TYPE CODE, AND VARIABLE INFORMATION
* DEPENDING UPON THE HEADER TYPE.
***********************************************************************
COMP: PSHDR_MAX_OFFSET = /* WILL POINT PAST ALL HDRS*/
WHEN(SM100RTY=100 AND SM100PSN > 0) ASSIGN(SM100PSO +SM100PSL)
ELSE ASSIGN(99999)
*
***********************************************************************
*** **
*** INSTRUMENTATION STANDARD HEADER DATA IN PRODUCT SECTION **
*** THIS HEADER IS ALWAYS PRESENT AND IS ALWAYS THE 1ST HEADER **
***********************************************************************
*
FLD: QWHSLEN LEN(2) TYPE(BIN) DISP(0) /*LENGTH OF THE STANDARD HEADER*/
FLD: QWHSTYP LEN(1) /*HEADER TYPE*/
*
* ** HEADER TYPE CONSTANTS **
COMP: QWHSHS01 = 1 /*..STANDARD HEADER*/
COMP: QWHSHC02 = 2 /*..CORRELATION HEADER*/
COMP: QWHSHT04 = 4 /*..TRACE HEADER*/
COMP: QWHSHU08 = 8 /*..CPU HEADER*/
COMP: QWHSHD16 = 16 /*..DISTRIBUTED HEADER*/
COMP: QWHSHA32 = 32 /*..DATA SHARING HEADER*/
*
FLD: QWHSRMID LEN(1) /*RESOURCE MANAGER ID*/
FLD: QWHSIID TYPE(HALF) /*IFCID*/
FLD: QWHSRELN LEN(2) /*RELEASE NUMBER AREA*/
FLD: QWHSNSDA LEN(1) TYPE(BIN) DISP(6) /*NUMBER OF SELF DEFINING AREAS*/
*
FLD: QWHSRN LEN(1) /*RELEASE INDICATOR NUMBER HEX*/
*
FLD: QWHSACE TYPE(FULL) /*ACE ADDRESS DISPATCH UNIT ADDRESS*/
FLD: QWHSSSID LEN(4) /*SUBSYSTEM NAME*/
FLD: QWHSSTCK TYPE(STCKTIME) /*STORE CLOCK VALUE OF HEADER*/
* For data sharing, this is the sysplex
* timer value.
*
* *********************************************************************
* * NOTE- THE FOLLOWING SEQUENCE NUMBERS ARE UNIQUE WITHIN A SINGLE *
* * SUBSYSTEM INSTANCE AND ARE INITIALIZED TO ZERO ON RESTART. *
* * BECAUSE OF MP CONSIDERATIONS THE NUMBERS MAY NOT ALWAYS BE *
* * IN ASCENDING ORDER. *
* *********************************************************************
*
FLD: QWHSISEQ TYPE(FULL) /*SEQUENCE NUMBER FOR IFCID*/
FLD: QWHSWSEQ TYPE(FULL) /*SEQUENCE NUMBER FOR DESTINATION*/
FLD: QWHSMTN LEN(4) /*ACTIVE TRACE NUMBER MASK*/
FLD: QWHSLOCN LEN(16) /*%U LOCAL LOCATION NAME*/
* Truncated if QWHSLOCN_Off¬=0
FLD: QWHSLWID LEN(24) /*LUWID*/
FLD: QWHSNID LEN(8) DISP(52) /*NETWORK ID*/
FLD: QWHSLUNM LEN(8) /*LUNAME*/
FLD: QWHSLUUV LEN(6) /*UNIQUENESS VALUE*/
FLD: QWHSLUCC TYPE(BIN) LEN(2) /*COMMIT COUNT*/
FLD: QWHSFLAG LEN(1) /*Flags*/
COMP: QWHS_UNICODE = X'80' /*%U fields contain Unicode (UTF 8)*/
FLD: QWHSLOCN_OFF TYPE(HALF) DISP(78) /*Offset from QWHS to*/
* LOCAL LOCATION NAME
* If QWHSLOCN truncated
FLD: QWHSSUBV TYPE(HALF) /*THE SUBVERSION FOR THE BASE RELEASE*/
FLD: QWHSSID LEN(4) /*THE MVS SYSTEM ID (SID)*/
FLD: QWHSEND LEN(1) /*END OF STANDARD HEADER*/
*
*
*
**** QWHSLOCN_D Dsect Use if QWHSLOCN_Off¬=0
COMP: QWHSLOCN_D_OFFSET =
WHEN(QWHSLOCN_Off <> 0) ASSIGN(QWHS_OFFSET + QWHSLOCN_Off)
ELSE ASSIGN(99999)
FLD: QWHSLOCN_D DISP(0) LEN(1) OFFSET(QWHSLOCN_D_OFFSET)
/*Use if QWHSLOCN_Off¬ 0*/
*
FLD: QWHSLOCN_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QWHSLOCN_VAR LEN(128) /*%U LOCAL LOCATION NAME*/
*
***THE FOLLOWING VALUES DEFINE THE IFCID IN QWHSIID **
*** RMID: DESCRIPTION: **
COMP: QWHS0000 = 0 /*..DEFAULT NORMAL TRACE RECORDS*/
COMP: QWHS0001 = 1 /*26 ..SYSTEM STATISTICS*/
COMP: QWHS0002 = 2 /*26 ..DATA BASE STATISTICS*/
COMP: QWHS0003 = 3 /*26 ..ACCOUNTING*/
*
***********************************************************************
* SOME OR ALL OF THESE HEADERS MAY NOW FOLLOW THE STD HEADER:
* QWHC DSNDQWHC * CORRELATION HEADER PRESENT ON ACCOUNTING
* QWHT DSNDQWHT * TRACE HEADER MAY APPEAR
* QWHU DSNDQWHU * CPU HEADER MAY APPEAR
* QWHD DSNDQWHD * DISTRIBUTED HEADER PRESENT ON ACCOUNTING
* QWHA DSNDQWHA * DATA SHARING HEADER
***********************************************************************
*
***********************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE NEXT HEADER SECTION PRESENT *
***********************************************************************
COMPUTE: PSHDR_2_TEST_OFFSET = QWHS_OFFSET + QWHSLEN
COMPUTE: PSHDR_2_OFFSET =
WHEN(PSHDR_2_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
ELSE ASSIGN(PSHDR_2_TEST_OFFSET)
*
FIELD: PSHDR_2_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_2_OFFSET)
FIELD: PSHDR_2_TYP LEN(1) TYPE(BIN)
*
***********************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE 3RD SECTION PRESENT *
***********************************************************************
COMPUTE: PSHDR_3_TEST_OFFSET = PSHDR_2_OFFSET + PSHDR_2_LEN
COMPUTE: PSHDR_3_OFFSET =
WHEN(PSHDR_3_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
ELSE ASSIGN(PSHDR_3_TEST_OFFSET)
*
FIELD: PSHDR_3_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_3_OFFSET)
FIELD: PSHDR_3_TYP LEN(1) TYPE(BIN)
*
***********************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE 4TH SECTION PRESENT *
***********************************************************************
COMPUTE: PSHDR_4_TEST_OFFSET = PSHDR_3_OFFSET + PSHDR_3_LEN
COMPUTE: PSHDR_4_OFFSET =
WHEN(PSHDR_4_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
ELSE ASSIGN(PSHDR_4_TEST_OFFSET)
*
FIELD: PSHDR_4_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_4_OFFSET)
FIELD: PSHDR_4_TYP LEN(1) TYPE(BIN)
*
*
***********************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE 5TH SECTION PRESENT *
***********************************************************************
COMPUTE: PSHDR_5_TEST_OFFSET = PSHDR_4_OFFSET + PSHDR_4_LEN
COMPUTE: PSHDR_5_OFFSET =
WHEN(PSHDR_5_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
ELSE ASSIGN(PSHDR_5_TEST_OFFSET)
*
FIELD: PSHDR_5_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_5_OFFSET)
FIELD: PSHDR_5_TYP LEN(1) TYPE(BIN)
*
************************************************************************
* DEFINE JUST THE LENGTH AND TYPE OF THE 6TH SECTION PRESENT *
************************************************************************
COMPUTE: PSHDR_6_TEST_OFFSET = PSHDR_5_OFFSET + PSHDR_5_LEN
COMPUTE: PSHDR_6_OFFSET =
WHEN(PSHDR_6_TEST_OFFSET >= PSHDR_MAX_OFFSET) ASSIGN(99999)
ELSE ASSIGN(PSHDR_6_TEST_OFFSET)
*
FIELD: PSHDR_6_LEN DISP(0) LEN(2) TYPE(BIN) OFFSET(PSHDR_6_OFFSET)
FIELD: PSHDR_6_TYP LEN(1) TYPE(BIN)
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR CORRELATION HEADER
***********************************************************************
COMPUTE: QWHC_OFFSET =
WHEN(PSHDR_2_TYP = QWHSHC02) ASSIGN(PSHDR_2_OFFSET)
WHEN(PSHDR_3_TYP = QWHSHC02) ASSIGN(PSHDR_3_OFFSET)
WHEN(PSHDR_4_TYP = QWHSHC02) ASSIGN(PSHDR_4_OFFSET)
WHEN(PSHDR_5_TYP = QWHSHC02) ASSIGN(PSHDR_5_OFFSET)
WHEN(PSHDR_6_TYP = QWHSHC02) ASSIGN(PSHDR_6_OFFSET)
ELSE ASSIGN(99999) /*QWHC NOT PRESENT*/
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR TRACE HEADER
***********************************************************************
COMPUTE: QWHT_OFFSET =
WHEN(PSHDR_2_TYP = QWHSHT04) ASSIGN(PSHDR_2_OFFSET)
WHEN(PSHDR_3_TYP = QWHSHT04) ASSIGN(PSHDR_3_OFFSET)
WHEN(PSHDR_4_TYP = QWHSHT04) ASSIGN(PSHDR_4_OFFSET)
WHEN(PSHDR_5_TYP = QWHSHT04) ASSIGN(PSHDR_5_OFFSET)
WHEN(PSHDR_6_TYP = QWHSHT04) ASSIGN(PSHDR_6_OFFSET)
ELSE ASSIGN(99999) /*QWHT NOT PRESENT*/
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR CPU HEADER
***********************************************************************
COMPUTE: QWHU_OFFSET =
WHEN(PSHDR_2_TYP = QWHSHU08) ASSIGN(PSHDR_2_OFFSET)
WHEN(PSHDR_3_TYP = QWHSHU08) ASSIGN(PSHDR_3_OFFSET)
WHEN(PSHDR_4_TYP = QWHSHU08) ASSIGN(PSHDR_4_OFFSET)
WHEN(PSHDR_5_TYP = QWHSHU08) ASSIGN(PSHDR_5_OFFSET)
WHEN(PSHDR_6_TYP = QWHSHU08) ASSIGN(PSHDR_6_OFFSET)
ELSE ASSIGN(99999) /*QWHU NOT PRESENT*/
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR DISTRIBUTED HEADER
***********************************************************************
COMPUTE: QWHD_OFFSET =
WHEN(PSHDR_2_TYP = QWHSHD16) ASSIGN(PSHDR_2_OFFSET)
WHEN(PSHDR_3_TYP = QWHSHD16) ASSIGN(PSHDR_3_OFFSET)
WHEN(PSHDR_4_TYP = QWHSHD16) ASSIGN(PSHDR_4_OFFSET)
WHEN(PSHDR_5_TYP = QWHSHD16) ASSIGN(PSHDR_5_OFFSET)
WHEN(PSHDR_6_TYP = QWHSHD16) ASSIGN(PSHDR_6_OFFSET)
ELSE ASSIGN(99999) /*QWHD NOT PRESENT*/
*
*
***********************************************************************
* CHOOSE OFFSET POINTER FOR DATA SHARING HEADER
***********************************************************************
COMPUTE: QWHA_OFFSET =
WHEN(PSHDR_2_TYP = QWHSHA32) ASSIGN(PSHDR_2_OFFSET)
WHEN(PSHDR_3_TYP = QWHSHA32) ASSIGN(PSHDR_3_OFFSET)
WHEN(PSHDR_4_TYP = QWHSHA32) ASSIGN(PSHDR_4_OFFSET)
WHEN(PSHDR_5_TYP = QWHSHA32) ASSIGN(PSHDR_5_OFFSET)
WHEN(PSHDR_6_TYP = QWHSHA32) ASSIGN(PSHDR_6_OFFSET)
ELSE ASSIGN(99999) /*QWHA NOT PRESENT*/
*
*
***********************************************************************
* QWHA DSNDQWHA * DATA SHARING HEADER
***********************************************************************
**** QWHA DSECT
FLD: QWHA DISP(0) LEN(1) OFFSET(QWHA_OFFSET)
*
* /**************************************/
* /*INSTRUMENTATION DATA SHARING HEADER */
* /**************************************/
*
FLD: QWHALEN LEN(2) TYPE(BIN) DISP(0) /*LENGTH OF HEADER*/
FLD: QWHATYP LEN(1) /*TYPE OF HEADER DATA SHARING*/
* /* NAME - QWHSHA32 */
FLD: QWHAMEMN LEN(8) DISP(4) /*DB2 MEMBER NAME*/
* /* WITHIN A DB2 DATA SHARING GROUP, EACH */
* /* MEMBER DB2 HAS A NAME. */
FLD: QWHADSGN LEN(8) /*DB2 DATA SHARING GROUP NAME*/
FLD: QWHAEND LEN(1)
***********************************************************************
* QWHU DSNDQWHU * CPU HEADER MAY APPEAR
***********************************************************************
**** QWHU DSECT
FLD: QWHU DISP(0) LEN(1) OFFSET(QWHU_OFFSET)
* /*INSTRUMENTATION CPU HEADER DATA */
FLD: QWHULEN LEN(2) TYPE(BIN) DISP(0) /*LENGTH OF HEADER*/
FLD: QWHUTYP LEN(1) /*TYPE OF HEADER CPU MAPPED QWHSHU08*/
FLD: QWHUCPU TYPE(STCKTIME) DISP(4)
/*CPU time of the currently dispatched*/
* /* execution unit (TCB or SRB). This */
* /* time includes CPU consumed on an IBM */
* /* specialty engine. */
* /* Note: A given ACE token may */
* /* run under one or more MVS dispatchable*/
* /* execution units. Thus the CPU time for*/
* /* a given ACE may decrease between */
* /* events. Binary zero indicates */
* /* CPU time was not available. */
FLD: QWHUCNT LEN(2) /*(S) COUNT FIELD RESERVED*/
FLD: QWHUEND LEN(1)
***********************************************************************
* QWHT DSNDQWHT * TRACE HEADER MAY APPEAR
***********************************************************************
**** QWHT DSECT
FLD: QWHT DISP(0) LEN(1) OFFSET(QWHT_OFFSET)
* /*INSTRUMENTATION TRACE HEADER DATA */
FLD: QWHTLEN LEN(2) TYPE(BIN) DISP(0) /*LENGTH OF HEADER*/
FLD: QWHTTYP LEN(1) /*TYPE OF HEADER TRACE*/
FLD: QWHTFLG0 LEN(1) /*FLAGS*/
COMP: QWHTALFG = X'20' /*ON DATA USES ALET TOKEN*/
FLD: QWHTTID TYPE(HALF) /*ID SPECIFIED DSNWTRC MACRO*/
FLD: QWHTTAG LEN(1) /*TAG SPECIFIED DSNWTRC MACRO*/
FLD: QWHTFUNC LEN(1) /*FUNC SPECIFIED DSNWTRC MACRO*/
FLD: QWHTEB TYPE(FULL) /*EB ADDRESS*/
FLD: QWHTPASI TYPE(HALF) /*PASID EPAR*/
* /*FOLLOWING FIELDS BELONG TO CALLERS MODULE WHICH INVOKED TRACE*/
FLD: QWHTR14A TYPE(HALF) /*REGISTER 14 ASID*/
FLD: QWHTR14 TYPE(FULL) /*REGISTER 14*/
FLD: QWHTR15 TYPE(FULL) /*REGISTER 15*/
FLD: QWHTR0 TYPE(FULL) /*REGISTER 0*/
FLD: QWHTR1 TYPE(FULL) /*REGISTER 1*/
FLD: QWHTEXU TYPE(FULL) /*ADDRESS OF MVS EXECUTION UNIT*/
FLD: QWHTDIM TYPE(HALF) /*NUMBER OF DATA ITEMS*/
FLD: QWHTHASI TYPE(HALF) /*HOME ASID*/
FLD: QWHTFUNCG TYPE(HALF) /*FUNC SPECIFIED DSNWTRC MACRO */
* /*THE FOLLOWING FIELDS REPEAT FOR EACH DATA ITEM */
FLD: QWHTDATA TYPE(FULL) DISP(*+2) /*ADDRESS OF THE DATA*/
FLD: QWHTFLAG TYPE(HALF) /*FLAGS IN THE TRACE LIST*/
FLD: QWHTDATL TYPE(HALF) /*LENGTH OF THE DATA*/
FLD: QWHTEND TYPE(FULL)
FLD: QWHTALET TYPE(FULL) DISP(48) /*ALET TOKEN FOR DATA FIELD*/
*
***********************************************************************
* QWHC DSNDQWHC * CORRELATION HEADER PRESENT ON ACCOUNTING
***********************************************************************
**** QWHC DSECT
FLD: QWHC DISP(0) LEN(1) OFFSET(QWHC_OFFSET)
*
*/*****************************************************************/
*/* */
*/* INSTRUMENTATION CORRELATION DATA */
*/* */
*/*****************************************************************/
*
FLD: QWHCLEN LEN(2) TYPE(BIN) DISP(0)
/*LENGTH OF THE CORRELATION HEADER*/
FLD: QWHCTYP LEN(1) /*TYPE OF HEADER CORRELATION 2*/
*
*/*****************************************************************/
*/* FOLLOWING VALUES ARE OBTAINED WHEN THE RECORD IS WRITTEN */
*/*****************************************************************/
*
FLD: QWHCAID LEN(8) DISP(4) /*%U AUTHORIZATION ID*/
* /* Truncated if QWHCAID_Off¬=0 */
FLD: QWHCCV LEN(12) /*CORRELATION ID VALUE*/
FLD: QWHCCN LEN(8) /*CONNECTION NAME (NOT VALID ON END OF MEMORY &*/
* REFLECTS THE MVS HOME ASID CONNECTION NAME) */
FLD: QWHCPLAN LEN(8) /*PLAN NAME*/
FLD: QWHCOPID LEN(8) /*%U ORIGINAL OPERATOR ID*/
* /* Truncated if QWHCOPID_Off¬=0 */
FLD: QWHCATYP TYPE(FULL) /*CONNECTING SYSTEM TYPE CODE*/
FLD: QWHCTOKN LEN(22) /*ACCOUNTING TOKEN*/
FLD: QWHCRES2 LEN(2) /*RESERVED*/
FLD: QWHCEUID LEN(16) /*THE END USER'S USERID AT THE*/
* /* USER'S WORKSTATION. */
* /* Truncated if QWHCOPID_Off¬=0 */
FLD: QWHCEUTX LEN(32) /*THE END USER'S TRANSACTION NAME.*/
FLD: QWHCEUWN LEN(18) /*THE END USER'S WORKSTATION NAME.*/
*
FLD: QWHCAID_OFF TYPE(HALF) /*Offset from QWHC to*/
* /* AUTHORIZATION ID */
* /* If QWHCAID truncated */
FLD: QWHCOPID_OFF TYPE(HALF) /*Offset from QWHC to*/
* /* ORIGINAL OPERATOR ID */
* /* If QWHCOPID truncated */
FLD: QWHCEUID_OFF TYPE(HALF) /*Offset from QWHC to*/
* /* THE END USER'S USERID */
* /* If QWHCEUID truncated */
* /* Trusted context and role data */
* /* will be present if the record */
* /* is written by an agent running */
* /* under a trusted context and */
* /* the trusted context data can */
* /* be accessed. */
FLD: QWHCTCXT_OFF TYPE(HALF) /*Offset from QWHC to*/
* /* Trusted Context name, if */
* /* running in a trusted context */
FLD: QWHCROLE_OFF TYPE(HALF) /*Offset from QWHC to*/
* /* Role name associated with the */
* /* Authorization ID, if running */
* /* in a trusted context */
FLD: QWHCOAUD_OFF TYPE(HALF) /*Offset from QWHC to original*/
* /* application USERID */
FLD: QWHCCTKN_OFF TYPE(HALF) /*Offset from QWHC to*/
* /* the correlation token. */
* /* V9-Present only if QWHSSUBV */
* /* is 1 or higher. */
FLD: QWHCEND TYPE(FULL)
*
*
**** QWHCAID_D Dsect /* Use if QWHCAID_Off¬=0
COMP: QWHCAID_D_OFFSET =
WHEN(QWHCAID_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCAID_Off)
ELSE ASSIGN(99999)
FLD: QWHCAID_D DISP(0) LEN(1) OFFSET(QWHCAID_D_OFFSET)
/*Use if QWHCAID_Off¬ 0*/
FLD: QWHCAID_LEN TYPE(HALF) DISP(0)/*Length of the following field*/
FLD: QWHCAID_VAR LEN(128) /*%U AUTHORIZATION ID*/
*
*
**** QWHCOPID_D Dsect /* Use if QWHCOPID_Off¬=0
COMP: QWHCOPID_D_OFFSET =
WHEN(QWHCOPID_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCOPID_Off)
ELSE ASSIGN(99999)
FLD: QWHCOPID_D DISP(0) LEN(1) OFFSET(QWHCOPID_D_OFFSET)
/*Use if QWHCOPID_Off¬ 0*/
FLD: QWHCOPID_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QWHCOPID_VAR LEN(128) /*%U ORIGINAL OPERATOR ID*/
*
*
**** QWHCEUID_D Dsect /* Use if QWHCEUID_Off¬=0
COMP: QWHCEUID_D_OFFSET =
WHEN(QWHCEUID_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCEUID_Off)
ELSE ASSIGN(99999)
FLD: QWHCEUID_D DISP(0) LEN(1) OFFSET(QWHCEUID_D_OFFSET)
/*Use if QWHCEUID_Off¬ 0*/
FLD: QWHCEUID_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QWHCEUID_VAR LEN(128) /*END USER'S USERID*/
*
*
**** QWHCTCXT_D Dsect /* Use if QWHCTCXT_Off¬=0
COMP: QWHCTCXT_D_OFFSET =
WHEN(QWHCTCXT_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCTCXT_Off)
ELSE ASSIGN(99999)
FLD: QWHCTCXT_D DISP(0) LEN(1) OFFSET(QWHCTCXT_D_OFFSET)
/*Use if QWHCTCXT_Off¬ 0*/
FLD: QWHCTCXT_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QWHCTCXT_VAR LEN(128) /*%U Trusted Context name*/
*
*
**** QWHCROLE_D Dsect /* Use if QWHCROLE_Off¬=0
COMP: QWHCROLE_D_OFFSET =
WHEN(QWHCROLE_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCROLE_Off)
ELSE ASSIGN(99999)
FLD: QWHCROLE_D DISP(0) LEN(1) OFFSET(QWHCROLE_D_OFFSET)
/*Use if QWHCROLE_Off¬ 0*/
FLD: QWHCROLE_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QWHCROLE_VAR LEN(128) /*%U Role name associated with*/
* /* authid */
*
*
**** QWHCOAUD_D Dsect /* Use if QWHCOAUD_Off¬=0
COMP: QWHCOAUD_D_OFFSET =
WHEN(QWHCOAUD_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCOAUD_Off)
ELSE ASSIGN(99999)
FLD: QWHCOAUD_D DISP(0) LEN(1) OFFSET(QWHCOAUD_D_OFFSET)
/*Use if QWHCOAUD_Off¬ 0*/
FLD: QWHCOAUD_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QWHCOAUD_VAR LEN(128) /*%U Original application USERID*/
*
*
**** QWHCCTKN_D Dsect /* Use if QWHCCTKN_Off¬=0
COMP: QWHCCTKN_D_OFFSET =
WHEN(QWHCCTKN_Off <> 0) ASSIGN(QWHC_OFFSET + QWHCCTKN_Off)
ELSE ASSIGN(99999)
FLD: QWHCCTKN_D DISP(0) LEN(1) OFFSET(QWHCCTKN_D_OFFSET)
/*Use if QWHCCTKN_Off¬ 0*/
FLD: QWHCCTKN_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QWHCCTKN_VAR LEN(128) /*%U Correlation token.*/
*
*
*/*****************************************************************/
*/* CONNECTION SYSTEM TYPE CONSTANTS */
*/*****************************************************************/
*
COMP: QWHCTSO = X'1' /*TSO FOREGROUND AND BACKGROUND*/
COMP: QWHCDB2C = X'2' /*DB2 CALL ATTACH*/
COMP: QWHCDLIB = X'3' /*DL/I BATCH*/
COMP: QWHCCICS = X'4' /*CICS ATTACH*/
COMP: QWHCIMSB = X'5' /*IMS ATTACH BMP*/
COMP: QWHCIMSM = X'6' /*IMS ATTACH MPP*/
COMP: QWHCDUW = X'7' /*DB2 PRIVATE PROTOCOL*/
COMP: QWHCRUW = X'8' /*DRDA PROTOCOL*/
COMP: QWHCICTL = X'9' /*IMS CONTROL REGION*/
COMP: QWHCTBMP = X'A' /*IMS TRANSACTION BMP*/
COMP: QWHCUTIL = X'B' /*DB2 UTILITIES*/
COMP: QWHCTRRS = X'C' /*RRSAF ATTACH*/
***********************************************************************
* QWHD DSNDQWHD * DISTRIBUTED HEADER PRESENT ON ACCOUNTING
***********************************************************************
**** QWHD DSECT
FLD: QWHD DISP(0) LEN(1) OFFSET(QWHD_OFFSET)
*
*/********************************************************************/
*/* INSTRUMENTATION DISTRIBUTED DATA */
*/********************************************************************/
*
FLD: QWHDLEN LEN(2) TYPE(BIN) DISP(0)
/*LENGTH OF THE DISTRIBUTED HEADER*/
FLD: QWHDTYP LEN(1) /*TYPE OF HEADER DISTRIBUTED 16*/
*
*/********************************************************************/
*/* THE FOLLOWING VALUES ARE OBTAINED WHEN THE RECORD IS WRITTEN */
*/********************************************************************/
*
FLD: QWHDRQNM LEN(16) DISP(4)
/*%U REQUESTER LOCATION NAME BLANK IF HEADER*/
* IS WRITTEN AT APPLICATION REQUESTER SITE
* THE NAME BY WHICH DB2 KNOWS THE APPLI-
* REQUESTER
* Truncated if QWHDRQNM_Off¬=0
FLD: QWHDTSTP LEN(8) /*TIMESTAMP FOR DBAT TRACE RECORDS*/
FLD: QWHDSVNM LEN(16) /*%U SRVNAM PARAMETER OF DRDA EXCSAT COMMAND*/
* WHAT A DRDA REQUESTER CALLS ITSELF.
* FOR PRIVATE PROTOCOLS SAME AS QWHDRQNM.
* ZEROES IF HEADER IS WRITTEN AT
* APPLICATION REQUESTER SITE.
* Truncated if QWHDSVNM_Off¬=0
FLD: QWHDPRID LEN(8) /*PRDID PARAMETER OF DRDA ACCRDB COMMAND*/
* PRODUCT ID OF APPLICATION REQUESTER.
* FOR PRIVATE PROTOCOLS THIS FIELD WILL
* BE SET TO AN APPROPRIATE PRODUCT ID VALUE
* ZEROES IF HEADER IS WRITTEN AT APPLICA-
* TION REQUESTER SITE.
FLD: QWHDRQNM_OFF TYPE(HALF) /*Offset from QWHD to*/
* REQUESTER LOCATION NAME
* If QWHDRQNM truncated
FLD: QWHDSVNM_OFF TYPE(HALF) /*Offset from QWHD*/
* SRVNAM PARAMETER OF DRDA EXCSAT COMMAND
* If QWHDSVNM truncated
FLD: QWHDEND TYPE(FULL)
*
*
*
**** QWHDRQNM_D Dsect Use if QWHDRQNM_Off¬=0
COMP: QWHDRQNM_D_OFFSET =
WHEN(QWHDRQNM_Off <> 0) ASSIGN(QWHD_OFFSET + QWHDRQNM_Off)
ELSE ASSIGN(99999)
FLD: QWHDRQNM_D DISP(0) LEN(1) OFFSET(QWHDRQNM_D_OFFSET)
FLD: QWHDRQNM_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QWHDRQNM_VAR LEN(128) /*%U REQUESTER LOCATION NAME*/
*
*
*
**** QWHDSVNM_D Dsect Use if QWHDSVNM_Off¬=0
COMP: QWHDSVNM_D_OFFSET =
WHEN(QWHDSVNM_Off <> 0) ASSIGN(QWHD_OFFSET + QWHDSVNM_Off)
ELSE ASSIGN(99999)
FLD: QWHDSVNM_D DISP(0) LEN(1) OFFSET(QWHDSVNM_D_OFFSET)
FLD: QWHDSVNM_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QWHDSVNM_VAR LEN(128)
/*%U SRVNAM PARAMETER OF DRDA EXCSAT COMMAND*/
***********************************************************************
* *
* SMF 100 RECORD SUBTYPE 0 (IFCID 1) FOLLOWS *
* *
***********************************************************************
***********************************************************************
* DB2 DSNDQWST SUBTYPE=0 STATISTICS RECORD SECTION MAPPING FPR *
* SYSTEM SERVICES STATISTICS. THE RECORD IS WRITTEN TO SMF AS A SMF *
* TYPE 100 RECORD. *
*(SEE SYSTEM PLANNING AND ADMINISTRATION GUIDE FOR ADDITIONAL DETAIL) *
***********************************************************************
* DSECT MACRO * DESCRIPTION OF SECTIONS IN RECORD *
* *
* NOTE: FIELDS DEFINED AS CHARACTER MAY CONTAIN HEX DATA *
*-------------------------------------------------------------------- *
* SM100 DSNDQWST * SMF HEADER SECTION *
*---------------------------------------------------------------------*
* * IFCID 0001 FOLLOWS
* *
* QWS0 DSNDQWS0 * SELF DEFINING SECTION - NOTE: USE OFFSETS
* * IN QWS0 TO GET TO THE FOLLOWING SECTIONS
*----------------------* BECAUSE THEIR EXACT POSITION VARIES
* *
* * See DSNDQWS0 for parsing algorithm for
* * varying length repeating group section(s):
* * QLST
* *
* *FOLLOWING SECTIONS BEGIN ON A WORD BOUNDARY
* * PRODUCT SECTION. THE SECTION
* * NORMALLY APPEARS AT THE END OF RECORD
* QWHS DSNDQWHS * STANDARD HEADER ALWAYS APPEARS
* QWHC DSNDQWHC * CORRELATION HEADER MAY APPEAR
* QWHT DSNDQWHT * TRACE HEADER MAY APPEAR
* QWHU DSNDQWHU * CPU HEADER MAY APPEAR
* QWHD DSNDQWHD * DISTRIBUTED HEADER MAY APPEAR
* QWHA DSNDQWHA * DATA SHARING HEADER
* QWSA DSNDQWSA * CONTROL ADDRESS SPACES STATISTICS
* QWSB DSNDQWSB * IFC DESTINATION STATISTICS
* QWSC DSNDQWSC * IFCID STATISTICAL INFORMATION
* Q3ST DSNDQ3ST * SUBSYSTEM SUPORT STATISTICS
* Q9ST DSNDQ9ST * COMMAND STATISTICS
* QWSD DSNDQWSD * IFC CHECKPOINT INFORMATION - RELEASE 2
* QVLS DSNDQVLS * LATCH STATISTICS
* QVAS DSNDQVAS * AGENT SERVICES STATISTICS
* QSST DSNDQSST * STORAGE MANAGER STATISTICS
* QLST DSNDQLST * DDF STATISTICS - V2R2
* QJST DSNDQJST * LOG MANAGER STATISTICS
* QDST DSNDQDST * DDF SYSTEM STATISTICS
* QWOS DSNDQWOS * ZOS SYSTEM STATISTICS
************************
***********************************************************************
**** QWS0 DSECT
***********************************************************************
COMP: QWS0_OFFSET =
WHEN(SM100RTY=100 AND QWHSIID = 1) ASSIGN(28)
ELSE ASSIGN(99999)
FLD: QWS0 DISP(0) LEN(1) OFFSET(QWS0_OFFSET)
* DB2 SELF DEFINING SECTION MACRO FOR SYSTEM STATISTICS (IFCID=0001)
*
* PRODUCT SECTION FOR SYSTEM STATISTICS CONTAINS THE
* STANDARD HEADER MAPPED BY DSNDQWHS
FLD: QWS00PSO LEN(4) TYPE(BIN) DISP(0)
/*OFFSET TO THE PRODUCT SECTION*/
FLD: QWS00PSL LEN(2) TYPE(BIN) DISP(4)
/*LENGTH OF THE PRODUCT SECTION*/
FLD: QWS00PSN LEN(2) TYPE(BIN) DISP(6) /*NUMBER OF PRODUCT SECTIONS*/
* FOR RMID 026 MAPPED BY DSNDQWSA
FLD: QWS00R1O LEN(4) TYPE(BIN) DISP(8) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R1L LEN(2) TYPE(BIN) DISP(12) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R1N LEN(2) TYPE(BIN) DISP(14) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 026 MAPPED BY DSNDQWSB
FLD: QWS00R2O LEN(4) TYPE(BIN) DISP(16) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R2L LEN(2) TYPE(BIN) DISP(20) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R2N LEN(2) TYPE(BIN) DISP(22) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 026 MAPPED BY DSNDQWSC
FLD: QWS00R3O LEN(4) TYPE(BIN) DISP(24) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R3L LEN(2) TYPE(BIN) DISP(28) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R3N LEN(2) TYPE(BIN) DISP(30) /*NUMBER OF DATA SECTIONS*/
* FOR RMID MAPPED BY DSNDQ3ST SSSC
FLD: QWS00R4O LEN(4) TYPE(BIN) DISP(32) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R4L LEN(2) TYPE(BIN) DISP(36) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R4N LEN(2) TYPE(BIN) DISP(38) /*NUMBER OF DATA SECTIONS*/
* FOR RMID MAPPED BY DSNDQ9ST COMMAND PROCESSING
FLD: QWS00R5O LEN(4) TYPE(BIN) DISP(40) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R5L LEN(2) TYPE(BIN) DISP(44) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R5N LEN(2) TYPE(BIN) DISP(46) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 26 MAPPED BY DSNDQWSD - CHECKPOINT INFO - NEW RELEASE 2
FLD: QWS00R6O LEN(4) TYPE(BIN) DISP(48) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R6L LEN(2) TYPE(BIN) DISP(52) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R6N LEN(2) TYPE(BIN) DISP(54) /*NUMBER OF DATA SECTIONS*/
* FOR RMID MAPPED BY DSNDQVLS LATCH MANAGER
FLD: QWS00R7O LEN(4) TYPE(BIN) DISP(56) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R7L LEN(2) TYPE(BIN) DISP(60) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R7N LEN(2) TYPE(BIN) DISP(62) /*NUMBER OF DATA SECTIONS*/
* FOR RMID MAPPED BY DSNDQVAS ASMC
FLD: QWS00R8O LEN(4) TYPE(BIN) DISP(64) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R8L LEN(2) TYPE(BIN) DISP(68) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R8N LEN(2) TYPE(BIN) DISP(70) /*NUMBER OF DATA SECTIONS*/
* FOR RMID MAPPED BY DSNDQSST STORAGE MANAGER
FLD: QWS00R9O LEN(4) TYPE(BIN) DISP(72) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00R9L LEN(2) TYPE(BIN) DISP(76) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00R9N LEN(2) TYPE(BIN) DISP(78) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 16 MAPPED BY DSNDQWTR TRACE - DELETED IN RELEASE 2
* DDF - CHANGE
* FOR RMID MAPPED BY DSNDQLST DDF - V2R2
FLD: QWS00RAO LEN(4) TYPE(BIN) DISP(80) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00RAL LEN(2) TYPE(BIN) DISP(84) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00RAN LEN(2) TYPE(BIN) DISP(86) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 004 MAPPED BY DSNDQJST LOG MANAGER
FLD: QWS00RBO LEN(4) TYPE(BIN) DISP(88) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00RBL LEN(2) TYPE(BIN) DISP(92) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00RBN LEN(2) TYPE(BIN) DISP(94) /*NUMBER OF DATA SECTIONS*/
* FOR RMID MAPPED BY DSNDQDST DDF SYSTEM STATISTICS
FLD: QWS00RCO LEN(4) TYPE(BIN) DISP(96) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00RCL LEN(2) TYPE(BIN) DISP(100) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00RCN LEN(2) TYPE(BIN) DISP(102) /*NUMBER OF DATA SECTIONS*/
* FOR RMID MAPPED BY DSNDQWOS ZOS SYSTEM STATISTICS
FLD: QWS00RDO LEN(4) TYPE(BIN) DISP(104) /*OFFSET TO THE DATA SECTION*/
FLD: QWS00RDL LEN(2) TYPE(BIN) DISP(108) /*LENGTH OF THE DATA SECTION*/
FLD: QWS00RDN LEN(2) TYPE(BIN) DISP(110) /*NUMBER OF DATA SECTIONS*/
FLD: QWS00END LEN(1) DISP(112) /*END OF THE SELF DEFINING SECTION*/
*
***********************************************************************
* DB2 DSNDQWST SUBTYPE=1 STATISTICS RECORD SECTION MAPPING FOR *
* DATA BASE SERVICES STATISTICS. THE RECORD IS WRITTEN TO SMF AS *
* A TYPE 100 RECORD. *
*(SEE SYSTEM PLANNING AND ADMINISTRATION GUIDE FOR ADDITIONAL DETAIL) *
***********************************************************************
* DSECT MACRO * DESCRIPTION OF SECTIONS IN RECORD *
*---------------------------------------------------------------------*
* SM100 DSNDQWST * SMF HEADER SECTION *
*
* NOTE: FIELDS DEFINED AS CHARACTER MAY CONTAIN HEX DATA
*---------------------------------------------------------------------*
* * IFCID 0002 FOLLOWS
* QWS1 DSNDQWS1 * SELF DEFINING SECTION - NOTE: USE OFFSETS
* * IN QWS1 TO GET TO THE FOLLOWING SECTIONS
*----------------------* BECAUSE THEIR EXACT POSITION VARIES
* *FOLLOWING SECTIONS BEGIN ON A WORD BOUNDARY
* * PRODUCT SECTION. THE SECTION
* * NORMALLY APPEARS AT THE END OF RECORD
* QWHS DSNDQWHS * STANDARD HEADER ALWAYS APPEARS
* QWHC DSNDQWHC * CORRELATION HEADER MAY APPEAR
* QWHT DSNDQWHT * TRACE HEADER MAY APPEAR
* QWHU DSNDQWHU * CPU HEADER MAY APPEAR
* QWHD DSNDQWHD * DISTRIBUTED HEADER MAY APPEAR
* QWHA DSNDQWHA * DATA SHARING HEADER
* QXST DSNDQXST * SQL STATISTICS
* QTST DSNDQTST * SERVICE CONTROLLER STATISTICS
* QBST DSNDQBST * BUFFER MANAGER STATISTICS
* QIST DSNDQIST * DATA MANAGER STATISTICS - V2R2
* QTXA DSNDQTXA * LOCKING STATISTICS
* QISE DSNDQISE * EDM POOL STATISTICS - RELEASE 2
* QBGL DSNDQBGL * Buffer Manager Data Sharing Stats - V4R1
* QTGS DSNDQTGS * Service Controller Data Sharing Stats - V4R1
* QLES DSNDQLES * LE STATISTICS
* QISJ DSNDQISJ * STARJOIN POOL STATISTICS (S)
************************
***********************************************************************
**** QWS1 DSECT
***********************************************************************
COMP: QWS1_OFFSET =
WHEN(SM100RTY=100 AND QWHSIID = 2) ASSIGN(28)
ELSE ASSIGN(99999)
FLD: QWS1 DISP(0) LEN(1) OFFSET(QWS1_OFFSET)
* DB2 SELF DEFINING SECTION MACRO FOR DATA BASE STATISTICS IFCID=0002
*
* PRODUCT SECTION FOR DATA BASE STATISTICS CONTAINS THE
* STANDARD HEADER MAPPED BY DSNDQWHS
FLD: QWS10PSO LEN(4) TYPE(BIN) DISP(0)
/*OFFSET TO THE PRODUCT SECTION*/
FLD: QWS10PSL LEN(2) TYPE(BIN) DISP(4)
/*LENGTH OF THE PRODUCT SECTION*/
FLD: QWS10PSN LEN(2) TYPE(BIN) DISP(6) /*NUMBER OF PRODUCT SECTIONS*/
* FOR RMID 22 MAPPED BY DSNDQXST SQL
FLD: QWS10R1O LEN(4) TYPE(BIN) DISP(8) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R1L LEN(2) TYPE(BIN) DISP(12) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R1N LEN(2) TYPE(BIN) DISP(14) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 20 MAPPED BY DSNDQTST SERVICE CONTROLLER
FLD: QWS10R2O LEN(4) TYPE(BIN) DISP(16) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R2L LEN(2) TYPE(BIN) DISP(20) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R2N LEN(2) TYPE(BIN) DISP(22) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 10 MAPPED BY DSNDQBST BUFFER MANAGER
FLD: QWS10R3O LEN(4) TYPE(BIN) DISP(24) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R3L LEN(2) TYPE(BIN) DISP(28) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R3N LEN(2) TYPE(BIN) DISP(30) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 14 MAPPED BY DSNDQIST DATA MANAGER
FLD: QWS10R4O LEN(4) TYPE(BIN) DISP(32) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R4L LEN(2) TYPE(BIN) DISP(36) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R4N LEN(2) TYPE(BIN) DISP(38) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 20 MAPPED BY DSNDQTXA ** LOCK MANAGER
FLD: QWS10R5O LEN(4) TYPE(BIN) DISP(40) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R5L LEN(2) TYPE(BIN) DISP(44) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R5N LEN(2) TYPE(BIN) DISP(46) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 14 MAPPED BY DSNDQISE EDM POOL STATISTICS
FLD: QWS10R6O LEN(4) TYPE(BIN) DISP(48) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R6L LEN(2) TYPE(BIN) DISP(52) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R6N LEN(2) TYPE(BIN) DISP(54) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 10 MAPPED BY DSNDQBGL GROUP BUFFER POOL STATISTICS
FLD: QWS10R7O LEN(4) TYPE(BIN) DISP(56) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R7L LEN(2) TYPE(BIN) DISP(60) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R7N LEN(2) TYPE(BIN) DISP(62) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 20 MAPPED BY DSNDQTGS GLOBAL LOCKING STATISTICS
FLD: QWS10R8O LEN(4) TYPE(BIN) DISP(64) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R8L LEN(2) TYPE(BIN) DISP(68) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R8N LEN(2) TYPE(BIN) DISP(70) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 22 MAPPED BY DSNDQLES LE ACCESS FROM ADMF STATISTICS
FLD: QWS10R9O LEN(4) TYPE(BIN) DISP(72) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10R9L LEN(2) TYPE(BIN) DISP(76) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10R9N LEN(2) TYPE(BIN) DISP(78) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 22 MAPPED BY DSNDQISJ STARJOIN POOL STATISTICS
FLD: QWS10RAO LEN(4) TYPE(BIN) DISP(80) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10RAL LEN(2) TYPE(BIN) DISP(84) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10RAN LEN(2) TYPE(BIN) DISP(86) /*NUMBER OF DATA SECTIONS*/
* FOR RMID 033 MAPPED BY DSNDQ8ST ACCEL SVCS SYSTEM STATISTICS
FLD: QWS10RBO LEN(4) TYPE(BIN) DISP(88) /*OFFSET TO THE DATA SECTION*/
FLD: QWS10RBL LEN(2) TYPE(BIN) DISP(92) /*LENGTH OF THE DATA SECTION*/
FLD: QWS10RBN LEN(2) TYPE(BIN) DISP(94) /*NUMBER OF DATA SECTIONS **/
FLD: QWS10END LEN(1) DISP(96) /*END OF THE SELF DEFINING SECTION*/
*******************************************************************
* QWSA DSNDQWSA * CONTROL ADDRESS SPACES STATISTICS
*******************************************************************
***********************************************************************
**** QWSA DSECT
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QWSA, USE:
* INPUT: SMF100
* NORMWHEN(SM100RTY=100)
* NORMSMF(QWS00R1O)
***********************************************************************
COMP: QWSA_OFFSET =
WHEN(SM100RTY=100 AND QWS00R1N > 0) ASSIGN(QWS00R1O)
ELSE ASSIGN(99999)
FLD: QWSA DISP(0) LEN(1) OFFSET(QWSA_OFFSET)
* INSTRUMENTATION STATISTICS DATA OF CPU TIMER VALUES FOR EACH
* RESOURCE MANAGER & CONTROL ADDRESS SPACE.
*
* NOTE: FIELDS DEFINED AS CHARACTER MAY CONTAIN HEX DATA
*
FLD: QWSAPROC LEN(4) DISP(0)
/*LAST FOUR CHARACTERS OF THE PROCEDURE NAME USED TO*/
* START THE ADDRESS SPACE - OR A CONSTANT IDENTIFIER
FLD: QWSAEJST TYPE(STCKTIME) DISP(4)
/*JOB STEP TIMER VALUE FOR ADDRESS SPACE*/
FLD: QWSASRBT TYPE(STCKTIME) DISP(12)
/*SRB TIMER VALUE FOR ADDRESS SPACE*/
* NOT INCLUDING CPU CONSUMED ON AN IBM ZIIP
FLD: QWSAASID TYPE(HALF) DISP(20) /*ASID OF THE ADDRESS SPACE*/
FLD: QWSAASCB LEN(4) TYPE(BIN) DISP(24) /*ASCB TOKEN*/
FLD: QWSAPSRB TYPE(STCKTIME) DISP(28)
/*PREEMPTABLE SRB TIMER VALUE FOR ADDRESS SPACE*/
* NOT INCLUDING CPU CONSUMED ON AN IBM ZIIP
FLD: QWSAPSRB_ZIIP TYPE(STCKTIME) DISP(36)
/*PREEMPTABLE SRB TIMER VALUE CONSUMED ON AN*/
* IBM zIIP FOR ADDRESS SPACE
FLD: QWSAEND LEN(1) DISP(44)
*******************************************************************
* QWSB DSNDQWSB * IFC DESTINATION STATISTICS
*******************************************************************
***********************************************************************
**** QWSB DSECT
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QWSB, USE:
* INPUT: SMF100
* NORMWHEN(SM100RTY=100)
* NORMSMF(QWS00R2O)
***********************************************************************
COMP: QWSB_OFFSET =
WHEN(SM100RTY=100 AND QWS00R2N > 0) ASSIGN(QWS00R2O)
ELSE ASSIGN(99999)
FLD: QWSB DISP(0) LEN(1) OFFSET(QWSB_OFFSET)
* /*INSTRUMENTATION STATISTICS DATA ON DESTINATION.
* */
FLD: QWSBNM LEN(4) DISP(0)
/*NAME OF THE EXTERNAL OR INTERNAL DESTINATION*/
* FOLLOWING ARE EXAMPLES OF DESTINATION VALUES:
* GTF, SMF
* RES = RESIDENT TRACE TABLE
* SRV = SERVICEABILITY
* SR1 = INTERNAL SPECIAL ACCOUNTING DESTINATION
* USED TO CALCULATE OPTIONAL DELTA TIMINGS*/
* SR2 = INTERNAL SPECIAL DESTINATION FOR IFI READS
* USED TO RETURN DATA TO THE APPLICATION */
*** OPN = SPECIAL DESTINATION FOR IFI READA BUFFERE
* RECORDS */
* /* STATISTICS UPDATED WITH COMPARE & SWAP (+=YES,-=NO) */
FLD: QWSBSTAT LEN(4) TYPE(BIN) DISP(4) /*STATISTIC COUNTERS*/
FLD: QWSBWSEQ LEN(4) TYPE(BIN) DISP(4) /*+UNIQUE SEQUENCE NUMBER*/
FLD: QWSBSRSW LEN(4) TYPE(BIN) DISP(8) /*+RECORDS WRITTEN*/
FLD: QWSBSRNW LEN(4) TYPE(BIN) DISP(12) /*+RECORDS NOT WRITTEN*/
*
* THE FOLLOWING REASONS FOR FAILURE
* ARE GENERIC CATEGORIES. ERRORS CAN OCCUR
* BECAUSE THE EXTERNAL WRITER HAS A PROBLEM
* (SMF AND GTF).
* RECORDS CAN ALSO FAIL TO BE PROCESSED BY
* INTERNAL WRITERS (SR1, SR2, SRV, OPN, RES).
*
* ONLY EXTERNAL WRITER ERROR CATEGORIES
* ARE COMMENTED BELOW.
*
* INTERNAL WRITER ERRORS
* NORMALLY ARE CAUSED BECAUSE ASYNCHONOUS
* TRACE EVENTS OCCUR AND THE WRITER CANNOT
* PROCESS THE REQUEST. INTERNAL WRITER ERRORS
* ARE NOT A PROBLEM TO (SRV, SR1, RES,AND SR2)
* INTERNAL ERRORS TO OPN USUALLY INDICATE
* AN APPLICATION PROGRAM IS NOT PROCESSING
* RECORDS BEFORE THE BUFFER FILLS OR A OPX
* DESTINATION TRACE IS ACTIVE AND AN
* APPLICATION PROGRAM DOES NOT EXIST TO PROCES
* PROCESS THE RECORDS.
FLD: QWSBSBUF TYPE(HALF) DISP(16) /*BUFFER ERRORS*/
FLD: QWSBSACT TYPE(HALF) DISP(18) /*NOT ACTIVE ERRORS*/
FLD: QWSBSRNA TYPE(HALF) DISP(20) /*RECORD NOT ACCEPTED*/
FLD: QWSBSWF TYPE(HALF) DISP(22) /*WRITER FAILURES*/
FLD: QWSBOTH LEN(4) TYPE(BIN) DISP(24) /*(S)*/
FLD: QWSBOTH1 LEN(1) DISP(24) /*(S)*/
FLD: QWSBOTH2 LEN(1) DISP(25) /*(S)*/
FLD: QWSBOTH3 LEN(1) DISP(26) /*(S)*/
FLD: QWSBOTH4 LEN(1) DISP(27) /*(S)*/
FLD: QWSBEND LEN(1) DISP(28)
*
*
*******************************************************************
* QWSC DSNDQWSC * IFCID STATISTICAL INFORMATION
*******************************************************************
***********************************************************************
**** QWSC DSECT
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QWSC, USE:
* INPUT: SMF100
* NORMWHEN(SM100RTY=100)
* NORMSMF(QWS00R3O)
***********************************************************************
COMP: QWSC_OFFSET =
WHEN(SM100RTY=100 AND QWS00R3N > 0) ASSIGN(QWS00R3O)
ELSE ASSIGN(99999)
FLD: QWSC DISP(0) LEN(1) OFFSET(QWSC_OFFSET)
*
*................................................................
* IFCIDS RECORDED TO STATISTICS AS OF 08/31/91
* IFCIDS EQU MAPPED BY DSNDQWHS
*
* 0001 SYSTEM RELATED STATISTICS
* 0002 DATA BASE RELATED STATISTICS
* 0003 ACCOUNTING
* 0004 START TRACE RECORDS
* 0005 STOP TRACE RECORDS
* 0106 DSNZPARM RECORDS
* 0140-0146 AUDIT RECORDS
* 0202 DYNAMIC DSNZPARM RECORDS
*................................................................
* STATISTICS UPDATED USING COMPARE & SWAP (+=YES, -=NO)
FLD: QWSCIID TYPE(HALF) DISP(0) /*IFCID*/
FLD: QWSCSTAT LEN(4) TYPE(BIN) DISP(4) /*STATISTICS*/
FLD: QWSCISEQ LEN(4) TYPE(BIN) DISP(4) /*+IFCID SEQUENCE NUMBER*/
*
* THE FOLLWING COUNTS ARE UPDATED BY THE TRACE
* WRITER. IF A IFCID IS ACTIVE TO MULTIPLE TRACES
* DESTINATIONS, THEN THE RECORD COUNTS BELOW
* MAY BE GREATER THAN THE IFCID SEQUENCE NUMBER (QWSCISEQ)
*
FLD: QWSCSRSW LEN(4) TYPE(BIN) DISP(8) /*+RECORDS WRITTEN*/
FLD: QWSCSRNW LEN(4) TYPE(BIN) DISP(12) /*+RECORDS NOT WRITTEN*/
FLD: QWSCSRND TYPE(HALF) DISP(16) /*RECORD NOT DESIRED*/
* INSTALATION TURNED OFF, SEVERE ERROR
FLD: QWSCSBNA TYPE(HALF) DISP(18) /*BUFFER NOT AVAILABLE*/
FLD: QWSCSCF TYPE(HALF) DISP(20) /*COLLECTION FAILURE*/
* ABEND DURING COLLECTION, ERROR RETURN INFORMATION
FLD: QWSCOTH1 LEN(1) DISP(22) /*(S)*/
FLD: QWSCOTH2 LEN(1) DISP(23) /*(S)*/
FLD: QWSCEND LEN(1) DISP(24)
*/********************************************************************/
*/* */
*/* SSSC (SSSS AND SSAM) STATISTICS BLOCK (Q3ST) - 13MAY81 */
*/* */
*/********************************************************************/
*/* */
*/* - FUNCTION: */
*/* THE Q3ST IS A BLOCK USED FOR ACCUMULATING STATISTICS FOR */
*/* SSSS AND SSAM RESOURCE MANAGERS */
*/* */
*/* - CREATED BY: DSN3SSIN */
*/* - DELETED BY: DSN3SSTM - WHEN THE POOL (SSGSCPHB) IS */
*/* FREED AT SUBSYSTEM TERMINATION. */
*/* - STORAGE TYPE: CLASS 2 (POOL WHOSE PHB IS POINTED */
*/* TO BY SSGSCPHB). */
*/* - POINTED TO BY: SSGSQ3ST */
*/* AMGSQ3ST */
*/* - NUMBER: 1 */
*/* - DURATION: UNTIL SSSS TERMINATION */
*/* - METHOD OF ACCESS: PL/S - %INCLUDE (COMPLETE BLOCK IS ALWAYS */
*/* GENERATED) */
*/* BAL - DSNDQ3ST MACRO ('HEADER' AREA NEVER */
*/* GENERATED - ONLY THE STATISTICS */
*/* DATA PORTION IS GENERATED) */
*/* */
*/********************************************************************/
*/*
*******************************************************************
* Q3ST DSNDQ3ST * SUBSYSTEM SUPORT STATISTICS
*******************************************************************
***********************************************************************
**** Q3ST DSECT
***********************************************************************
COMP: Q3ST_OFFSET =
WHEN(SM100RTY=100 AND QWS00R4N > 0) ASSIGN(QWS00R4O)
ELSE ASSIGN(99999)
FLD: Q3ST DISP(0) LEN(1) OFFSET(Q3ST_OFFSET)
FLD: Q3STDATA LEN(4) TYPE(BIN) DISP(0) /*DATA PORTION OF Q3ST*/
FLD: Q3STIDEN LEN(4) TYPE(BIN) DISP(0) /*SUCCESSFUL DSN3IDEN REQUESTS*/
FLD: Q3STSIGN LEN(4) TYPE(BIN) DISP(4) /*SUCCESSFUL DSN3SIGN REQUESTS*/
FLD: Q3STCTHD LEN(4) TYPE(BIN) DISP(8) /*SUCCESSFUL DSN3CTHD REQUESTS*/
FLD: Q3STTERM LEN(4) TYPE(BIN) DISP(12)
/*SUCCESSFUL DSN3TERM REQUESTS*/
FLD: Q3STRIUR LEN(4) TYPE(BIN) DISP(16)
/*SUCCESSFUL DSN3RIUR REQUESTS*/
FLD: Q3STPREP LEN(4) TYPE(BIN) DISP(20)
/*SUCCESSFUL DSN3PREP REQUESTS*/
FLD: Q3STCOMM LEN(4) TYPE(BIN) DISP(24)
/*SUCCESSFUL DSN3COMM REQUESTS*/
FLD: Q3STABRT LEN(4) TYPE(BIN) DISP(28)
/*SUCCESSFUL DSN3ABRT REQUESTS*/
FLD: Q3STSYNC LEN(4) TYPE(BIN) DISP(32)
/*SUCCESSFUL DSN3SYNC REQUESTS*/
FLD: Q3STEXIT LEN(4) TYPE(BIN) DISP(36)
/*SUCCESSFUL DSN3EXIT REQUESTS*/
FLD: Q3STINDT LEN(4) TYPE(BIN) DISP(40)
/*TOTAL NUMBER OF AGENTS HAVING*/
* GONE IN-DOUBT
FLD: Q3STMEOT LEN(4) TYPE(BIN) DISP(44) /*SSAM EOT'S*/
FLD: Q3STMEOM LEN(4) TYPE(BIN) DISP(48) /*SSAM EOM'S*/
FLD: Q3STSSSI LEN(4) TYPE(BIN) DISP(52) /*TOTAL NUMBER OF SSI CALLS*/
* PROCESSED (SSSS)
FLD: Q3STCTHW LEN(4) TYPE(BIN) DISP(56)
/*NUMBER OF DSN3CTHD WHICH WAITED*/
FLD: Q3STRDON LEN(4) TYPE(BIN) DISP(60) /*NUMBER OF READ ONLY COMMITS*/
FLD: Q3STHWIB LEN(4) TYPE(BIN) DISP(64)
/*High water mark for IDBACK threads*/
FLD: Q3STHWIF LEN(4) TYPE(BIN) DISP(68)
/*High water mark for IDFORE threads*/
FLD: Q3STHWCT LEN(4) TYPE(BIN) DISP(72)
/*High water mark for CTHREAD threads*/
FLD: Q3STDATL LEN(1) /*Q3STDATA LENGTH OF DATA PORTION*/
*/* ---------------------------------------------------------------- */
*/* */
*/* Licensed Materials - Property of IBM */
*/* 5635-DB2 */
*/* (C) COPYRIGHT 1982, 2006 IBM Corp. All Rights Reserved. */
*/* */
*/* STATUS = Version 9 */
*/* */
*/* DESCRIPTIVE NAME - GCPC SMF DATA MAPPING. */
*/* */
*/* FUNCTION- */
*/* THIS MACRO MAPS THE COMMAND STATISTICAL COUNTERS WHICH ARE */
*/* PASSED TO IFC FOR THE RMFTSTAT (STATISTICAL) BROADCAST. */
*/* */
*/* */
*******************************************************************
* Q9ST DSNDQ9ST * COMMAND STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQ9ST DSECT
***********************************************************************
COMP: Q9ST_OFFSET =
WHEN(SM100RTY=100 AND QWS00R5N > 0) ASSIGN(QWS00R5O)
ELSE ASSIGN(99999)
FLD: DSNDQ9ST DISP(0) LEN(1) OFFSET(Q9ST_OFFSET)
FLD: Q9ST LEN(256) DISP(0) /*GCPC STATISTICAL COUNTER BLOCK*/
FLD: Q9STCTR0 LEN(4) TYPE(BIN) DISP(0)
/*COUNTER, CMD DISPLAY DATABASE*/
FLD: Q9STCTR1 LEN(4) TYPE(BIN) DISP(4) /*COUNTER, CMD DISPLAY THREAD*/
FLD: Q9STCTR2 LEN(4) TYPE(BIN) DISP(8) /*COUNTER, CMD DISPLAY UTILITY*/
FLD: Q9STCTR3 LEN(4) TYPE(BIN) DISP(12) /*COUNTER, CMD RECOVER BSDS*/
FLD: Q9STCTR4 LEN(4) TYPE(BIN) DISP(16)
/*COUNTER, CMD RECOVER INDOUBT*/
FLD: Q9STCTR5 LEN(4) TYPE(BIN) DISP(20) /*COUNTER, CMD START DATABASE*/
FLD: Q9STCTR6 LEN(4) TYPE(BIN) DISP(24) /*COUNTER, CMD START TRACE*/
FLD: Q9STCTR7 LEN(4) TYPE(BIN) DISP(28)
/*COUNTER, CMD START SUBSYSTEM*/
FLD: Q9STCTR8 LEN(4) TYPE(BIN) DISP(32) /*COUNTER, CMD STOP DATABASE*/
FLD: Q9STCTR9 LEN(4) TYPE(BIN) DISP(36) /*COUNTER, CMD STOP TRACE*/
FLD: Q9STCTRA LEN(4) TYPE(BIN) DISP(40) /*COUNTER, CMD STOP SUBSYSTEM*/
FLD: Q9STCTRB LEN(4) TYPE(BIN) DISP(44) /*COUNTER, CMD TERM UTILITY*/
FLD: Q9STCTRC LEN(4) TYPE(BIN) DISP(48) /*COUNTER, CMD DIS TRACE*/
FLD: Q9STCTRD LEN(4) TYPE(BIN) DISP(52)
/*COUNTER, CMD RESET GENERICLU*/
FLD: Q9STEROR LEN(4) TYPE(BIN) DISP(56)
/*COUNTER, UNRECOGNIZED COMMAND*/
FLD: Q9STCTRE LEN(4) TYPE(BIN) DISP(60) /*COUNTER, CMD START RLIMIT*/
FLD: Q9STCTRF LEN(4) TYPE(BIN) DISP(64) /*COUNTER, CMD STOP RLIMIT*/
FLD: Q9STCTRG LEN(4) TYPE(BIN) DISP(68) /*COUNTER, CMD DISPLAY RLIMIT*/
FLD: Q9STCTRH LEN(4) TYPE(BIN) DISP(72) /*COUNTER, CMD MODIFY TRACE*/
FLD: Q9STCTRI LEN(4) TYPE(BIN) DISP(76) /*COUNTER, CMD START DDF*/
FLD: Q9STCTRJ LEN(4) TYPE(BIN) DISP(80) /*COUNTER, CMD STOP DDF*/
FLD: Q9STCTRK LEN(4) TYPE(BIN) DISP(84)
/*COUNTER, CMD CANCEL(DDF)THREAD*/
FLD: Q9STCTRL LEN(4) TYPE(BIN) DISP(88)
/*COUNTER, CMD DISPLAY LOCATION*/
FLD: Q9STCTRM LEN(4) TYPE(BIN) DISP(92) /*COUNTER, CMD ARCHIVE LOG*/
FLD: Q9STCTRN LEN(4) TYPE(BIN) DISP(96)
/*COUNTER, CMD ALTER BUFFERPOOL*/
FLD: Q9STCTRO LEN(4) TYPE(BIN) DISP(100)
/*COUNTER, CMD DISPLAY BUFFERPOOL*/
FLD: Q9STCTRP LEN(4) TYPE(BIN) DISP(104) /*COUNTER, CMD SET ARCHIVE*/
FLD: Q9STCTRQ LEN(4) TYPE(BIN) DISP(108)
/*COUNTER, CMD DISPLAY ARCHIVE*/
FLD: Q9STCTRR LEN(4) TYPE(BIN) DISP(112) /*COUNTER, CMD RESET INDOUBT*/
FLD: Q9STCTRS LEN(4) TYPE(BIN) DISP(116) /*COUNTER, CMD ALTER GBPOOL*/
FLD: Q9STCTRT LEN(4) TYPE(BIN) DISP(120)
/*COUNTER, CMD DISPLAY GBPOOL*/
FLD: Q9STCTRU LEN(4) TYPE(BIN) DISP(124)
/*COUNTER, CMD DISPLAY PROCEDURE*/
FLD: Q9STCTRV LEN(4) TYPE(BIN) DISP(128)
/*COUNTER, CMD START PROCEDURE*/
FLD: Q9STCTRW LEN(4) TYPE(BIN) DISP(132)
/*COUNTER, CMD STOP PROCEDURE*/
FLD: Q9STCTRX LEN(4) TYPE(BIN) DISP(136) /*COUNTER, CMD DIS GROUP*/
FLD: Q9STCTRY LEN(4) TYPE(BIN) DISP(140) /*COUNTER, CMD ALTER UTILITY*/
FLD: Q9STCTRZ LEN(4) TYPE(BIN) DISP(144)
/*COUNTER, CMD DISPLAY FUNCTION*/
FLD: Q9STCTX0 LEN(4) TYPE(BIN) DISP(148)
/*COUNTER, CMD START FUNCTION*/
FLD: Q9STCTX1 LEN(4) TYPE(BIN) DISP(152) /*COUNTER, CMD STOP FUNCTION*/
FLD: Q9STCTX2 LEN(4) TYPE(BIN) DISP(156) /*COUNTER, CMD SET LOG*/
FLD: Q9STCTX3 LEN(4) TYPE(BIN) DISP(160) /*COUNTER, CMD DISPLAY LOG*/
FLD: Q9STCTX4 LEN(4) TYPE(BIN) DISP(164) /*COUNTER, CMD SET SYSPARM*/
FLD: Q9STCTX5 LEN(4) TYPE(BIN) DISP(168) /*COUNTER, CMD DISPLAY DDF*/
FLD: Q9STCTAD LEN(4) TYPE(BIN) DISP(172)
/*COUNTER, CMD ACCESS DATABASE*/
FLD: Q9STCTSS LEN(4) TYPE(BIN) DISP(176) /*COUNTER, CMD START PROFILE*/
FLD: Q9STCTST LEN(4) TYPE(BIN) DISP(180) /*COUNTER, CMD STOP PROFILE*/
FLD: Q9STCTSD LEN(4) TYPE(BIN) DISP(184)
/*COUNTER, CMD DISPLAY PROFILE*/
*******************************************************************
* QWSD DSNDQWSD * IFC CHECKPOINT INFORMATION - RELEASE 2
*******************************************************************
***********************************************************************
**** QWSD DSECT
***********************************************************************
COMP: QWSD_OFFSET =
WHEN(SM100RTY=100 AND QWS00R6N > 0) ASSIGN(QWS00R6O)
ELSE ASSIGN(99999)
FLD: QWSD DISP(0) LEN(1) OFFSET(QWSD_OFFSET)
* MISCELLANEOUS IFC PROVIDED STATISTICS
*
FLD: QWSDCKPT LEN(4) TYPE(BIN) DISP(0) /*DB2 CHECKPOINT COUNT*/
*
FLD: QWSDRINV LEN(4) TYPE(BIN) DISP(4)
/*REASON WHY STATISTICS WAS INVOKED*/
* 04 = DB2 START UP
* 08 = DB2 SHUT DOWN
* 0C = BY COMMAND
* 10 = ACTIVATED BY TIMER
* 14 = ACTIVATED AT CHECKPOINT
* 18 = ACTIVATED DURING ACCOUNTING
* 1C = READS REQUEST
* 20 = RESERVED */
*
FLD: QWSDLR LEN(8) DISP(8) /*HIGH USED RBA ADDRESS OF LOG*/
*
* THE IFI COUNTERS ARE NOT UPDATED USING COMPARE AND SWAP
*
FLD: QWSDSCA LEN(4) TYPE(BIN) DISP(16) /*COUNT OF IFI ABENDS*/
FLD: QWSDSCU LEN(4) TYPE(BIN) DISP(20)
/*COUNT OF IFI UNRECOGNIZED FUNCTIONS*/
FLD: QWSDSCCO LEN(4) TYPE(BIN) DISP(24)
/*COUNT OF IFI COMMAND REQUESTS*/
FLD: QWSDSCRA LEN(4) TYPE(BIN) DISP(28) /*COUNT OF IFI READA REQUESTS*/
FLD: QWSDSCRS LEN(4) TYPE(BIN) DISP(32) /*COUNT OF IFI READS REQUESTS*/
FLD: QWSDSCWR LEN(4) TYPE(BIN) DISP(36) /*COUNT OF IFI WRITE REQUESTS*/
FLD: QWSDCDCS LEN(4) TYPE(BIN) DISP(40) /*IFI DATA CAPTURE STATISTICS*/
FLD: QWSDCDLC LEN(4) TYPE(BIN) DISP(40)
/*NUMBER OF LOG RECORDS CAPTURED FOR*/
* /* WHICH DATA CAPTURE PROCESSING WAS */
* /* INVOKED. */
FLD: QWSDCDLR LEN(4) TYPE(BIN) DISP(44)
/*NUMBER OF DATA CAPTURE LOG READS*/
* /* PERFORMED. */
FLD: QWSDCDRR LEN(4) TYPE(BIN) DISP(48)
/*NUMBER OF DATA CAPTURE LOG RECORDS*/
* /* RETURNED. */
FLD: QWSDCDDR LEN(4) TYPE(BIN) DISP(52)
/*NUMBER OF DATA CAPTURE DATA ROWS*/
* /* RETURNED. */
* /* DATA CAPTURE DATA ROWS ARE RETURNED */
* /* IN IFCID 185 AND MAPPED BY QW0185DR. */
FLD: QWSDCDDD LEN(4) TYPE(BIN) DISP(56) /*NUMBER OF DATA CAPTURE DATA*/
* /* DESCRIPTIONS RETURNED. DATA CAPTURE */
* /* DATA DESCRIPTIONS ARE MAPPED IN IFCID */
* /* 185 BEGINNING WITH FIELD QW0185DD. */
FLD: QWSDCDMB LEN(4) TYPE(BIN) DISP(60)
/*NUMBER OF DATA CAPTURE DESCRIBES*/
* /* PERFORMED. */
FLD: QWSDCDTB LEN(4) TYPE(BIN) DISP(64)
/*NUMBER OF DATA CAPTURE TABLES FOR*/
* /* WHICH DATA CAPTURE DATA DESCRIPTIONS */
* /* WERE RETURNED. */
FLD: QWSDARTH LEN(4) TYPE(BIN) DISP(68)
/*Number of rollup accounting records*/
* /* written due to rollup threshold */
* /* exceeded */
FLD: QWSDARSG LEN(4) TYPE(BIN) DISP(72)
/*Number of rollup accounting records*/
* /* written due to rollup accounting */
* /* storage threshold exceeded */
FLD: QWSDARST LEN(4) TYPE(BIN) DISP(76)
/*Number of rollup accounting records*/
* /* written due to staleness threshold */
* /* exceeded */
FLD: QWSDARIR LEN(4) TYPE(BIN) DISP(80)
/*Number of records failing to qualify*/
* /* for accounting rollup due to all */
* /* rollup key fields = NULL or NULL */
* /* values not being permitted */
FLD: QWSDEND LEN(1) DISP(84)
*******************************************************************
* QVLS DSNDQVLS * LATCH STATISTICS
*******************************************************************
***********************************************************************
**** QVLS DSECT
***********************************************************************
COMP: QVLS_OFFSET =
WHEN(SM100RTY=100 AND QWS00R7N > 0) ASSIGN(QWS00R7O)
ELSE ASSIGN(99999)
FLD: QVLS DISP(0) LEN(1) OFFSET(QVLS_OFFSET)
*! The QVLS counts represent the number of suspends performed
*! by agents attempting to obtain a latch. There is NOT a
*! 1 to 1 relationship between the QVLS counters and
*! IFCID56/57 since an agent may suspend multiple times or
*! not at all while trying to obtain a latch. Thus, the
*! QVLS counters are not directly related to accounting
*! class 3.
*!
*! IMPORTANT NOTE: All field descriptions denote the
*! predominate latch usage. The description does NOT
*! cover all usage of a given latch class.
FLD: QVLSLC01 LEN(4) TYPE(BIN) DISP(0) /*Infrequently used*/
FLD: QVLSLC02 LEN(4) TYPE(BIN) DISP(4) /*Global authorization cache*/
FLD: QVLSLC03 LEN(4) TYPE(BIN) DISP(8) /*DDF disconnect*/
FLD: QVLSLC04 LEN(4) TYPE(BIN) DISP(12) /*SYSSTRING cache*/
FLD: QVLSLC05 LEN(4) TYPE(BIN) DISP(16) /*IRLM data sharing exits*/
* /* or RLF */
FLD: QVLSLC06 LEN(4) TYPE(BIN) DISP(20) /*Data sharing index split*/
FLD: QVLSLC07 LEN(4) TYPE(BIN) DISP(24) /*Index lotch and OBD*/
* /* allocation */
FLD: QVLSLC08 LEN(4) TYPE(BIN) DISP(28) /*Query parallelism*/
FLD: QVLSLC09 LEN(4) TYPE(BIN) DISP(32) /*Utilities or stored*/
* /* procedure URIDs */
FLD: QVLSLC10 LEN(4) TYPE(BIN) DISP(36) /*Allied agent chain or*/
* /* sequence descriptors */
FLD: QVLSLC11 LEN(4) TYPE(BIN) DISP(40) /*DGTT allocation*/
FLD: QVLSLC12 LEN(4) TYPE(BIN) DISP(44) /*Global transaction ID table*/
FLD: QVLSLC13 LEN(4) TYPE(BIN) DISP(48) /*Pageset operations*/
FLD: QVLSLC14 LEN(4) TYPE(BIN) DISP(52) /*Bufferpool LRU*/
FLD: QVLSLC15 LEN(4) TYPE(BIN) DISP(56) /*ARCHIVE LOG MODE(QUIESCE)*/
FLD: QVLSLC16 LEN(4) TYPE(BIN) DISP(60) /*UR chain*/
FLD: QVLSLC17 LEN(4) TYPE(BIN) DISP(64) /*RURE chain*/
FLD: QVLSLC18 LEN(4) TYPE(BIN) DISP(68) /*DDF resynch list*/
FLD: QVLSLC19 LEN(4) TYPE(BIN) DISP(72) /*Log write*/
FLD: QVLSLC20 LEN(4) TYPE(BIN) DISP(76) /*System checkpoint*/
FLD: QVLSLC21 LEN(4) TYPE(BIN) DISP(80) /*Accounting rollup*/
FLD: QVLSLC22 LEN(4) TYPE(BIN) DISP(84) /*Internal checkpoint*/
FLD: QVLSLC23 LEN(4) TYPE(BIN) DISP(88) /*Buffer manager*/
FLD: QVLSLC24 LEN(4) TYPE(BIN) DISP(92) /*EDM pool or prefetch*/
FLD: QVLSLC25 LEN(4) TYPE(BIN) DISP(96) /*Workfile allocation*/
FLD: QVLSLC26 LEN(4) TYPE(BIN) DISP(100) /*Dynamic statement cache*/
FLD: QVLSLC27 LEN(4) TYPE(BIN) DISP(104) /*Stored procedures or*/
* /* authorization cache */
FLD: QVLSLC28 LEN(4) TYPE(BIN) DISP(108) /*Stored procedures or*/
* /* authorization cache */
FLD: QVLSLC29 LEN(4) TYPE(BIN) DISP(112) /*Field procs and DDF*/
* /* transaction manager */
FLD: QVLSLC30 LEN(4) TYPE(BIN) DISP(116) /*Agent services*/
FLD: QVLSLC31 LEN(4) TYPE(BIN) DISP(120) /*Storage manager*/
FLD: QVLSLC32 LEN(4) TYPE(BIN) DISP(124) /*Storage manager*/
FLD: QVLSLC254 LEN(4) TYPE(BIN) DISP(128) /*Index lotch*/
FLD: QVLSEND LEN(1) DISP(132)
*******************************************************************
* QVAS DSNDQVAS * AGENT SERVICES STATISTICS
*******************************************************************
***********************************************************************
**** QVAS DSECT
***********************************************************************
COMP: QVAS_OFFSET =
WHEN(SM100RTY=100 AND QWS00R8N > 0) ASSIGN(QWS00R8O)
ELSE ASSIGN(99999)
FLD: QVAS DISP(0) LEN(1) OFFSET(QVAS_OFFSET)
* /* ASMC STATISTICS COUNTER DCL */
FLD: QVASSUSP LEN(4) TYPE(BIN) DISP(0) /*(S)*/
FLD: QVASXSUS LEN(4) TYPE(BIN) DISP(4) /*(S)*/
FLD: QVASXSUT LEN(4) TYPE(BIN) DISP(8) /*(S)*/
FLD: QVASXAUS LEN(4) TYPE(BIN) DISP(12) /*(S)*/
FLD: QVASXAUT LEN(4) TYPE(BIN) DISP(16) /*(S)*/
FLD: QVASXSRS LEN(4) TYPE(BIN) DISP(20) /*(S)*/
FLD: QVASXSRT LEN(4) TYPE(BIN) DISP(24) /*(S)*/
FLD: QVASADUR LEN(4) TYPE(BIN) DISP(28) /*(S)*/
FLD: QVASADDL LEN(4) TYPE(BIN) DISP(32) /*(S)*/
FLD: QVASADIR LEN(4) TYPE(BIN) DISP(36) /*(S)*/
FLD: QVASCBOS LEN(4) TYPE(BIN) DISP(40) /*(S)*/
FLD: QVASCBOF LEN(4) TYPE(BIN) DISP(44) /*(S)*/
FLD: QVASMBOS LEN(4) TYPE(BIN) DISP(48) /*(S)*/
FLD: QVASMBOF LEN(4) TYPE(BIN) DISP(52) /*(S)*/
FLD: QVASEND LEN(1) DISP(56) /*END*/
*******************************************************************
* QSST DSNDQSST * STORAGE MANAGER STATISTICS
*******************************************************************
***********************************************************************
**** DSECT ,
***********************************************************************
COMP: QSST_OFFSET =
WHEN(SM100RTY=100 AND QWS00R9N > 0) ASSIGN(QWS00R9O)
ELSE ASSIGN(99999)
FLD: QSST_DSECT DISP(0) LEN(1) OFFSET(QSST_OFFSET)
FLD: QSST LEN(8) DISP(0) /*CONTROL BLOCK NAME*/
FLD: QSSTHEAD LEN(4) TYPE(BIN) DISP(0) /*! QSST header*/
FLD: QSSTID LEN(2) DISP(0) /*! ID*/
FLD: QSSTLEN TYPE(HALF) DISP(2) /*! Length*/
FLD: QSSTDESC LEN(4) DISP(4) /*! Eye catchers*/
FLD: QSSTDATA LEN(4) TYPE(BIN) DISP(8) /*! Serviceability counters*/
FLD: QSSTGPLF LEN(4) TYPE(BIN) DISP(8) /*! (S) Get fixed pool*/
FLD: QSSTFPLF LEN(4) TYPE(BIN) DISP(12) /*! (S) Free fixed pool*/
FLD: QSSTFREF LEN(4) TYPE(BIN) DISP(16)
/*! (S) Freemained segments in 31 bit*/
* ! fixed pools
FLD: QSSTEXPF LEN(4) TYPE(BIN) DISP(20)
/*! (S) Extensions getmained in fixed*/
* ! pools
FLD: QSSTCONF LEN(4) TYPE(BIN) DISP(24)
/*! (S) Contracted segments in 31 bit*/
* ! fixed pools
FLD: QSSTGPLV LEN(4) TYPE(BIN) DISP(28) /*! (S) Get variable pool*/
FLD: QSSTFPLV LEN(4) TYPE(BIN) DISP(32) /*! (S) Free variable pool*/
FLD: QSSTFREV LEN(4) TYPE(BIN) DISP(36)
/*! (S) Freemained segments in 31 bit*/
* ! variable pools
FLD: QSSTEXPV LEN(4) TYPE(BIN) DISP(40)
/*! (S) Extensions getmained in 31 bit*/
* ! variable pools
FLD: QSSTCONV LEN(4) TYPE(BIN) DISP(44)
/*! (S) Contracted segments in 31 bit*/
* ! variable pools
FLD: QSSTGETM LEN(4) TYPE(BIN) DISP(48)
/*! (S) 31 bit getmain request*/
FLD: QSSTFREM LEN(4) TYPE(BIN) DISP(52)
/*! (S) 31 bit freemain request*/
FLD: QSSTRCNZ LEN(4) TYPE(BIN) DISP(56)
/*! (S) Conditional 31 bit get request*/
* ! failure due to local storage
* ! shortage
FLD: QSSTCONT LEN(4) TYPE(BIN) DISP(60)
/*! (S) Full system contractions*/
FLD: QSSTCRIT LEN(4) TYPE(BIN) DISP(64)
/*! (S) Critical storage shortage after*/
* ! contraction
FLD: QSSTABND LEN(4) TYPE(BIN) DISP(68)
/*! (S) Abends due to local storage*/
* ! shortage
FLD: QSST_SGETM LEN(8) DISP(72) /*! (S) 31 bit stack request required*/
* ! a GETMAIN
FLD: QSST_SGETR LEN(8) TYPE(BIN) DISP(80)
/*! (S) Number of out of line 31 bit*/
* ! stack get requests
FLD: QSST_SGETEXT LEN(8) DISP(88)
/*! (S) 31 bit stack request satisfied*/
* ! via an available extension
FLD: QSST_SFREEM LEN(8) DISP(96) /*! (S) 31 bit free request required*/
* ! a FREEMAIN
FLD: QSST_SFREER LEN(8) TYPE(BIN) DISP(104)
/*! (S) Number of out of line 31 bit*/
* ! stack free requests
FLD: QSST_D64POST LEN(8) TYPE(BIN) DISP(112)
/*! (S) Number of out of line 64 bit*/
* ! stack deallocation requests
FLD: QSST_A64POST LEN(8) TYPE(BIN) DISP(120)
/*! (S) Number of out of line 64 bit*/
* ! stack allocation requests
FLD: QSST_A64WAIT LEN(8) TYPE(BIN) DISP(128)
/*! (S) Number of out of line 64 bit*/
* ! stack allocation requests that
* ! resulted in a wait
FLD: QSST_M64DISNUM LEN(8) TYPE(BIN) DISP(136)
/*! (S) Number of 64 bit stack segment*/
* ! that required a discard
FLD: QSST_M64DISPGS LEN(8) TYPE(BIN) DISP(144)
/*! (S) Number of 64 bit stack pages*/
* ! discarded
FLD: QSST_SGETR64 LEN(8) TYPE(BIN) DISP(152)
/*! (S) Number of out of line 64 bit*/
* ! stack get requests
FLD: QSST_SGETEXT64 LEN(8) DISP(160)
/*! (S) 64 bit stack request satisfied*/
* ! via an available extension
FLD: QSST_SGETDEXT64 LEN(8) DISP(168)
/*! (S) 64 bit stack request required*/
* ! an extension deallocation
FLD: QSST_SFREER64 LEN(8) TYPE(BIN) DISP(176)
/*! (S) Number of out of line 64 bit*/
* ! stack free requests
FLD: QSST_SFREEDEXT64 LEN(8) DISP(184)
/*! (S) 64 bit stack free required*/
* ! an extension deallocation
FLD: QSST_DISCARDMODE64 LEN(8) DISP(192)
/*! (S) Real frame discard mode*/
FLD: QSST_RSMAX_WARN LEN(8) TYPE(BIN) DISP(200)
/*! (S) Number of times REALSTORAGE_MAX*/
* ! warning level was reached
FLD: QSST_P64DISNUM LEN(8) TYPE(BIN) DISP(208)
/*! (S) Number of 64 bit pools*/
* ! contracted
FLD: QSST_P64DISBLK LEN(8) TYPE(BIN) DISP(216)
/*! (S) Number of 64 bit pool blocks*/
* ! that required a discard
FLD: QSST_P64DISPGS LEN(8) TYPE(BIN) DISP(224)
/*! (S) Number of 64 bit pool pages*/
* ! discarded
FLD: QSST_CONTSTOR_NUM LEN(8) TYPE(BIN) DISP(232)
/*! Number of 31 bit agent local pools*/
* ! contracted due to system configuration
* ! parameter CONTSTOR being enabled
FLD: QSSTEND LEN(1) DISP(240) /*! QSST end*/
COMP: QSSTIDEN = X'003C' /*HEADER CONSTANT*/
COMP: QSSTEYEC = 'QSST' /*EYE CATCHER CONSTANT*/
*******************************************************************
* QLST DSNDQLST * DDF STATISTICS - V2R2
*******************************************************************
***********************************************************************
**** QLST DSECT
***********************************************************************
COMP: QLST_OFFSET =
WHEN(SM100RTY=100 AND QWS00RAN > 0) ASSIGN(QWS00RAO)
ELSE ASSIGN(99999)
FLD: QLST DISP(0) LEN(1) OFFSET(QLST_OFFSET)
FLD: QLSTLOCN_OFF TYPE(HALF) DISP(0) /*Offset from QLST to*/
* LOCATION NAME OF THE 'REMOTE'
* SITE WITH WHICH THE
* INFORMATION IS ASSOCIATED.
* If QLSTLOCN truncated
FLD: QLSTLOCN LEN(16) DISP(8) /*%U LOCATION NAME OF THE 'REMOTE'*/
* SITE WITH WHICH THE
* INFORMATION IS ASSOCIATED.
* Truncated if QLSTLOCN_Off¬=0
FLD: QLSTPRID LEN(8) DISP(24) /*THE PRDID OF THE REMOTE LOCATION.*/
FLD: QLSTCNVS LEN(8) TYPE(BIN) DISP(32)
/*NUMBER OF CONVERSATIONS THAT*/
* WERE INITIATED FROM THIS
* SITE TO THE REMOTE SITE.
* (MEANINGFUL AT AR ONLY).
FLD: QLSTCNVT LEN(8) TYPE(BIN) DISP(40)
/*NUMBER OF CONVERSATIONS THAT*/
* WERE DEALLOCATED FROM THIS
* SITE TO THE REMOTE SITE
* (MEANINGFUL AT AR ONLY).
FLD: QLSTCNVR LEN(8) TYPE(BIN) DISP(48)
/*NUMBER OF CONVERSATIONS THAT*/
* WERE INITIATED FROM THE
* REMOTE SITE TO THIS SITE.
* (MEANINGFUL AT AS ONLY).
FLD: QLSTMSGS LEN(8) TYPE(BIN) DISP(56) /*NUMBER OF MESSAGES SENT TO*/
* THE REMOTE SITE.
FLD: QLSTMSGR LEN(8) TYPE(BIN) DISP(64) /*NUMBER OF MESSAGES RECEIVED*/
* FROM THE REMOTE SITE.
FLD: QLSTSQLS LEN(8) TYPE(BIN) DISP(72)
/*NUMBER OF SQL STATEMENTS SENT*/
* TO THE REMOTE SITE.
FLD: QLSTSQLR LEN(8) TYPE(BIN) DISP(80) /*NUMBER OF SQL STATEMENTS*/
* RECEIVED FROM THE REMOTE SITE.
FLD: QLSTBYTS LEN(8) TYPE(BIN) DISP(88)
/*NUMBER OF BYTES OF DATA SENT*/
* TO THE REMOTE SITE.
FLD: QLSTBYTR LEN(8) TYPE(BIN) DISP(96) /*NUMBER OF BYTES OF DATA*/
* RECEIVED FROM THE REMOTE SITE.
FLD: QLSTROWS LEN(8) TYPE(BIN) DISP(104)
/*NUMBER OF ROWS OF DATA SENT TO THE*/
* REMOTE SITE (INCLUDES THE SQLDA)
FLD: QLSTROWR LEN(8) TYPE(BIN) DISP(112) /*NUMBER OF ROWS OF DATA*/
* RETRIEVED FROM THE REMOTE SITE (THIS
* COUNT DOES NOT INCLUDE
* EITHER THE SQLDA OR SQLCA
* IF THEY ARE TRANSMITTED).
FLD: QLSTBTBF LEN(8) TYPE(BIN) DISP(120)
/*NUMBER OF BLOCKS TRANSMITTED USING BLOCK*/
* FETCH (SERVER SITE ONLY).
FLD: QLSTBRBF LEN(8) TYPE(BIN) DISP(128)
/*NUMBER OF BLOCKS RECEIVED USING BLOCK*/
* FETCH (REQUESTER SITE ONLY).
FLD: QLSTCOMS LEN(8) TYPE(BIN) DISP(136)
/*NUMBER OF COMMIT REQUESTS SENT TO THE*/
* SERVER (SINGLE-PHASE COMMIT PROTOCOL)
* AND COMMITED REQUESTS SENT TO THE
* PARTICIPANT (TWO-PHASE COMMIT PROTOCOL).
FLD: QLSTCOMR LEN(8) TYPE(BIN) DISP(144)
/*NUMBER OF COMMIT REQUESTS RECEIVED FROM THE*/
* REQUESTER (SINGLE-PHASE COMMIT PROTOCOL)
* AND COMMITED REQUESTS RECEIVED FROM THE
* COORDINATOR (TWO-PHASE COMMIT PROTOCOL).
FLD: QLSTABRS LEN(8) TYPE(BIN) DISP(152)
/*NUMBER OF ABORT REQUESTS SENT TO THE SERVER*/
* (SINGLE-PHASE COMMIT PROTOCOL) AND
* NUMBER OF BACKOUT REQUESTS SENT TO THE
* PARTICIPANT (TWO-PHASE COMMIT PROTOCOL).
FLD: QLSTABRR LEN(8) TYPE(BIN) DISP(160)
/*NUMBER OF ABORT REQUESTS RECEIVED FROM THE*/
* REQUESTER (SINGLE-PHASE COMMIT PROTOCOL)
* AND NUMBER OF BACKOUT REQUESTS RECEIVED
* FROM THE COORDINATOR (TWO-PHASE COMMIT
* PROTOCOL)
FLD: QLSTINDT LEN(8) TYPE(BIN) DISP(168)
/*NUMBER OF THREADS THAT BECAME INDOUBT WITH THE*/
* REMOTE LOCATION AS THE COORDINATOR.
FLD: QLSTCNVQ LEN(8) TYPE(BIN) DISP(176)
/*NUMBER OF CONVERSATION REQUESTS*/
* QUEUED BY DDF WAITING FOR
* ALLOCATION.
FLD: QLSTEND LEN(4) TYPE(BIN) DISP(184)
*
*
***********************************************************************
**** QLSTLOCN_D DSECT Use if QLSTLOCN_Off¬=0
***********************************************************************
COMP: QLSTLOCN_D_OFFSET =
WHEN(SM100RTY=100 AND QWS00RAN > 0 AND QLSTLOCN_Off <> 0)
ASSIGN(QWS00RAO + QLSTLOCN_Off)
ELSE ASSIGN(99999)
FLD: QLSTLOCN_D DISP(0) LEN(1) OFFSET(QLSTLOCN_D_OFFSET)
/*Use if QLSTLOCN_Off¬ 0*/
FLD: QLSTLOCN_LEN TYPE(HALF) DISP(0) /*Length of the following field*/
FLD: QLSTLOCN_VAR LEN(128) DISP(2)/*%U LOCATION NAME OF THE 'REMOTE'*/
* SITE WITH WHICH THE
* INFORMATION IS ASSOCIATED.
* Truncated if QLSTLOCN_Off¬=0
*******************************************************************
* QJST DSNDQJST * LOG MANAGER STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQJST DSECT
***********************************************************************
COMP: QJST_OFFSET =
WHEN(SM100RTY=100 AND QWS00RBN > 0) ASSIGN(QWS00RBO)
ELSE ASSIGN(99999)
FLD: DSNDQJST DISP(0) LEN(1) OFFSET(QJST_OFFSET)
FLD: QJST LEN(8) DISP(0)
FLD: QJSTID LEN(2) DISP(0) /*(S) CONTROL BLOCK ID X'0093'*/
FLD: QJSTLL TYPE(HALF) DISP(2) /*LENGTH OF BLOCK*/
FLD: QJSTEID LEN(4) DISP(4) /*EBCDIC EYECATCHER*/
FLD: QJSTWRW LEN(4) TYPE(BIN) DISP(8) /*WRITE REQUEST COUNT, WAIT*/
FLD: QJSTWRNW LEN(4) TYPE(BIN) DISP(12) /*WRITE REQUEST COUNT, NOWAIT*/
FLD: QJSTWRF LEN(4) TYPE(BIN) DISP(16) /*WRITE REQUEST COUNT, FORCE*/
FLD: QJSTWTB LEN(4) TYPE(BIN) DISP(20)
/*WAIT COUNT DUE TO UNAVAILABLE ACTIVE BUFFER*/
FLD: QJSTRBUF LEN(4) TYPE(BIN) DISP(24)
/*LOG READS SATISFIED FROM OUTPUT BUFFERS*/
FLD: QJSTRACT LEN(4) TYPE(BIN) DISP(28)
/*READS SATISFIED FROM ACTIVE LOG DATA SET*/
FLD: QJSTRARH LEN(4) TYPE(BIN) DISP(32)
/*READS SATISFIED FROM ARCHIVE LOG DATA SET*/
FLD: QJSTTVC LEN(4) TYPE(BIN) DISP(36)
/*NUMBER OF READ ACCESSES DELAYED DUE TO*/
* TAPE VOLUME CONTENTION
FLD: QJSTBSDS LEN(4) TYPE(BIN) DISP(40) /*TOTAL BSDS ACCESS REQUESTS*/
FLD: QJSTBFFL LEN(4) TYPE(BIN) DISP(44)
/*ACTIVE LOG OUTPUT CONTROL INTERVALS CREATED*/
FLD: QJSTBFWR LEN(4) TYPE(BIN) DISP(48)
/*COUNT OF CALLS TO WRITE ACTIVE LOG BUFFERS*/
FLD: QJSTALR LEN(4) TYPE(BIN) DISP(52)
/*ARCHIVE LOG READ ALLOCATIONS*/
FLD: QJSTALW LEN(4) TYPE(BIN) DISP(56)
/*ARCHIVE LOG WRITE ALLOCATIONS*/
FLD: QJSTCIOF LEN(4) TYPE(BIN) DISP(60)
/*COUNT OF CONTROL INTERVALS OFFLOADED*/
FLD: QJSTWUR LEN(4) TYPE(BIN) DISP(64)
/*NUMBER OF READ ACCESSES DELAYED DUE TO*/
* UNAVAILABLE RESOURCE
FLD: QJSTLAMA LEN(4) TYPE(BIN) DISP(68)
/*NUMBER OF LOOK AHEAD TAPE VOLUME MOUNTS*/
* ATTEMPTED. THIS FIELD ALONG WITH FIELD
* QJSTLAMS, WILL SHOW HOW MANY TIMES LOOK-
* AHEAD MOUNTING FAILED, THUS NEGATING
* POTENTIAL SIGNIFICANT PERFORMANCE GAINS.
FLD: QJSTLAMS LEN(4) TYPE(BIN) DISP(72)
/*NUMBER OF LOOK AHEAD TAPE VOLUME MOUNTS*/
* PERFORMED.
FLD: QJSTLSUS LEN(4) TYPE(BIN) DISP(76) /*(S)*/
FLD: QJSTLOGW LEN(4) TYPE(BIN) DISP(80)
/*TOTAL NUMBER OF LOG WRITE I/O REQUESTS.*/
FLD: QJSTCIWR LEN(4) TYPE(BIN) DISP(84)
/*TOTAL NUMBER OF LOG CI S WRITTEN.*/
FLD: QJSTSERW LEN(4) TYPE(BIN) DISP(88)
/*NUMBER OF SERIAL LOG WRITE REQUESTS FOR*/
* CI RE-WRITES WHEN DUAL LOGGING.
FLD: QJSTTHRW LEN(4) TYPE(BIN) DISP(92)
/*NUMBER OF TIMES A LOG WRITE REQUEST WAS*/
* SCHEDULED BECAUSE THE LOG WRITE THRESHOLD
* WAS REACHED.
FLD: QJSTBPAG LEN(4) TYPE(BIN) DISP(96)
/*NUMBER OF TIMES A LOG WRITE BUFFER HAD TO*/
* BE PAGED-IN BEFORE IT COULD BE USED.
FLD: QJSTSPNN LEN(4) TYPE(BIN) DISP(100) /*(S)*/
FLD: QJSTSPNI LEN(8) DISP(104) /*(S)*/
FLD: QJSTEND LEN(4) TYPE(BIN) DISP(112)
*******************************************************************
* QDST DSNDQDST * DDF SYSTEM STATISTICS
*******************************************************************
***********************************************************************
**** QDST DSECT
***********************************************************************
COMP: QDST_OFFSET =
WHEN(SM100RTY=100 AND QWS00RCN > 0) ASSIGN(QWS00RCO)
ELSE ASSIGN(99999)
FLD: QDST DISP(0) LEN(1) OFFSET(QDST_OFFSET)
* DDF SYSTEM STATISTICS
*
FLD: QDSTQDBT LEN(4) TYPE(BIN) DISP(0) /*NUMBER OF TIMES THAT A DBAT*/
* /* OR CONNECTION WAS QUEUED */
* /* DUE TO HAVING REACHED THE */
* /* ZPARM MAXIMUM FOR ACTIVE */
* /* REMOTE THREADS (MAXDBAT). */
* /* ALSO SEE QDSTNQR2. */
FLD: QDSTCSTR LEN(4) TYPE(BIN) DISP(4) /*NUMBER OF COLD START*/
* /* CONNECTIONS WITH ALL REMOTE*/
* /* LOCATIONS (TWO-PHASE */
* /* COMMIT PROTOCOL ONLY). */
FLD: QDSTWSTR LEN(4) TYPE(BIN) DISP(8) /*NUMBER OF WARM START*/
* /* CONNECTIONS WITH ALL REMOTE*/
* /* LOCATIONS (TWO-PHASE */
* /* COMMIT PROTOCOL ONLY). */
FLD: QDSTRSAT LEN(4) TYPE(BIN) DISP(12) /*NUMBER OF RESYNCHRONIZATION*/
* /* CONNECTIONS ATTEMPTED WITH */
* /* ALL REMOTE LOCATIONS (TWO- */
* /* PHASE COMMIT PROTOCOL ONLY)*/
FLD: QDSTRSSU LEN(4) TYPE(BIN) DISP(16) /*NUMBER OF RESYNCHRONIZATION*/
* /* CONNECTIONS THAT SUCCEEDED */
* /* WITH ALL REMOTE LOCATIONS */
* /* (TWO-PHASE COMMIT PROTOCOL */
* /* ONLY). */
FLD: QDSTQCRT LEN(4) TYPE(BIN) DISP(20) /*NUMBER OF CONNECTIONS THAT*/
* /* WERE REJECTED DUE TO HAVING*/
* /* REACHED THE ZPARM LIMIT FOR*/
* /* MAXIMUM REMOTE CONNECTIONS */
* /* (CONDBAT). */
FLD: QDSTQCIT LEN(4) TYPE(BIN) DISP(24) /*THE CURRENT NUMBER OF*/
* /* TYPE 1 INACTIVE DBATs */
FLD: QDSTQMIT LEN(4) TYPE(BIN) DISP(28) /*THE MAXIMUM NUMBER OF*/
* /* TYPE 1 INACTIVE DBATs THAT */
* /* EXISTED (HIGH WATER MARK) */
FLD: QDSTCNAT LEN(4) TYPE(BIN) DISP(32) /*CURRENT NUMBER OF ACTIVE*/
* /* AND DISCONNECTED (POOLED) */
* /* DBATs. */
FLD: QDSTHWAT LEN(4) TYPE(BIN) DISP(36) /*QDSTCNAT HIGH WATER MARK.*/
* /* MAXIMUM NUMBER OF ACTIVE */
* /* AND DISCONNECTED (POOLED) */
* /* DBATs THAT EXISTED. */
FLD: QDSTHWDT LEN(4) TYPE(BIN) DISP(40) /*THE MAXIMUM NUMBER OF*/
* /* REMOTE CONNECTIONS THAT */
* /* EXISTED (HIGH WATER MARK). */
FLD: QDSTNITC LEN(4) TYPE(BIN) DISP(44) /*NUMBER OF THREADS*/
* /* CONNECTIONS THAT WERE */
* /* TERMINATED RATHER THAN MADE*/
* /* TYPE 1 INACTIVE BECAUSE THE*/
* /* MAXIMUM NUMBER OF TYPE 1 */
* /* INACTIVE THREADS WAS */
* /* REACHED (MAXTYPE1). */
FLD: QDSTCIN2 LEN(4) TYPE(BIN) DISP(48) /*CURRENT NUMBER OF (TYPE 2)*/
* /* INACTIVE CONNECTIONS. */
FLD: QDSTMIN2 LEN(4) TYPE(BIN) DISP(52) /*QDSTCIN2 HIGH WATER MARK.*/
* /* MAXIMUM NUMBER OF */
* /* CONCURRENT (TYPE 2) */
* /* INACTIVE CONNECTIONS THAT */
* /* HAVE EXISTED. */
FLD: QDSTQIN2 LEN(4) TYPE(BIN) DISP(56) /*NUMBER OF RECEIVE REQUESTS*/
* /* ON (TYPE 2) INACTIVE */
* /* CONNECTIONS, OR NEW */
* /* CONNECTIONS, THAT HAVE BEEN*/
* /* QUEUED TO BE SERVICED BY A */
* /* DISCONNECTED (POOLED) DBAT.*/
* /* ALSO SEE QDSTNQR2. */
FLD: QDSTNQR2 LEN(4) TYPE(BIN) DISP(60) /*CURRENT NUMBER OF (TYPE 2)*/
* /* INACTIVE CONNECTIONS, OR */
* /* NEW CONNECTIONS, THAT ARE */
* /* QUEUED WAITING TO BE */
* /* SERVICED BY A DBAT. */
* /* ALSO SEE QDSTNQMN, */
* /* QDSTNQMX, AND QDSTNQAV. */
FLD: QDSTMQR2 LEN(4) TYPE(BIN) DISP(64) /*QDSTNQR2 HIGH WATER MARK.*/
* /* MAXIMUM NUMBER OF (TYPE 2) */
* /* INACTIVE CONNECTIONS, OR */
* /* NEW CONNECTIONS, THAT WERE */
* /* QUEUED WAITING TO BE */
* /* SERVICED BY A DBAT. */
FLD: QDSTNADS LEN(4) TYPE(BIN) DISP(68) /*CURRENT NUMBER OF*/
* /* DISCONNECTED (POOLED) DBATS*/
* /* THAT ARE AVAILABLE TO */
* /* SERVICE WORK ON (TYPE 2) */
* /* INACTIVE CONNECTIONS OR NEW*/
* /* CONNECTIONS. */
FLD: QDSTMADS LEN(4) TYPE(BIN) DISP(72) /*QDSTNADS HIGH WATER MARK.*/
* /* MAXIMUM NUMBER OF */
* /* DISCONNECTED (POOLED) DBATS*/
* /* THAT WERE AVAILABLE TO */
* /* SERVICE WORK ON (TYPE 2) */
* /* INACTIVE CONNECTIONS OR NEW*/
* /* CONNECTIONS. */
FLD: QDSTNDBA LEN(4) TYPE(BIN) DISP(76) /*NUMBER OF REQUESTS THAT*/
* /* REQUIRED A DATA BASE ACCESS*/
* /* THREAD (DBAT) TO BE CREATED*/
* /* TO PROCESS THE REQUEST. */
* /* NOTE THAT THIS DOES NOT */
* /* INCLUDE DATA BASE ACCESS */
* /* THREADS CREATED TO REPLACE */
* /* DISCONNECTED (POOL) DBATS */
* /* THAT TERMINATED BECAUSE */
* /* THEY REACHED THEIR REUSE */
* /* LIMIT. */
FLD: QDSTPOOL LEN(4) TYPE(BIN) DISP(80) /*NUMBER OF REQUESTS THAT*/
* /* WERE SATISFIED BY ASSIGNING*/
* /* A DISCONNECTED (POOL) DBAT */
* /* TO PROCESS THE REQUEST. */
FLD: QDSTNCQC LEN(4) TYPE(BIN) DISP(84) /*NUMBER OF QUEUED CLIENT*/
* /* CONNECTIONS WHICH HAVE HAD */
* /* THEIR TCP/IP SOCKETS CLOSED*/
* /* BECAUSE MAXDBAT WAS REACHED*/
* /* AND THE NUMBER OF INACTIVE */
* /* CONNECTIONS QUEUED, WAITING*/
* /* FOR A DBAT, HAS ALSO */
* /* REACHED MAXDBAT IN NUMBER. */
FLD: QDSTNARD LEN(4) TYPE(BIN) DISP(88) /*CURRENT NUMBER OF ACTIVE*/
* /* DBATS DUE TO PACKAGES BOUND*/
* /* WITH RELEASE(DEALLOCATE) */
FLD: QDSTMARD LEN(4) TYPE(BIN) DISP(92) /*MAXIMUM NUMBER OF ACTIVE*/
* /* DBATS DUE TO PACKAGES BOUND*/
* /* WITH RELEASE(DEALLOCATE) */
FLD: QDSTNQMN LEN(8) DISP(96) /*Relative to QDSTNQR2, the*/
* /* minimum queued duration */
* /* for this statistics period.*/
* /* Note: Only statistics */
* /* records written due to an */
* /* expired statistics timer */
* /* will cause the value to */
* /* be reset. Statistics */
* /* records written for IFI */
* /* READS, checkpoints, or */
* /* commands will not result */
* /* in a value reset. */
* /* STCK format. */
FLD: QDSTNQMX LEN(8) DISP(104) /*Relative to QDSTNQR2, the*/
* /* maximum queued duration */
* /* for this statistics period.*/
* /* Note: Only statistics */
* /* records written due to an */
* /* expired statistics timer */
* /* will cause the value to */
* /* be reset. Statistics */
* /* records written for IFI */
* /* READS, checkpoints, or */
* /* commands will not result */
* /* in a value reset. */
* /* STCK format. */
FLD: QDSTNQAV LEN(8) DISP(112) /*Relative to QDSTNQR2, the*/
* /* average queued duration */
* /* for this statistics period.*/
* /* Note: Only statistics */
* /* records written due to an */
* /* expired statistics timer */
* /* will cause the value to */
* /* be reset. Statistics */
* /* records written for IFI */
* /* READS, checkpoints, or */
* /* commands will not result */
* /* in a value reset. */
* /* STCK format. */
FLD: QDSTEND LEN(1) DISP(120)
*******************************************************************
* QWOS DSNDQWOS * ZOS SYSTEM STATISTICS
*******************************************************************
***********************************************************************
**** QWOS DSECT
***********************************************************************
COMP: QWOS_OFFSET =
WHEN(SM100RTY=100 AND QWS00RDN > 0) ASSIGN(QWS00RDO)
ELSE ASSIGN(99999)
FLD: QWOS DISP(0) LEN(1) OFFSET(QWOS_OFFSET)
***********************************************************************
* IFCID 0001 - DATA SECTION QWS00RDO(Z/OS METRICS)
***********************************************************************
*
FLD: QWOSLNCP LEN(4) TYPE(BIN) DISP(0) /*NO OF CPS ON LPAR*/
FLD: QWOSLPRU LEN(4) TYPE(BIN) DISP(4) /*CPU UTILIZATION LPAR*/
FLD: QWOSDB2U LEN(4) TYPE(BIN) DISP(8) /*CPU UTILIZATION DB2 SUBSYS*/
FLD: QWOSMSTU LEN(4) TYPE(BIN) DISP(12) /*CPU UTILIZATION DB2 MSTR*/
FLD: QWOSDBMU LEN(4) TYPE(BIN) DISP(16) /*CPU UTILIZATION DB2 DBM1*/
FLD: QWOSLPIR LEN(4) TYPE(BIN) DISP(20) /*PAGE IN RATE LPAR*/
FLD: QWOSDPIR LEN(4) TYPE(BIN) DISP(24) /*PAGE IN RATE DB2 SUBSYS*/
FLD: QWOSLRST LEN(4) TYPE(BIN) DISP(28) /*REAL STORAGE ON LPAR IN MB*/
FLD: QWOSLRSF LEN(4) TYPE(BIN) DISP(32)
/*FREE REAL STORAGE LPAR IN MB*/
FLD: QWOSDRSU LEN(4) TYPE(BIN) DISP(36)
/*USED REAL STORAGE DB2 SUBSYS IN MB*/
FLD: QWOSLVST LEN(4) TYPE(BIN) DISP(40) /*VIRTUAL STORAGE LPAR IN MB*/
FLD: QWOSLVSF LEN(4) TYPE(BIN) DISP(44)
/*FREE VIRTUAL STORAGE LPAR IN MB*/
FLD: QWOSDVSU LEN(4) TYPE(BIN) DISP(48)
/*USED VIRTUAL STORAGE DB2 SUBSYS IN MB*/
FLD: QWOSLUIC LEN(4) TYPE(BIN) DISP(52)
/*UNREFERENCED INTERVAL COUNT @116*/
FLD: QWOSFLG LEN(1) DISP(56) /*(S) STATUS FLAG FOR RMF API @116*/
FLD: QWOSRCDE LEN(4) TYPE(BIN) DISP(60)
/*(S) RETURN CODE FROM RMF API @116*/
FLD: QWOSRSNC LEN(4) TYPE(BIN) DISP(64)
/*(S) REASON CODE from RMF API @116*/
FLD: QWOSEND LEN(1) DISP(68)
*
*******************************************************************
* QXST DSNDQXST * SQL STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQXST DSECT TABLE OF SQL STMT COUNTERS
***********************************************************************
COMP: QXST_OFFSET =
WHEN(SM100RTY=100 AND QWS10R1N > 0) ASSIGN(QWS10R1O)
ELSE ASSIGN(99999)
FLD: DSNDQXST DISP(0) LEN(1) OFFSET(QXST_OFFSET)
/*TABLE OF SQL STMT COUNTERS*/
FLD: QXST LEN(8) DISP(0) /*RDS ACCOUNTING AREA*/
FLD: QXHEAD LEN(4) TYPE(BIN) DISP(0) /*CONTROL BLOCK HEADER*/
FLD: QXID TYPE(HALF) DISP(0) /*CONTROL BLOCK ID*/
FLD: QXLEN TYPE(HALF) DISP(2) /*CONTROL BLOCK LENGTH*/
FLD: QXEYE LEN(4) DISP(4) /*CONTROL BLOCK EYE CATCHER*/
FLD: STMT LEN(8) DISP(8) /*OVERLAY ON QXSTATS*/
FLD: QXSTATS LEN(8) DISP(8) /*ACCOUNTING STATISTICS*/
FLD: QXSELECT LEN(8) TYPE(BIN) DISP(8) /*# OF SELECTS*/
FLD: QXINSRT LEN(8) TYPE(BIN) DISP(16) /*# OF INSERTS*/
FLD: QXUPDTE LEN(8) TYPE(BIN) DISP(24) /*# OF UPDATES*/
FLD: QXDELET LEN(8) TYPE(BIN) DISP(32) /*# OF DELETES*/
FLD: QXDESC LEN(8) TYPE(BIN) DISP(40) /*# OF DESCRIBES*/
FLD: QXPREP LEN(8) TYPE(BIN) DISP(48) /*# OF PREPARES*/
FLD: QXOPEN LEN(8) TYPE(BIN) DISP(56) /*# OF OPENS*/
FLD: QXCLOSE LEN(8) TYPE(BIN) DISP(64) /*# OF CLOSES*/
FLD: QXCRTAB LEN(8) TYPE(BIN) DISP(72) /*# OF CREATE TABLE*/
FLD: QXCRINX LEN(8) TYPE(BIN) DISP(80) /*# OF CREATE INDEX*/
FLD: QXCTABS LEN(8) TYPE(BIN) DISP(88) /*# OF CREATE TABLESPACE*/
FLD: QXCRSYN LEN(8) TYPE(BIN) DISP(96) /*# OF CREATE SYNONYM*/
FLD: QXCRDAB LEN(8) TYPE(BIN) DISP(104) /*# OF CREATE DATABASE*/
FLD: QXCRSTG LEN(8) TYPE(BIN) DISP(112) /*# OF CREATE STORAGE GROUP*/
FLD: QXDEFVU LEN(8) TYPE(BIN) DISP(120) /*# OF CREATE VIEW*/
FLD: QXDRPIX LEN(8) TYPE(BIN) DISP(128) /*# OF DROP INDEX*/
FLD: QXDRPTA LEN(8) TYPE(BIN) DISP(136) /*# OF DROP TABLE*/
FLD: QXDRPTS LEN(8) TYPE(BIN) DISP(144) /*# OF DROP TABLESPACE*/
FLD: QXDRPDB LEN(8) TYPE(BIN) DISP(152) /*# OF DROP DATABASE*/
FLD: QXDRPSY LEN(8) TYPE(BIN) DISP(160) /*# OF DROP SYNONYM*/
FLD: QXDRPST LEN(8) TYPE(BIN) DISP(168) /*# OF DROP STORAGE GROUP*/
FLD: QXDRPVU LEN(8) TYPE(BIN) DISP(176) /*# OF DROP VIEW*/
FLD: QXALTST LEN(8) TYPE(BIN) DISP(184) /*# OF ALTER STORAGE GROUP*/
FLD: QXFETCH LEN(8) TYPE(BIN) DISP(192) /*# OF FETCHS*/
FLD: QXALTTS LEN(8) TYPE(BIN) DISP(200) /*# OF ALTER TABLESPACE*/
FLD: QXALTTA LEN(8) TYPE(BIN) DISP(208) /*# OF ALTER TABLE*/
FLD: QXALTIX LEN(8) TYPE(BIN) DISP(216) /*# OF ALTER INDEX*/
FLD: QXCMTON LEN(8) TYPE(BIN) DISP(224) /*# OF COMMENT ON*/
FLD: QXLOCK LEN(8) TYPE(BIN) DISP(232) /*# OF LOCK TABLE*/
FLD: QXGRANT LEN(8) TYPE(BIN) DISP(240) /*# OF GRANT*/
FLD: QXREVOK LEN(8) TYPE(BIN) DISP(248) /*# OF REVOKE*/
FLD: QXINCRB LEN(8) TYPE(BIN) DISP(256)
/*# OF INCREMENTAL BINDS EXCLUDING PREPARES*/
FLD: QXLABON LEN(8) TYPE(BIN) DISP(264) /*# OF LABEL ON*/
FLD: QXSETSQL LEN(8) TYPE(BIN) DISP(272) /*# OF Set Current SQLID 1*/
FLD: QXCRALS LEN(8) TYPE(BIN) DISP(280) /*# OF CREATE ALIAS 2*/
FLD: QXDRPAL LEN(8) TYPE(BIN) DISP(288) /*# OF DROP ALIAS 2*/
FLD: QXMIAP LEN(8) TYPE(BIN) DISP(296)
/*# of times RID list processing used. This 9*/
* field is incremented once for a given 9
* table access for Index Access with list 9
* prefetch and for Multiple Index Access. 9
FLD: QXNSMIAP LEN(8) TYPE(BIN) DISP(304)
/*# of times a RID list was not used for 9*/
* a given RID list process involving one 9
* index (Index Access with list prefetch) 9
* or involving multiple indexes (Multiple 9
* Index Access) because no storage was 9
* available to hold the list of RIDs. 9
FLD: QXMRMIAP LEN(8) TYPE(BIN) DISP(312)
/*# of times one or more RID lists were not 9*/
* used for a given RID list process involving
* one indx (Index Access with list prefetch)9
* or involving multiple indexes (Multiple 9
* Index Access) because the number of RIDs 9
* exceeded one or more internal limits. 9
FLD: QXSETHV LEN(8) TYPE(BIN) DISP(320)
/*# OF Set Host Variable statements, we 6*/
* don't trace the contents of the special 6
* register. 6
FLD: QXALDAB LEN(8) TYPE(BIN) DISP(328) /*# OF ALTER DATABASE 7*/
FLD: QXDRPPKG LEN(8) TYPE(BIN) DISP(336)
/*# OF DROP PACKAGE STATEMENTS 8*/
FLD: QXDSCRTB LEN(8) TYPE(BIN) DISP(344)
/*# OF DESCRIBE TABLE STATEMENTS 8*/
FLD: QXMAXDEG LEN(8) DISP(352)
/*Maximum degree of parallelism among the A*/
* parallel groups to indicate the extent to A
* which query parallelism applies. A
FLD: QXTOTGRP LEN(8) TYPE(BIN) DISP(360)
/*Total number of parallel groups executed A*/
FLD: QXDEGCUR LEN(8) DISP(368)
/*Total number pf parallel groups which A*/
* fell back to sequential mode because the A
* cursor may be used in UPDATE/DELETE. A
FLD: QXDEGESA LEN(8) TYPE(BIN) DISP(376)
/*Total number of parallel groups which fellA*/
* back to sequential mode due to lack of A
* ESA sort support. A
FLD: QXDEGBUF LEN(8) TYPE(BIN) DISP(384)
/*Total number of parallel groups that have C*/
* a planned degree greater than one at run C
* time, but fell back to sequential mode C
* because of storage shortage or contention C
* on the buffer pool. C
FLD: QXREDGRP LEN(8) TYPE(BIN) DISP(392)
/*Total number of parallel groups that have C*/
* a planned degree greater than one at run C
* time, but were processed to a parallel C
* degree less than planned because of a C
* storage shortage or contention on the C
* buffer pool. C
FLD: QXNORGRP LEN(8) TYPE(BIN) DISP(400)
/*Total number of parallel groups that have C*/
* a planned degree greater than one at run C
* time, and were executed to the same degreeC
* because of sufficient storage on the C
* buffer pool. C
FLD: QXCON1 LEN(8) TYPE(BIN) DISP(408)
/*# of CONNECT type 1 statements executed B*/
FLD: QXCON2 LEN(8) TYPE(BIN) DISP(416)
/*# of CONNECT type 2 statements executed B*/
FLD: QXREL LEN(8) TYPE(BIN) DISP(424)
/*# of RELEASE statements executed B*/
FLD: QXSETCON LEN(8) TYPE(BIN) DISP(432)
/*# of SET CONNECTION statements executed B*/
FLD: QXSETCDG LEN(8) TYPE(BIN) DISP(440)
/*# of SET CURRENT DEGREE statements A*/
* executed
FLD: QXSETCRL LEN(8) TYPE(BIN) DISP(448)
/*# of SET CURRENT RULES statements D*/
FLD: QXCALL LEN(8) TYPE(BIN) DISP(456)
/*# of SQL CALL statements executed F*/
FLD: QXCALLAB LEN(8) TYPE(BIN) DISP(464)
/*# of times a stored procedure ABENDed F*/
FLD: QXCALLTO LEN(8) TYPE(BIN) DISP(472)
/*# of times an SQL CALL statement timed F*/
* out waiting to be scheduled F
FLD: QXCALLRJ LEN(8) TYPE(BIN) DISP(480)
/*# of times an SQL CALL statement was F*/
* rejected F
FLD: QXRLFDPA LEN(1) DISP(488)
/*If non zero, then Query Parallelism J*/
* is disabled by the RLF for at least one I
* dynamic SELECT statement in this thread. I
* See IFCID 0022 from a PREPARE statement I
* for detailed information at the statement I
* level. This field is for accounting I
* IFCID 0003 and does not apply to IFCID I
* 0002. I
FLD: QXCOORNO LEN(8) TYPE(BIN) DISP(496)
/*Total number of parallel groups executed K*/
* on a single DB2 due to the COORDINATOR K
* subsystem parameter being set to NO. K
* When the statement was bound, the K
* COORDINATOR subsystem parameter was K
* set to YES. This situation can also K
* occur when a plan or package is bound on K
* one DB2 where COORDINATOR=YES but is run K
* on a DB2 where COORDINATOR=NO. K
FLD: QXISORR LEN(8) TYPE(BIN) DISP(504)
/*Total number of parallel groups executed K*/
* on a single DB2 due to repeatable-read K
* or read-stability isolation. K
FLD: QXCRGTT LEN(8) TYPE(BIN) DISP(512)
/*# OF CREATE GLOBAL TEMPORARY TABLE M*/
FLD: QXSTREOP LEN(8) TYPE(BIN) DISP(520)
/*Total number of times reoptimization N*/
* occurs. This field does not apply to N
* IFCID 0002. N
FLD: QXXCBPNX LEN(8) TYPE(BIN) DISP(528)
/*Total number of parallel groups that were O*/
* intended to run across the data sharing O
* group. This count is only incremented on O
* the parallelism coordinator at run time. O
FLD: QXXCSKIP LEN(8) TYPE(BIN) DISP(536)
/*The number of times that the parallelism O*/
* coordinator had to bypass a DB2 when O
* distributing tasks because there was not O
* enough buffer pool storage on one or more O
* DB2 members. This field is incremented O
* only on the parallelism coordinator, and O
* it is only incremented once per parallel O
* group, even though it is possible that O
* more than one DB2 had a buffer pool O
* shortage for that parallel group. O
* The purpose of this count is to indicate O
* when there are not enough buffers on a O
* member. Therefore, this count is O
* incremented only when the buffer pool is O
* defined to allow parallelism. For O
* example, if VPXPSEQT = 0 on an assistant, O
* DB2 does not send parallel work there, butO
* this count is not incremented. O
FLD: QXALOCL LEN(8) TYPE(BIN) DISP(544)
/*Number of ASSOCIATE LOCATOR statements P*/
* executed P
FLD: QXALOCC LEN(8) TYPE(BIN) DISP(552)
/*Number of ALLOCATE CURSOR statements P*/
* statements executed P
FLD: QXSTFND LEN(8) TYPE(BIN) DISP(560)
/*The number of times a PREPARE request P*/
* was satisfied by making a copy from the P
* prepared statement cache P
FLD: QXSTNFND LEN(8) TYPE(BIN) DISP(568)
/*The number of times a PREPARE request P*/
* was received but a matching statement was P
* not found in the prepared statement P
* cache. Cache search is only done for P
* DML SQL and only if cache option is activeP
FLD: QXSTIPRP LEN(8) TYPE(BIN) DISP(576)
/*The number of times that an implicit P*/
* prepare was performed because the P
* KEEPDYNAMIC(YES) option was used and an P
* OPEN, EXECUTE or DESCRIBE of a dynamic P
* statement occurred after a COMMIT but P
* DB2 no longer had a valid copy of the P
* executable version of the prepared P
* statement P
FLD: QXSTNPRP LEN(8) TYPE(BIN) DISP(584)
/*The number of times that a prepare was P*/
* avoided because KEEPDYNAMIC(YES) was P
* used along with prepared statement P
* caching and DB2 still had the application P
* process' copy of the executable version P
* of the prepared statement P
FLD: QXSTDEXP LEN(8) TYPE(BIN) DISP(592)
/*The number of times that an application P*/
* process' executable copy of a prepared P
* statement was discarded due to the P
* MAXKEEPD system limit being exceeded P
FLD: QXSTDINV LEN(8) TYPE(BIN) DISP(600)
/*The number of times that a prepared P*/
* statement was purged from the cache P
* because a DROP, ALTER, or REVOKE P
* statement was issued on a dependent P
* object. P
FLD: QXRNTAB LEN(8) TYPE(BIN) DISP(608) /*# OF RENAME TABLE Q*/
FLD: QXCTRIG LEN(8) TYPE(BIN) DISP(616) /*# OF CREATE TRIGGER R*/
FLD: QXDRPTR LEN(8) TYPE(BIN) DISP(624) /*# OF DROP TRIGGER R*/
FLD: QXSETPTH LEN(8) TYPE(BIN) DISP(632)
/*# OF SET CURRENT PATH statements S*/
FLD: QXDRPFN LEN(8) TYPE(BIN) DISP(640)
/*# OF DROP USER DEFINED FUNCTION T*/
FLD: QXDRPPR LEN(8) TYPE(BIN) DISP(648) /*# OF DROP PROCEDURE T*/
FLD: QXCDIST LEN(8) TYPE(BIN) DISP(656)
/*# OF CREATE DISTINCT TYPE statements U*/
FLD: QXDDIST LEN(8) TYPE(BIN) DISP(664)
/*# OF DROP DISTINCT TYPE statements U*/
FLD: QXCRUDF LEN(8) TYPE(BIN) DISP(672)
/*# OF CREATE FUNCTION statements V*/
FLD: QXCRPRO LEN(8) TYPE(BIN) DISP(680)
/*# OF CREATE PROCEDURE statements c*/
FLD: QXHOLDL LEN(8) TYPE(BIN) DISP(688)
/*# OF HOLD LOCATOR statements W*/
FLD: QXFREEL LEN(8) TYPE(BIN) DISP(696)
/*# OF FREE LOCATOR statements W*/
FLD: QXREPOP1 LEN(8) TYPE(BIN) DISP(704)
/*Total number of parallel groups for which X*/
* DB2 reformulated the parallel portion of X
* the access path because the sysplex X
* configuration was different from the X
* sysplex configuration at bind time. X
* This counter is only incremented by the X
* parallelism coordinator at run time. X
FLD: QXREPOP2 LEN(8) TYPE(BIN) DISP(712)
/*Total number of parallel groups for which X*/
* DB2 reformulated the paralllel portion of X
* the access path because there was not X
* enough buffer pool resource. X
* This counter is only incremented by the X
* parallelism coordinator at run time. X
FLD: QXCRATB LEN(8) TYPE(BIN) DISP(720)
/*# OF CREATE AUX TABLE statements c*/
FLD: QXSTLOBV LEN(8) DISP(728) /*Max storage used for LOB values Y*/
* In KB for accounting, in MB for statisticsY
FLD: QXALUDF LEN(8) TYPE(BIN) DISP(736)
/*# OF ALTER FUNCTION statements Z*/
FLD: QXALPRO LEN(8) TYPE(BIN) DISP(744)
/*# OF ALTER PROCEDURE statements Z*/
FLD: QXROIMAT LEN(8) TYPE(BIN) DISP(752)
/*# of times that direct row access was a*/
* successful
FLD: QXROIIDX LEN(8) TYPE(BIN) DISP(760)
/*# of times an attempt to use direct row a*/
* access reverted to using an index to a
* locate a record
FLD: QXROITS LEN(8) TYPE(BIN) DISP(768)
/*# of times an attempt to use direct row a*/
* access reverted to using a table space a
* scan to locate a record
FLD: QXSTTRG LEN(8) TYPE(BIN) DISP(776)
/*# of times a statement trigger was b*/
* activated b
FLD: QXROWTRG LEN(8) TYPE(BIN) DISP(784)
/*# of times a row trigger was activated b*/
FLD: QXTRGERR LEN(8) TYPE(BIN) DISP(792)
/*# of times an SQL error occurred during b*/
* execution of a triggered action b
FLD: QXCASCDP LEN(8) DISP(800) /*The maximum level of nested SQL b*/
* cascading. This includes cascading b
* due to triggers, UDFs and stored b
* procedures. b
FLD: QXCAUD LEN(8) TYPE(BIN) DISP(808)
/*# of user defined functions executed d*/
FLD: QXCAUDAB LEN(8) TYPE(BIN) DISP(816) /*# of times a UDF ABENDed d*/
FLD: QXCAUDTO LEN(8) TYPE(BIN) DISP(824)
/*# of times a UDF timed out waiting to d*/
* be scheduled d
FLD: QXCAUDRJ LEN(8) TYPE(BIN) DISP(832)
/*# of times a UDF was rejected d*/
FLD: QXSETCPR LEN(8) DISP(840) /*# SET CURRENT PRECISION statements e*/
* executed e
FLD: QXDCLGTT LEN(8) TYPE(BIN) DISP(848)
/*# of DECLARE GLOBAL TEMPORARY TABLE stmts f*/
FLD: QXDEGDTT LEN(8) TYPE(BIN) DISP(856)
/*Total number of parallel groups that are f*/
* part of a query block using a UDF and f
* executed on a single DB2 due to f
* the existence of a Declared Temporary f
* Table in the application process. Neither f
* the query block nor the parallel group f
* references a Declared Temporary Table, andf
* a parallel group may or may not use a UDF.f
FLD: QXCRESEQ LEN(8) TYPE(BIN) DISP(864) /*# OF CREATE SEQUENCES*/
FLD: QXALTSEQ LEN(8) TYPE(BIN) DISP(872) /*# OF ALTER SEQUENCES*/
FLD: QXDROSEQ LEN(8) TYPE(BIN) DISP(880) /*# OF DROP SEQUENCES*/
FLD: QXPRRESI LEN(8) TYPE(BIN) DISP(888)
/*# of PREPAREs for which use of an i*/
* index/indexes were restricted because the i
* index was in a pending state. i
FLD: QXALTVW LEN(8) TYPE(BIN) DISP(896) /*# of ALTER VIEW j*/
FLD: QXALTJR LEN(8) TYPE(BIN) DISP(904) /*# OF ALTER JAR k*/
FLD: QXMERGE LEN(8) TYPE(BIN) DISP(912)
/*# OF times MERGE statement was executed m*/
FLD: QXTRTBL LEN(8) TYPE(BIN) DISP(920)
/*# of times TRUNCATE TABLE was executed n*/
FLD: QXCRROL LEN(8) TYPE(BIN) DISP(928) /*# OF CREATE ROLE o*/
FLD: QXDRPROL LEN(8) TYPE(BIN) DISP(936) /*# OF DROP ROLE o*/
FLD: QXCRCTX LEN(8) TYPE(BIN) DISP(944)
/*# OF CREATE TRUSTED CONTEXT o*/
FLD: QXALTCTX LEN(8) TYPE(BIN) DISP(952)
/*# OF ALTER TRUSTED CONTEXT o*/
FLD: QXDRPCTX LEN(8) TYPE(BIN) DISP(960)
/*# OF DROP TRUSTED CONTEXT o*/
FLD: QXRNIX LEN(8) TYPE(BIN) DISP(968) /*# OF RENAME INDEX u*/
FLD: QXSTXMLV LEN(8) DISP(976) /*# Max storage used for XML values q*/
FLD: QXRWSFETCHD LEN(8) TYPE(BIN) DISP(984)
/*# Number of Rows Fetched r*/
FLD: QXRWSINSRTD LEN(8) TYPE(BIN) DISP(992)
/*# Number of Rows Inserted r*/
FLD: QXRWSUPDTD LEN(8) TYPE(BIN) DISP(1000)
/*# Number of Rows Updated r*/
FLD: QXRWSDELETD LEN(8) TYPE(BIN) DISP(1008)
/*# Number of Rows Deleted r*/
FLD: QXSTCWLP LEN(8) TYPE(BIN) DISP(1016)
/*# of times DB2 parsed dynamic statements t*/
* because CONCENTRATE STATEMENTS WITH t
* LITERALS behavior was in effect for t
* the prepare of the statement for t
* the dynamic statement cache t
FLD: QXSTCWLR LEN(8) TYPE(BIN) DISP(1024)
/*# of times DB2 replaced at least one t*/
* literal in a dynamic statement because t
* CONCENTRATE STATEMENTS WITH LITERALS t
* was in effect for the prepare of t
* the statement for dynamic statement cache t
FLD: QXSTCWLM LEN(8) TYPE(BIN) DISP(1032)
/*# of times DB2 found a matching reusable t*/
* copy of a dynamic statement in statement t
* cache during prepare of a statement that t
* had literals replaced because of t
* CONCENTRATE STATEMENTS WITH LITERALS t
FLD: QXSTCWLD LEN(8) TYPE(BIN) DISP(1040)
/*# of times DB2 created a duplicate stmt t*/
* instance in the the statement cache for t
* a dynamic statement that had literals t
* replaced by CONCENTRATE STATEMENTS WITH t
* LITERALS behavior and the duplicate stmt t
* instance was needed because a cache t
* match failed solely due to literal t
* reusability criteria t
FLD: QXPFSLNUM LEN(8) DISP(1048) /*(S) v*/
FLD: QXPFSENUM LEN(8) DISP(1056) /*(S) v*/
FLD: QXPFSENUMG LEN(8) DISP(1064) /*(S) v*/
FLD: QXPFMAXU LEN(8) DISP(1072) /*(S) v*/
FLD: QXPFMAXUG LEN(8) DISP(1080) /*(S) v*/
FLD: QXWFRIDS LEN(8) TYPE(BIN) DISP(1088)
/*# of times a RID list was overflown to a w*/
* work file because no RIDPOOL storage was w
* available to hold the list of RIDs. w
FLD: QXWFRIDT LEN(8) TYPE(BIN) DISP(1096)
/*# of times a RID list was overflown to a w*/
* work file because the number of RIDs w
* exceeded one or more internal limits. w
FLD: QXHJINCS LEN(8) TYPE(BIN) DISP(1104)
/*# of times a RID list append for a Hybrid w*/
* Join was interrupted because no RIDPOOL w
* storage was available to hold the list of w
* RIDs (i.e. number of times DB2 w
* interrupted the RID phase and switched to w
* the Data phase). w
FLD: QXHJINCT LEN(8) TYPE(BIN) DISP(1112)
/*# of times a RID list append for a Hybrid w*/
* Join was interrupted because the number w
* of RIDs exceeded one or more internal w
* limits (i.e. number of times DB2 w
* interrupted the RID phase and switched to w
* the Data phase). w
FLD: QXRSMIAP LEN(8) TYPE(BIN) DISP(1120)
/*# of times a RID list retrieval for w*/
* multiple index access was skipped because w
* it was not necessary due to DB2 being w
* able to predetermine the outcome of index w
* ANDing or ORing. w
FLD: QXCREMP LEN(8) TYPE(BIN) DISP(1128)
/*# OF CREATE MASK OR PERMISSION x*/
FLD: QXDRPMP LEN(8) TYPE(BIN) DISP(1136)
/*# OF DROP MASK OR PERMISSION x*/
FLD: QXALTMP LEN(8) TYPE(BIN) DISP(1144)
/*# OF ALTER MASK OR PERMISSION x*/
FLD: QXSTEND LEN(8) DISP(1152) /*END OF RDS ACCOUNTING AREA*/
*******************************************************************
* QTST DSNDQTST * SERVICE CONTROLLER STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQTST DSECT TABLE OF SCC COUNTERS
***********************************************************************
COMP: QTST_OFFSET =
WHEN(SM100RTY=100 AND QWS10R2N > 0) ASSIGN(QWS10R2O)
ELSE ASSIGN(99999)
FLD: DSNDQTST DISP(0) LEN(1) OFFSET(QTST_OFFSET)
/*TABLE OF SCC COUNTERS*/
FLD: QTST LEN(8) DISP(0)
FLD: QTHEAD LEN(4) TYPE(BIN) DISP(0) /*CONTROL BLOCK HEADER*/
FLD: QTID TYPE(HALF) DISP(0) /*CONTROL BLOCK ID*/
FLD: QTLEN TYPE(HALF) DISP(2) /*CONTROL BLOCK LENGTH*/
FLD: QTEYE LEN(4) DISP(4) /*CONTROL BLOCK EYE CATCHER*/
FLD: QTSTATS LEN(4) TYPE(BIN) DISP(8) /*STATISTICS*/
FLD: QTALLOCA LEN(4) TYPE(BIN) DISP(8) /*ALLOCATION ATTEMPTS*/
FLD: QTALLOC LEN(4) TYPE(BIN) DISP(12) /*SUCCESSFUL ALLOCATIONS*/
FLD: QTABINDA LEN(4) TYPE(BIN) DISP(16) /*AUTOMATIC BIND ATTEMPTS*/
FLD: QTABIND LEN(4) TYPE(BIN) DISP(20) /*SUCCESSFUL AUTOMATIC BINDS*/
FLD: QTINVRID LEN(4) TYPE(BIN) DISP(24) /*INVALID RESOURCE IDS*/
FLD: QTBINDA LEN(4) TYPE(BIN) DISP(28) /*BIND (ADD) SUB COMMANDS*/
FLD: QTBINDR LEN(4) TYPE(BIN) DISP(32) /*BIND (REPLACE) SUB COMMANDS*/
FLD: QTTESTB LEN(4) TYPE(BIN) DISP(36) /*TEST BINDS (NO PLAN ID)*/
FLD: QTPLNBD LEN(4) TYPE(BIN) DISP(40) /*PLANS BOUND*/
FLD: QTREBIND LEN(4) TYPE(BIN) DISP(44) /*REBIND SUB COMMANDS*/
FLD: QTRBINDA LEN(4) TYPE(BIN) DISP(48) /*ATTEMPTS TO REBIND A PLAN*/
FLD: QTPLNRBD LEN(4) TYPE(BIN) DISP(52) /*PLANS REBOUND*/
FLD: QTFREE LEN(4) TYPE(BIN) DISP(56) /*FREE SUB COMMANDS*/
FLD: QTFREEA LEN(4) TYPE(BIN) DISP(60) /*ATTEMPTS TO FREE A PLAN*/
FLD: QTPLNFRD LEN(4) TYPE(BIN) DISP(64) /*PLANS FREED*/
FLD: QTAUCHK LEN(4) TYPE(BIN) DISP(68)
/*TOTAL NUMBER OF AUTHORIZATION CHECKS*/
FLD: QTAUSUC LEN(4) TYPE(BIN) DISP(72)
/*TOTAL NUMBER OF SUCCESSFUL AUTH*/
* CHECKS
FLD: QTDSOPN LEN(4) TYPE(BIN) DISP(76)
/*NUMBER OF DATASETS CURRENTLY OPEN*/
FLD: QTMAXDS LEN(4) TYPE(BIN) DISP(80)
/*MAXIMUM NUMBER OF DS OPENED CONCUR*/
FLD: QTAUCCH LEN(4) TYPE(BIN) DISP(84)
/*#SUCCESSFUL AUTH CHECKS FOR PLANS*/
* USING A PLAN CACHE OR PUBLIC AUTH
* CHECK (QTAUPUB)
FLD: QTAUPUB LEN(4) TYPE(BIN) DISP(88)
/*#SUCCESSFUL AUTH CHECKS FOR PLAN*/
* EXECUTE AUTHORITY HELD BY PUBLIC
FLD: QTMAXPB LEN(4) TYPE(BIN) DISP(92)
/*MAXIMUM NOT IN USE DATA SETS*/
FLD: QTPACAUT LEN(4) TYPE(BIN) DISP(96)
/*#SUCCESSFUL AUTH CHECKS FOR PACKAGES*/
* USING THE PACKAGE AUTH CACHE--
* INCLUDES PUBLIC AUTH CHECKS
* (QTPACPUB)
FLD: QTPACPUB LEN(4) TYPE(BIN) DISP(100)
/*#SUCCESSFUL AUTH CHECKS FOR PACKAGE*/
* EXECUTE AUTHORITY HELD BY PUBLIC
FLD: QTPACNOT LEN(4) TYPE(BIN) DISP(104)
/*#PACKAGE AUTH CHECKS THAT COULD NOT*/
* MAKE USE OF THE PACKAGE AUTH CACHE
FLD: QTREOPN LEN(4) TYPE(BIN) DISP(108)
/*# OF TIMES THAT NOT IN USE OPEN*/
* DATA SETS BECAME IN-USE
FLD: QTPACOW1 LEN(4) TYPE(BIN) DISP(112)
/*# OF TIMES DB2 OVERWROTE AN AUTHID*/
* IN THE PACKAGE AUTH CACHE
FLD: QTPACOW2 LEN(4) TYPE(BIN) DISP(116)
/*# OF TIMES DB2 OVERWROTE A PACKAGE*/
* ENTRY IN THE PACKAGE AUTH CACHE
FLD: QTDSDRN LEN(4) TYPE(BIN) DISP(124)
/*# OF NOT IN USE DATA SETS CLOSED*/
* DUE TO DSMAX/DD LIMIT
FLD: QTPCCT LEN(4) TYPE(BIN) DISP(128)
/*# OF INFREQUENTLY UPDATED DATA*/
* SETS THAT ARE CONVERTED FROM
* R/W TO R/O STATE
FLD: QTSLWDD LEN(4) TYPE(BIN) DISP(132)
/*# OF DATA SETS THAT ARE NOT*/
* IN-USE, BUT ARE NOT CLOSED
FLD: QTBINDPA LEN(4) TYPE(BIN) DISP(136)
/*BIND (ADD) PACKAGE SUB COMMANDS*/
FLD: QTBINDPR LEN(4) TYPE(BIN) DISP(140)
/*BIND (REP) PACKAGE SUB COMMANDS*/
FLD: QTPKGBD LEN(4) TYPE(BIN) DISP(144) /*# PACKAGES BOUND*/
FLD: QTRBINDP LEN(4) TYPE(BIN) DISP(148)
/*REBIND PACKAGE SUB COMMANDS*/
FLD: QTRBNDPA LEN(4) TYPE(BIN) DISP(152)
/*ATTEMPTS TO REBIND A PACKAGE*/
FLD: QTPKGRBD LEN(4) TYPE(BIN) DISP(156) /*# PACKAGES REBOUND*/
FLD: QTFREEP LEN(4) TYPE(BIN) DISP(160) /*FREE PACKAGE SUB COMMANDS*/
FLD: QTFREEAP LEN(4) TYPE(BIN) DISP(164) /*ATTEMPTS TO FREE A PACKAGE*/
FLD: QTPKGFRD LEN(4) TYPE(BIN) DISP(168) /*# PACKAGES FREED*/
FLD: QTAUTOBA LEN(4) TYPE(BIN) DISP(172)
/*ATTEMPTS TO AUTOBIND A PACKAGE*/
FLD: QTPKABND LEN(4) TYPE(BIN) DISP(176) /*# PACKAGES AUTOBOUND*/
FLD: QTPKALLA LEN(4) TYPE(BIN) DISP(180)
/*ATTEMPTS TO ALLOCATE A PACKAGE*/
FLD: QTPKALL LEN(4) TYPE(BIN) DISP(184) /*# PACKAGES ALLOCATED*/
FLD: QTRACAUT LEN(4) TYPE(BIN) DISP(200)
/*#SUCCESSFUL AUTH CHECKS FOR ROUTINES*/
* USING THE ROUTINE AUTH CACHE--
* INCLUDES PUBLIC AUTH CHECKS
* (QTRACPUB)
FLD: QTRACPUB LEN(4) TYPE(BIN) DISP(204)
/*#SUCCESSFUL AUTH CHECKS FOR ROUTINE*/
* EXECUTE AUTHORITY HELD BY PUBLIC
FLD: QTRACNOT LEN(4) TYPE(BIN) DISP(208)
/*#ROUTINE AUTH CHECKS THAT COULD NOT*/
* MAKE USE OF THE ROUTINE AUTH CACHE
FLD: QTRACOW1 LEN(4) TYPE(BIN) DISP(212)
/*# OF TIMES DB2 OVERWROTE AN AUTHID*/
* IN THE ROUTINE AUTH CACHE
FLD: QTRACOW2 LEN(4) TYPE(BIN) DISP(216)
/*# OF TIMES DB2 OVERWROTE A ROUTINE*/
* ENTRY IN THE ROUTINE AUTH CACHE
FLD: QTRACNAC LEN(4) TYPE(BIN) DISP(220)
/*# OF TIMES DB2 WAS NOT ABLE TO ADD*/
* AN ENTRY TO THE ROUTINE AUTH CACHE
FLD: QTSTEND LEN(4) TYPE(BIN) DISP(256)
*******************************************************************
* QBST DSNDQBST * BUFFER MANAGER STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQBST DSECT
***********************************************************************
COMP: QBST_OFFSET =
WHEN(SM100RTY=100 AND QWS10R3N > 0) ASSIGN(QWS10R3O)
ELSE ASSIGN(99999)
FLD: DSNDQBST DISP(0) LEN(1) OFFSET(QBST_OFFSET)
FLD: QBST LEN(8) DISP(0)
FLD: QBSTPID LEN(4) TYPE(BIN) DISP(0) /*BUFFER POOL ID*/
FLD: QBSTFLG LEN(1) DISP(4) /*FLAGS*/
COMP: QBSTCON = X'80' /*1 MORE QBST DATA WILL FOLLOW*/
FLD: QBSTGET LEN(8) TYPE(BIN) DISP(8)
/*# OF GET PAGE REQUESTS. INCLUDES BOTH*/
* CONDITIONAL AND NON-CONDITIONAL,
* SUCCESSFUL AND UNSUCCESSFUL REQUESTS
FLD: QBSTRIO LEN(8) TYPE(BIN) DISP(16)
/*# OF SYNC. READ I/O OPERATIONS PERFORMED*/
FLD: QBSTDWV LEN(8) TYPE(BIN) DISP(24)
/*# OF TIMES VERTICAL DEFERRED WRITE*/
* THRESHOLD REACHED
FLD: QBSTXFL LEN(8) TYPE(BIN) DISP(32)
/*# OF GETPAGE FAILURES DUE TO VPOOL FULL*/
FLD: QBSTXFV LEN(8) TYPE(BIN) DISP(40)
/*# OF EXPANSION FAILURE DUE TO SHORTAGE OF*/
* VIRTUAL STORAGE
FLD: QBSTSWS LEN(8) TYPE(BIN) DISP(48)
/*# OF SETW ISSUED FOR SYSTEM PAGES*/
FLD: QBSTPWS LEN(8) TYPE(BIN) DISP(56)
/*# OF PAGE WRITES FOR SYSTEM PAGES*/
FLD: QBSTWIO LEN(8) TYPE(BIN) DISP(64)
/*# OF ASYNC. WRITE I/O OPERATIONS PERFORMED*/
FLD: QBSTCBA LEN(8) TYPE(BIN) DISP(72) /*# OF CURRENT ACTIVE BUFFERS*/
FLD: QBSTRPI LEN(8) TYPE(BIN) DISP(80)
/*# OF PAGE IN REQUIRED FOR READ I/O*/
FLD: QBSTWPI LEN(8) TYPE(BIN) DISP(88)
/*# OF PAGE IN REQUIRED FOR WRITE I/O*/
FLD: QBSTDSO LEN(8) TYPE(BIN) DISP(96)
/*# OF DATA SETS OPENED SUCCESSFULLY*/
FLD: QBSTIMW LEN(8) TYPE(BIN) DISP(104)
/*# OF IMMED (SYNCHRONOUS) WRITE I/OS*/
FLD: QBSTSEQ LEN(8) TYPE(BIN) DISP(112)
/*# OF SEQ PREFETCH REQUESTED*/
FLD: QBSTSPP LEN(8) TYPE(BIN) DISP(120)
/*# OF PAGE READ DUE TO SEQ PREFETCH*/
FLD: QBSTSPD LEN(8) TYPE(BIN) DISP(128)
/*# OF SEQ PREFETCH DISABLED DUE TO*/
* UNAVAILABLE BUFFER RESOURCES
FLD: QBSTREE LEN(8) TYPE(BIN) DISP(136)
/*# OF SEQ PREFETCH DISABLED DUE TO*/
* UNAVAILABLE READ ENGINE
FLD: QBSTDWT LEN(8) TYPE(BIN) DISP(144)
/*# OF TIMES THAT DEFERRED WRITE THRESHOLD*/
* IS REACHED
FLD: QBSTDMC LEN(8) TYPE(BIN) DISP(152)
/*# OF TIMES THAT THE DATA MANAGER BUFFER*/
* CRITICAL THRESHOLD HAS BEEN REACHED
FLD: QBSTMIG LEN(8) TYPE(BIN) DISP(160)
/*# OF TIMES THAT MIGRATED DATA SETS*/
* ENCOUNTERED
FLD: QBSTRTO LEN(8) TYPE(BIN) DISP(168) /*# OF RECALL TIMEOUTS*/
FLD: QBSTPIO LEN(8) TYPE(BIN) DISP(176)
/*# OF SEQ PREFETCH (ASYNCHRONOUS) READ I/OS*/
FLD: QBSTWKPD LEN(8) TYPE(BIN) DISP(184)
/*# OF WK PREFETCH ABORTED DUE TO A ZERO*/
* PREFETCH QUANTITY
FLD: QBSTMAX LEN(8) TYPE(BIN) DISP(192)
/*# OF WK FILE CANNOT BE CREATED DUE TO*/
* INSUFFICIENT BUFFER RESOURCES
FLD: QBSTWFM LEN(8) DISP(200)
/*MAXIMUM WORKFILES EVER BEEN ALLOCATED*/
* DURING THE SORT/MERGE PROCESSING
FLD: QBSTWDRP LEN(8) TYPE(BIN) DISP(208)
/*# OF PAGES FOR WHICH DESTRUCTIVE READ WAS*/
* REQUESTED
FLD: QBSTWBVQ LEN(8) TYPE(BIN) DISP(216)
/*# OF PAGES DEQUEUED FROM DATA SET DEFERRED*/
* WRITE QUEUE FOR DESTRUCTIVE READ REQUEST
FLD: QBSTWFR LEN(8) DISP(224)
/*COUNT OF REQUESTS TO QUERY FOR WORFILES*/
* IN THE PROCESS OF SORT/MERGE
FLD: QBSTWFT LEN(8) DISP(232)
/*SUM OF WORKFILES THAT HAVE BEEN REQUESTED*/
* DURING THE SORT/MERGE PROCESSING
FLD: QBSTWFD LEN(8) DISP(240)
/*SUM OF WORKFILES THAT HAVE BEEN DENIED*/
* DURING THE SORT/MERGE PROCESSING
FLD: QBSTWFF LEN(8) TYPE(BIN) DISP(248)
/*# OF TIMES SORT/MERGE COULD NOT BE*/
* EFFICIENTLY PERFORMED DUE TO THE BUFFER
* SHORTAGE
FLD: QBSTLPF LEN(8) TYPE(BIN) DISP(256)
/*# OF LIST PREFETCH REQUESTED*/
* CONCURRENT PREFETCH AGAINST SAME PAGESET
FLD: QBSTDPF LEN(8) TYPE(BIN) DISP(264)
/*# OF DYNAMIC PREFETCH REQUESTED*/
FLD: QBSTVPA LEN(8) TYPE(BIN) DISP(272)
/*# OF SUCCESSFUL VPOOL EXP/CONTRATION*/
FLD: QBSTPCO LEN(8) TYPE(BIN) DISP(280)
/*# OF PG on 'unlock castout'*/
FLD: QBSTCIO LEN(8) TYPE(BIN) DISP(288) /*# OF I/O on castout*/
FLD: QBSTVPL LEN(8) TYPE(BIN) DISP(296)
/*# OF BUFFERS ALLOCATED FOR VIRTUAL POOL*/
FLD: QBSTDPP LEN(8) TYPE(BIN) DISP(304)
/*# OF PAGE READ DUE TO DYNAMIC PREFETCH*/
FLD: QBSTLPP LEN(8) TYPE(BIN) DISP(312)
/*# OF PAGE READ DUE TO LIST PREFETCH*/
FLD: QBSTDIO LEN(8) TYPE(BIN) DISP(320)
/*# OF DYNAMIC PREFETCH (ASYNCHRONOUS)*/
* READ I/OS
FLD: QBSTLIO LEN(8) TYPE(BIN) DISP(328)
/*# OF LIST PREFETCH (ASYNCHRONOUS) READ I/O*/
FLD: QBSTSGT LEN(8) TYPE(BIN) DISP(336)
/*# OF GET PAGE ISSUED BY SEQUENTIAL REQUEST*/
FLD: QBSTSIO LEN(8) TYPE(BIN) DISP(344)
/*# OF SYNC. READ I/O OPERATIONS PERFORMED*/
* BY SEQUENTIAL REQUESTS
FLD: QBSTNGT LEN(8) TYPE(BIN) DISP(352)
/*# OF UNSUCCESSFUL GETPAGE DUE TO CONDI*/
* TIONAL GETPAGE REQUEST
FLD: QBSTXIS LEN(8) DISP(360)
/*HIGHEST PREFETCH I/O STREAMS HAVE EVER BEEN*/
* ALLOCATED
FLD: QBSTJIS LEN(8) TYPE(BIN) DISP(368)
/*# OF PREFETCH I/O STREAMS HAVE BEEN DENIED*/
* DUE TO THE SHORTAGE OF BUFFERPOOL
* FOR EXAMPLE, IF 100 PREFETCH I/O STREAMS
* ARE REQUESTED AND ONLY 80 ARE GRANTED,
* THEN 20 WILL BE ADDED TO THIS COUNTER.
FLD: QBSTPQO LEN(8) TYPE(BIN) DISP(376)
/*TOTAL # OF NEGOTIATIONS BETWEEN BM AND RDS*/
* RUNTIME TO SUPPORT PARALLELISM
FLD: QBSTPQF LEN(8) TYPE(BIN) DISP(384)
/*# OF TIMES PARALLELISM HAS BEEN DOWN*/
* GRADED DUE TO THE SHORTAGE OF BUFFERPOOL
FLD: QBSTPL1 LEN(8) TYPE(BIN) DISP(392)
/*TOTAL # OF OCCURRENCES WHEN PREFETCH QTY*/
* DECREASED FROM NORMAL TO HALF OF NORMAL.
* NORMAL IS BASED ON THE BUFFER POOL SIZE
FLD: QBSTPL2 LEN(8) TYPE(BIN) DISP(400)
/*TOTAL # OF OCCURRENCES WHEN PREFETCH QTY*/
* DECREASED FROM HALF OF NORMAL TO
* ONE QUARTER OF NORMAL. NORMAL IS
* BASED ON THE BUFFER POOL SIZE.
FLD: QBSTNSG LEN(8) TYPE(BIN) DISP(408)
/*# OF CONDITIONAL SEQUENTIAL GETPAGE*/
* REQUESTS WHICH FAILED BECAUSE THE
* PAGE WAS NOT IN THE BUFFER POOL.
FLD: QBSTLPL LEN(8) TYPE(BIN) DISP(448)
/*# of times one or more pages were*/
* added to LPL
FLD: QBSTEND LEN(4) TYPE(BIN) DISP(456)
*******************************************************************
* QIST DSNDQIST * DATA MANAGER STATISTICS - V2R2
*******************************************************************
***********************************************************************
**** DSNDQIST DSECT TABLE OF SCC COUNTERS
***********************************************************************
COMP: QIST_OFFSET =
WHEN(SM100RTY=100 AND QWS10R4N > 0) ASSIGN(QWS10R4O)
ELSE ASSIGN(99999)
FLD: DSNDQIST DISP(0) LEN(1) OFFSET(QIST_OFFSET)
/*TABLE OF SCC COUNTERS*/
FLD: QIST LEN(8) DISP(0)
FLD: QIID LEN(2) DISP(0) /*CONTROL BLOCK ID*/
FLD: QILEN TYPE(HALF) DISP(2) /*CONTROL BLOCK LENGTH*/
FLD: QIEYE LEN(4) DISP(4) /*CONTROL BLOCK EYE CATCHER*/
FLD: QISTATS LEN(4) TYPE(BIN) DISP(8) /*STATISTICS*/
FLD: QISTRLLM LEN(4) TYPE(BIN) DISP(8) /*THE NUMBER OF TIMES RID*/
* /* LIST PROCESSING TERMINATED */
* /* BECAUSE THE NUMBER OF RID */
* /* ENTRIES WAS GREATER THAN */
* /* THE RDS LIMIT. THE RDS */
* /* LIMIT IS THE MAX(25% OF */
* /* TABLE SIZE, NUMBER OF RIDS */
* /* THAT CAN FIT INTO THE */
* /* GUARANTEED NUMBER OF RID */
* /* BLOCKS. */
FLD: QISTRPLM LEN(4) TYPE(BIN) DISP(12) /*THE NUMBER OF TIMES RID*/
* /* LIST PROCESSING TERMINATED */
* /* BECAUSE THE NUMBER OF RID */
* /* ENTRIES WAS GREATER THAN */
* /* THE DM LIMIT. THE DM */
* /* LIMIT IS APPROXIMATELY */
* /* 26 MILLION RIDS. */
FLD: QISTRHAC LEN(8) DISP(16) /*DOUBLE WORD CONTAINING*/
* /* BOTH QISTRHIG AND QISTRCUR */
* /* NOTE:QISTRHIG AND QISTRCUR */
* /* MUST REMAIN IN CONTIGUOUS */
* /* MEMORY AND ON A DOUBLE */
* /* WORD BOUNDARY */
FLD: QISTRHIG LEN(4) TYPE(BIN) DISP(16) /*HIGHEST NUMBER OF RID*/
* /* BLOCKS IN USE AT ANY ONE */
* /* TIME SINCE DB2 STARTUP TIME*/
FLD: QISTRCUR LEN(4) TYPE(BIN) DISP(20) /*NUMBER OF RID BLOCKS*/
* /* CURRENTLY IN USE. */
FLD: QISTRSTG LEN(4) TYPE(BIN) DISP(24) /*NUMBER OF TIMES RID LIST*/
* /* PROCESSING EXHAUSTED */
* /* VIRTUAL STORAGE */
FLD: QISTRMAX LEN(4) TYPE(BIN) DISP(28) /*NUMBER OF TIMES THE MAXIMUM*/
* /* RID POOL STORAGE WAS */
* /* EXCEEDED. THE DEFAULT */
* /* MAXIMUM RID POOL SIZE IS */
* /* THE MIN(install value, */
* /* 10GB). */
*/*--------------------------------------------------------------*/
*/* Total number of columns (rows x columns) */
*/* for which a Select Procedure was bypassed */
*/* because the Select Procedure was invalidated */
*/* by applying service to DB2. */
*/* Everything will continue to function */
*/* correctly, but with some degradation in */
*/* performance. */
*/* To obtain optimum performance, whenever this */
*/* counter is not zero, rebind any affected */
*/* plans or packages. */
*/*--------------------------------------------------------------*/
FLD: QISTCOLS LEN(4) TYPE(BIN) DISP(32) /*Total number of columns*/
FLD: QISTWFNE LEN(4) TYPE(BIN) DISP(52) /*Number of times the maximum*/
* /* allowable storage usage */
* /* limit was exceeded */
FLD: QISTWFP1 LEN(4) TYPE(BIN) DISP(72) /*How many times a 32KB page*/
* /* TS was used when a 4KB */
* /* page TS was preferable */
* /* (but was not available) */
FLD: QISTWFP2 LEN(4) TYPE(BIN) DISP(76) /*How many times a 4KB page*/
* /* TS was used when a 32KB */
* /* page TS was preferable */
* /* (but was not available) */
FLD: QISTRCCI LEN(4) TYPE(BIN) DISP(80) /*RCCI: Read Currently*/
* /* Committed Insert */
* /* How many rows skipped by */
* /* read transaction due to */
* /* uncommitted insert when */
* /* using Currently Committed */
* /* semantic for fetch. */
FLD: QISTRCCD LEN(4) TYPE(BIN) DISP(84) /*RCCD: Read Currently*/
* /* Committed Delete */
* /* How many rows accessed by */
* /* read transaction due to */
* /* uncommitted delete when */
* /* using Currently Committed */
* /* semantic for fetch. */
FLD: QISTRCCU LEN(4) TYPE(BIN) DISP(88) /*RCCU: Read Currently*/
* /* Committed Update */
* /* How many rows accessed by */
* /* read transaction due to */
* /* uncommitted update when */
* /* using Currently Committed */
* /* semantic for fetch. */
FLD: QISTWMXA LEN(8) DISP(96) /*Maximum allowable storage @219*/
* /* usage limit per agent (KB) @219*/
* /* (MAXTEMPS zparm value) @219*/
* /* Equivalent in V9 was @219*/
* /* QISTWFMX @219*/
FLD: QISTWMXU LEN(8) DISP(104) /*Maximum total storage ever @219*/
* /* used in workfile db (KB) @219*/
* /* (starts as 0 on restart) @219*/
* /* Equivalent in V9 was @219*/
* /* QISTWFMU @219*/
FLD: QISTWCTO LEN(8) DISP(112) /*Current total storage used @219*/
* /* in workfile DB (KB) @219*/
* /* Equivalent in V9 was @219*/
* /* QISTWFCU/QISTWFCK pair @219*/
FLD: QISTW4K LEN(8) DISP(120) /*Current 4KB table space @219*/
* /* storage used (KB) @219*/
* /* Equivalent in V9 was @219*/
* /* QISTWF04/QISTW04K pair @219*/
FLD: QISTW32K LEN(8) DISP(128) /*Current 32KB table space @219*/
* /* storage used (KB) @219*/
* /* Equivalent in V9 was @219*/
* /* QISTWF32/QISTW32K pair @219*/
FLD: QISTIMAC LEN(8) DISP(136) /*How many DM In Memory work @wf1*/
* /* files are Active Currently.@wf1*/
FLD: QISTIMSC LEN(8) DISP(144) /*Total Space used for the @wf1*/
* /* Currently-Active DM In-Mem @wf1*/
* /* workfiles, in KBs. @wf1*/
FLD: QISTIMAH LEN(8) DISP(152) /*High watermark count of @wf1*/
* /* maximum number DM In-Memory@wf1*/
* /* workfiles Active @wf1*/
* /* at any point in time @wf1*/
* /* since DB2 came up. @wf1*/
FLD: QISTIMSH LEN(8) DISP(160) /*High watermark count of @wf1*/
* /* maximum Space used for the @wf1*/
* /* active DM In-Mem workfiles @wf1*/
* /* at any point in time @wf1*/
* /* since DB2 came up, in KBs. @wf1*/
FLD: QISTSIAC LEN(8) DISP(168) /*How many Sort Inmem work @wf1*/
* /* files are Active Currently.@wf1*/
FLD: QISTSISC LEN(8) DISP(176) /*Total Space used for the @wf1*/
* /* Currently-active Sort-Inmem@wf1*/
* /* workfiles, in bytes. @wf1*/
FLD: QISTSIAH LEN(8) DISP(184) /*High watermark count of @wf1*/
* /* maximum number Sort-Inmem @wf1*/
* /* workfiles Active @wf1*/
* /* at any point in time @wf1*/
* /* since DB2 came up. @wf1*/
FLD: QISTSISH LEN(8) DISP(192) /*High watermark count of @wf1*/
* /* maximum Space used for the @wf1*/
* /* active Sort-Inmem workfiles@wf1*/
* /* at any point in time @wf1*/
* /* since DB2 came up, in bytes@wf1*/
FLD: QISTWFRHIG LEN(8) TYPE(BIN) DISP(200)
/*Highest # of RID blocks @353*/
* /* overflown(stored) to a work@353*/
* /* file at any time since DB2 @353*/
* /* startup. This is a high- @353*/
* /* water mark. @353*/
FLD: QISTWFRCUR LEN(8) TYPE(BIN) DISP(208)
/*# of RID blocks currently @353*/
* /* residing in work file @353*/
* /* storage. This is a @353*/
* /* snapshot value. @353*/
FLD: QISTEND LEN(4) TYPE(BIN) DISP(280)
*******************************************************************
* QTXA DSNDQTXA * LOCKING STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQTXA DSECT
***********************************************************************
COMP: QTXA_OFFSET =
WHEN(SM100RTY=100 AND QWS10R5N > 0) ASSIGN(QWS10R5O)
ELSE ASSIGN(99999)
FLD: DSNDQTXA DISP(0) LEN(1) OFFSET(QTXA_OFFSET)
FLD: QTXA LEN(8) DISP(0)
FLD: QTXADEA LEN(4) TYPE(BIN) DISP(0) /*Deadlock count*/
FLD: QTXASLOC LEN(4) TYPE(BIN) DISP(4)
/*Number of suspends because of*/
* lock conflicts
FLD: QTXATIM LEN(4) TYPE(BIN) DISP(8) /*Timeout counts*/
FLD: QTXALES LEN(4) TYPE(BIN) DISP(12) /*Count of lock escal shared*/
FLD: QTXALEX LEN(4) TYPE(BIN) DISP(16)
/*Count of lock escal exclusive*/
FLD: QTXANPL LEN(4) TYPE(BIN) DISP(20) /*Max number of page or row*/
* locks held.
* Not applicable for Statistics
* IFCID 2.
FLD: QTXAFLG1 LEN(1) DISP(24) /*First Flag Byte*/
COMP: QTXAILMT = X'80' /*Infinite Limit*/
COMP: QTXANRUN = X'40' /*No Run or Zero Limit*/
FLD: QTXARLID LEN(2) DISP(26) /*Resource Limit Table ID*/
FLD: QTXAPREC LEN(4) TYPE(BIN) DISP(28) /*How Limit was determined*/
COMP: QTXAPRC1 = 1 /*Limit from specific Authid*/
COMP: QTXAPRC2 = 2 /*Limit from specific Authid*/
COMP: QTXAPRC3 = 3 /*Limit from specific Planname*/
COMP: QTXAPRC4 = 4 /*Limit from blank Authid & Plan*/
COMP: QTXAPRC5 = 5 /*Limit from Install no entry*/
COMP: QTXAPRC6 = 6 /*Limit from Install I/O error*/
COMP: QTXAPRC7 = 7 /*Infinite limit user has*/
COMP: QTXAPRC8 = 8 /*Limit from specific Authid,*/
COMP: QTXAPRC9 = 9 /*Limit from specific Authid*/
COMP: QTXAPR10 = 10 /*Limit from specific Authid*/
COMP: QTXAPR11 = 11 /*Limit from Authid running*/
COMP: QTXAPR12 = 12 /*Limit from specific package*/
COMP: QTXAPR13 = 13 /*Limit from any Authid and*/
COMP: QTXAPR14 = 14 /*Limit from any Authid and*/
COMP: QTXAPR15 = 15 /*Limit from any Authid, pkg,*/
FLD: QTXASLMT LEN(4) TYPE(BIN) DISP(32) /*Limit in SU's ASUTIME*/
FLD: QTXACLMT LEN(4) TYPE(BIN) DISP(36)
/*Limit in CPU 16 microseconds*/
FLD: QTXACHUS LEN(4) TYPE(BIN) DISP(40)
/*Highest CPU 16 microsecs used*/
FLD: QTXASLAT LEN(4) TYPE(BIN) DISP(44)
/*Suspend count latch conflict*/
FLD: QTXASOTH LEN(4) TYPE(BIN) DISP(48)
/*Suspend count other conflict*/
FLD: QTXALOCK LEN(4) TYPE(BIN) DISP(52) /*Lock request count*/
FLD: QTXAUNLK LEN(4) TYPE(BIN) DISP(56) /*Unlock request count*/
FLD: QTXAQRY LEN(4) TYPE(BIN) DISP(60) /*Query request count*/
FLD: QTXACHG LEN(4) TYPE(BIN) DISP(64) /*Change request count*/
FLD: QTXAIRLM LEN(4) TYPE(BIN) DISP(68) /*Other IRLM request count*/
FLD: QTXACLNO LEN(4) TYPE(BIN) DISP(72) /*Number of claim requests*/
FLD: QTXACLUN LEN(4) TYPE(BIN) DISP(76)
/*Number of claim requests that*/
* were unsuccessful
FLD: QTXADRNO LEN(4) TYPE(BIN) DISP(80) /*Number of drain requests*/
FLD: QTXADRUN LEN(4) TYPE(BIN) DISP(84)
/*Number of drain requests that*/
* were unsuccessful
FLD: QTXAEND LEN(1) DISP(88)
*******************************************************************
* QISE DSNDQISE * EDM POOL STATISTICS - RELEASE 2
*******************************************************************
***********************************************************************
**** QISE DSECT /*EDM POOL STATISTICS */
***********************************************************************
COMP: QISE_OFFSET =
WHEN(SM100RTY=100 AND QWS10R6N > 0) ASSIGN(QWS10R6O)
ELSE ASSIGN(99999)
FLD: QISE DISP(0) LEN(1) OFFSET(QISE_OFFSET)
/*EDM POOL STATISTICS*/
FLD: QISEFAIL LEN(4) TYPE(BIN) DISP(0) /*# OF FAIL DUE TO POOL FULL*/
FLD: QISEPAGE LEN(4) TYPE(BIN) DISP(4) /*NOT USED, DO NOT REUSE*/
* /*PAGE IS 1K 370 AND 4K ON XA */
FLD: QISECTG LEN(4) TYPE(BIN) DISP(8) /*# OF REQ FOR CT SECTIONS*/
FLD: QISECTL LEN(4) TYPE(BIN) DISP(12) /*# OF LOAD CT SECT FROM DASD*/
FLD: QISECT LEN(4) TYPE(BIN) DISP(16) /*NOT USED, DO NOT REUSE*/
FLD: QISEFREE LEN(4) TYPE(BIN) DISP(20) /*NOT USED, DO NOT REUSE*/
FLD: QISESTMT LEN(4) TYPE(BIN) DISP(24) /*# OF STMTS IN EDM POOL*/
FLD: QISEDBDG LEN(4) TYPE(BIN) DISP(32) /*# OF REQUESTS FOR DBD*/
FLD: QISEDBDL LEN(4) TYPE(BIN) DISP(36) /*# OF LOADING DBD FROM DASD*/
FLD: QISEKTG LEN(4) TYPE(BIN) DISP(40) /*# OF REQ FOR PT SECTIONS*/
FLD: QISEKTL LEN(4) TYPE(BIN) DISP(44) /*# OF LOAD PT SECT FROM DASD*/
FLD: QISEKT LEN(4) TYPE(BIN) DISP(48) /*NOT USED, DO NOT REUSE*/
FLD: QISEDSI LEN(4) TYPE(BIN) DISP(56) /*# OF INSERTS FOR DYN CACHE*/
FLD: QISEDSG LEN(4) TYPE(BIN) DISP(60) /*# OF REQUESTS FOR DYN CACHE*/
FLD: QISEDBD LEN(4) TYPE(BIN) DISP(64) /*# OF PAGES USED FOR DBD*/
FLD: QISEDFAL LEN(4) TYPE(BIN) DISP(68)
/*# OF FAIL DUE TO DBD POOL FULL*/
FLD: QISEDPGE LEN(4) TYPE(BIN) DISP(72) /*NUMBER OF PAGES IN DBD POOL*/
FLD: QISEDFRE LEN(4) TYPE(BIN) DISP(76)
/*# OF FREE PG IN DBD FREE CHAIN*/
FLD: QISEDYNP LEN(4) TYPE(BIN) DISP(80) /*# OF PGS USED IN STMT POOL*/
FLD: QISECFAL LEN(4) TYPE(BIN) DISP(84)
/*# OF FAIL DUE TO STMT POOL FULL*/
FLD: QISECPGE LEN(4) TYPE(BIN) DISP(88) /*# OF PGS IN STMT POOL*/
FLD: QISECFRE LEN(4) TYPE(BIN) DISP(92)
/*# OF FREE PG IN STMT FREE CHAIN*/
FLD: QISESKCT LEN(4) TYPE(BIN) DISP(96) /*# OF PAGES USED FOR SKCT*/
FLD: QISESKPT LEN(4) TYPE(BIN) DISP(100) /*# OF PAGES USED FOR SKPT*/
FLD: QISEKFAL LEN(4) TYPE(BIN) DISP(104)
/*# OF FAIL DUE TO STMT SKEL POOL FULL*/
FLD: QISEKPGE LEN(4) TYPE(BIN) DISP(108)
/*# OF PAGES IN SKEL EDM POOL*/
FLD: QISEKFRE LEN(4) TYPE(BIN) DISP(112)
/*# OF FREE PG IN SKEL EDM POOL FRE CH*/
FLD: QISECTA LEN(4) TYPE(BIN) DISP(116)
/*# OF PAGES USED IN CT ABOVE BAR*/
FLD: QISEKTA LEN(4) TYPE(BIN) DISP(120)
/*# OF PAGES USED IN PT ABOVE BAR*/
FLD: QISESFAL LEN(4) TYPE(BIN) DISP(124)
/*# OF FAIL DUE TO STMT ABV POOL FULL*/
FLD: QISESPGE LEN(4) TYPE(BIN) DISP(128)
/*# OF PAGES IN STMT ABV EDM POOL*/
FLD: QISESFRE LEN(4) TYPE(BIN) DISP(132)
/*# OF FREE PG IN STMT ABV EDM POL FRE*/
FLD: QISEKNFM LEN(4) TYPE(BIN) DISP(136)
/*# OF CACHED NOT FOUND RECORD LOCATED*/
FLD: QISEKNFA LEN(4) TYPE(BIN) DISP(140)
/*# OF NOT FOUND RECORD ADDED TO CACHE*/
FLD: QISEKNFR LEN(4) TYPE(BIN) DISP(144)
/*# OF NT FOUND RCRD REMOVED FRM CACHE*/
FLD: QISEKSPG LEN(4) TYPE(BIN) DISP(148) /*# of XPROC requests*/
FLD: QISEKSPA LEN(4) TYPE(BIN) DISP(152)
/*Total storage allocated to xPROC*/
FLD: QISEKLRU LEN(4) TYPE(BIN) DISP(156) /*Total stealable SKEL pages*/
FLD: QISEDLRU LEN(4) TYPE(BIN) DISP(160) /*Total stealable DBD pages*/
FLD: QISESQCB LEN(4) TYPE(BIN) DISP(168)
/*Storage allocated to PLAN BTB*/
FLD: QISESQKB LEN(4) TYPE(BIN) DISP(172)
/*Storage allocated to PACKAGE BTB*/
FLD: QISESQCA LEN(8) DISP(176) /*Storage allocated to PLAN ATB*/
FLD: QISESQKA LEN(8) DISP(184) /*Storage allocated to PACKAGE ATB*/
FLD: QISEEND LEN(4) TYPE(BIN) DISP(192) /*END OF LIST*/
*******************************************************************
* QBGL DSNDQBGL * Buffer Manager Data Sharing Stats - V4R1
*******************************************************************
***********************************************************************
**** QBGL DSECT
***********************************************************************
COMP: QBGL_OFFSET =
WHEN(SM100RTY=100 AND QWS10R7N > 0) ASSIGN(QWS10R7O)
ELSE ASSIGN(99999)
FLD: QBGL DISP(0) LEN(1) OFFSET(QBGL_OFFSET)
FLD: QBGLGN LEN(4) TYPE(BIN) DISP(0) /*Group Buffer Pool id*/
FLD: QBGLFLG LEN(1) DISP(4) /*Flags*/
COMP: QBGLCON = X'80' /*1 More QBGL data will follow*/
FLD: QBGLGG LEN(8) DISP(8) /*GetPages for GBP Dep pages*/
FLD: QBGLXD LEN(8) TYPE(BIN) DISP(16)
/*# of GBP reads under the user*/
* task that were
* necessary due to buffer cross
* invalidation (XI) in which
* data was returned */
FLD: QBGLXR LEN(8) TYPE(BIN) DISP(24)
/*# of GBP reads under the user*/
* task that were
* necessary due to buffer XI
* in which data was not
* returned from GBP. */
FLD: QBGLMD LEN(8) TYPE(BIN) DISP(32)
/*# of GBP reads under the user*/
* task that were
* necessary due to the reques-
* ted page not being found in
* the buffer pool in which
* data was returned from GBP. */
FLD: QBGLMR LEN(8) TYPE(BIN) DISP(40)
/*# of GBP reads under the user*/
* task that were
* necessary due to the reques-
* ted page not being found in
* the buffer pool in which
* data was not returned. */
FLD: QBGLSW LEN(8) TYPE(BIN) DISP(48) /*# of changed pages written*/
* under a user's execution */
* unit (via WAR or WARM) */
FLD: QBGLWC LEN(8) TYPE(BIN) DISP(56) /*# of clean pages written*/
* under a user's execution
* unit (via WAR or WARM) */
FLD: QBGLCT LEN(8) TYPE(BIN) DISP(64)
/*# of times castout was initiated*/
* due to the castout class
* threshold being detected. */
FLD: QBGLGT LEN(8) TYPE(BIN) DISP(72)
/*# of times castout was initiated*/
* due to the group buffer pool
* castout threshold being
* detected. */
FLD: QBGLWM LEN(8) TYPE(BIN) DISP(80) /*# of Write and Register*/
* Multiple (WARM) requests.
* Multiple pages written per
* request. */
FLD: QBGLWS LEN(8) TYPE(BIN) DISP(88) /*# of Write and Register*/
* (WAR) requests. One page
* written per request. */
FLD: QBGLEX LEN(8) TYPE(BIN) DISP(96)
/*# of explicit cross invalidate*/
FLD: QBGLAW LEN(8) TYPE(BIN) DISP(104) /*# of changed pages written*/
* under a system execution
* unit (via WAR or WARM). */
FLD: QBGLRC LEN(8) TYPE(BIN) DISP(112)
/*# of pages castout from the*/
* Group Buffer Pool to DASD.
* For each page that is castout,
* QBSTPWS is also incremented.
* For each disk I/O that is
* initiated for castout,
* QBSTWIO is incremented. */
FLD: QBGLCM LEN(8) DISP(120) /*# Read For Castout Multiple*/
* RFCOM) requests. Multiple
* pages read per request. */
FLD: QBGLCR LEN(8) TYPE(BIN) DISP(128)
/*# of Read For Castout (RFCO)*/
* requests. One page read
* per request. */
FLD: QBGLWP LEN(8) TYPE(BIN) DISP(136)
/*# of pages written via WARM*/
FLD: QBGLWF LEN(8) TYPE(BIN) DISP(144)
/*# of GBP write requests that*/
* could not complete due to a
* lack of GBP storage resour-
* ces. */
FLD: QBGLOS LEN(8) TYPE(BIN) DISP(152)
/*# of IXLCACHE "read stgstats"*/
* requests. */
FLD: QBGLAC LEN(8) TYPE(BIN) DISP(160) /*# of changed pages written*/
* under a system execution
* unit (via WAR or WARM). */
FLD: QBGLAX LEN(8) TYPE(BIN) DISP(168)
/*# of "register page list" (RPL)*/
* requests done by Prefetch.
* Prefetch will use this option
* if running on MVS 5.2 or
* above, and the GBP is
* allocated in a coupling
* facility of CFLEVEL=2 or
* above. */
FLD: QBGLAY LEN(8) TYPE(BIN) DISP(176)
/*# of pages retrieved from the*/
* group buffer pool
* as a result of feedback from
* RPL. */
FLD: QBGLCK LEN(8) TYPE(BIN) DISP(184)
/*# of GBP checkpoints triggered*/
* by this member. */
FLD: QBGLUN LEN(8) DISP(192) /*# IXLCACHE "unlock castout"*/
* requests. */
FLD: QBGLCC LEN(8) DISP(200) /*# IXLCACHE "read castout class"*/
* requests */
FLD: QBGLCS LEN(8) DISP(208) /*# IXLCACHE "read castout stats"*/
* requests */
FLD: QBGLDN LEN(8) DISP(216) /*# IXLCACHE "delete name"*/
* requests */
FLD: QBGLRD LEN(8) DISP(224) /*# IXLCACHE "read dirinfo"*/
* requests */
FLD: QBGLRG LEN(8) TYPE(BIN) DISP(232)
/*# of "register page" requests*/
FLD: QBGLDG LEN(8) TYPE(BIN) DISP(240) /*# of "unregister page"*/
* requests */
FLD: QBGL2F LEN(8) DISP(248) /*# writes of changed pages to*/
* the secondary GBP that
* failed due to a lack of
* storage. */
FLD: QBGL2S LEN(8) DISP(256) /*# completion checks for writes*/
* to the secondary GBP that
* were suspended because the
* write had not yet completed.*/
FLD: QBGL2D LEN(8) DISP(264) /*# IXLCACHE "delete name list"*/
* requests to the secondary
* GBP. */
FLD: QBGL2R LEN(8) DISP(272) /*# IXLCACHE "read castout stats"*/
* requests to the secondary
* GBP. */
FLD: QBGL2N LEN(8) DISP(280) /*# IXLCACHE "delete name"*/
* requests to the secondary
* GBP. */
FLD: QBGLHS LEN(8) DISP(288) /*# Asynch IXLCACHE invocations*/
* for primary GBP. */
FLD: QBGL2H LEN(8) DISP(296) /*# Asynch IXLCACHE invocations*/
* for secondary GBP. */
FLD: QBGLP1 LEN(8) DISP(304) /*# page P lock lock requests for*/
* space map pages */
FLD: QBGLP2 LEN(8) DISP(312) /*# page P lock lock requests for*/
* data pages */
FLD: QBGLP3 LEN(8) DISP(320) /*# page P lock lock requests for*/
* index leaf pages */
FLD: QBGLU1 LEN(8) DISP(328) /*# page P lock unlock requests*/
FLD: QBGLS1 LEN(8) DISP(336) /*# page P lock lock suspensions*/
* for space map pages */
FLD: QBGLS2 LEN(8) DISP(344) /*# page P lock lock suspensions*/
* for data pages */
FLD: QBGLS3 LEN(8) DISP(352) /*# page P lock lock suspensions*/
* for index leaf pages */
FLD: QBGLN1 LEN(8) DISP(360) /*# page P lock lock negotiations*/
* for space map pages */
FLD: QBGLN2 LEN(8) DISP(368) /*# page P lock lock negotiations*/
* for data pages */
FLD: QBGLN3 LEN(8) DISP(376) /*# page P lock lock negotiations*/
* for index leaf pages */
FLD: QBGLEND LEN(1) DISP(416)
*******************************************************************
* QTGS DSNDQTGS * Service Controller Data Sharing Stats - V4R1
*******************************************************************
***********************************************************************
**** QTGS DSECT
***********************************************************************
COMP: QTGS_OFFSET =
WHEN(SM100RTY=100 AND QWS10R8N > 0) ASSIGN(QWS10R8O)
ELSE ASSIGN(99999)
FLD: QTGS DISP(0) LEN(1) OFFSET(QTGS_OFFSET)
*/********************************************************************/
*/* In the descriptions below, the term "L-lock" refers to a */
*/* "logical lock", or a lock that is acquired and owned by a */
*/* DB2 thread. The term "P-lock" refers to a */
*/* "physical lock", or a lock that is acquired and owned the */
*/* DB2 subsystem (i.e. P-locks are not owned by threads). */
*/********************************************************************/
FLD: QTGSLPLK LEN(4) TYPE(BIN) DISP(0) /*# Lock requests for P locks.*/
* This is a subset of QTXALOCK
* which contains the total #
* of Lock requests (L-locks
* and P-locks). */
FLD: QTGSCPLK LEN(4) TYPE(BIN) DISP(4)
/*# Change requests for P locks.*/
* This is a subset of QTXACHG
* which contains the total #
* of Change requests (L-locks
* and P-locks). */
FLD: QTGSUPLK LEN(4) TYPE(BIN) DISP(8)
/*# Unlock requests for P locks.*/
* This is a subset of QTXAUNLK
* which contains the total #
* of Unlock requests (L-locks
* and P-locks). */
FLD: QTGSLSLM LEN(4) TYPE(BIN) DISP(12) /*# lock requests propagated*/
* to XES (L-lock or P-lock)
* synchronously, i.e. under
* caller's execution unit. If
* the request suspends due to
* IRLM latch before going to
* XES, this counter will not
* be incremented */
FLD: QTGSCSLM LEN(4) TYPE(BIN) DISP(16)
/*# change requests propagated*/
* to XES (L-lock or P-lock)
* synchroneously, i.e. under
* caller's execution unit. If
* the request suspends due to
* IRLM latch before going to
* XES, this counter will not
* be incremented */
FLD: QTGSUSLM LEN(4) TYPE(BIN) DISP(20)
/*# unlock requests propagated*/
* to XES (L-lock or P-lock)
* synchroneously, i.e. under
* caller's execution unit. If
* the request suspends due to
* IRLM latch before going to
* XES, this counter will not
* be incremented.
* This counter may actually
* be larger than QTXAUNLK
* (# unlocks) due to "generic"
* unlocks. On a "generic"
* unlock, QTXAUNLK is incre-
* mented only once, while
* QTGSUSLM may be incremented
* multiple times - once for
* each global lock that is
* released by the "generic"
* unlock.
*
* /****************************************************************/
* /* The following 3 fields give the counts for the number of */
* /* suspends due to global contention for lock requests. A */
* /* "global contention" occurs when inter-system communication */
* /* is required to resolve the lock conflict. This is in */
* /* contrast to a "local contention" in which no inter-system */
* /* communication is required to resolve the lock conflict - the */
* /* conflict can be resolved entirely within the local IRLM for */
* /* local contention. */
* /* */
* /* The sum of QTGSIGLO, QTGSSGLO and QTGSFLSE gives the total */
* /* number of suspends due to global contention. */
* /* */
* /* QTXASLOC gives the number of suspends due to local resource */
* /* contention. */
* /****************************************************************/
FLD: QTGSIGLO LEN(4) TYPE(BIN) DISP(24)
/*# suspends due to IRLM global*/
* resource contention. IRLM
* lock states were in
* conflict */
FLD: QTGSSGLO LEN(4) TYPE(BIN) DISP(28)
/*# suspends due to XES global*/
* resource contention but no
* IRLM global resource con-
* tention. XES lock states were
* in conflict but the IRLM lock
* states were not. */
FLD: QTGSFLSE LEN(4) TYPE(BIN) DISP(32)
/*# of sync to async heuristic*/
* conversions for LOCK requests
* in XES. This conversion is
* done when XES determines that
* it is more efficient to drive
* the request asynchronously to
* the CF. */
FLD: QTGSDRTA LEN(4) TYPE(BIN) DISP(36) /*# global lock or change*/
* requests denied or suspended
* because of an incompatible
* retained lock */
FLD: QTGSNTFY LEN(4) TYPE(BIN) DISP(40) /*# notify messages sent*/
FLD: QTGSNTFR LEN(4) TYPE(BIN) DISP(44) /*# notify messages received*/
*
FLD: QTGSKIDS LEN(4) TYPE(BIN) DISP(48) /*# resources (L locks or*/
* P-locks) propagated by IRLM
* to XES asynchroneously to the
* original request. This
* occurs when new inter-DB2
* interest occurs on a parent
* resource or when a request
* completes after the request-
* or's execution unit has been
* suspended. */
FLD: QTGSPPPE LEN(4) TYPE(BIN) DISP(52) /*# times this DB2 was driven*/
* to negotiate a pageset/
* partition P-lock due to
* changing inter-DB2 interest
* levels on the pageset/part */
FLD: QTGSPGPE LEN(4) TYPE(BIN) DISP(56) /*# times this DB2 was driven*/
* to negotiate a page P-lock
* due to inter-DB2 P-lock
* contention */
FLD: QTGSOTPE LEN(4) TYPE(BIN) DISP(60) /*# times this DB2 was driven*/
* to negotiate another P-lock
* type (other than pageset/
* partition or page */
FLD: QTGSCHNP LEN(4) TYPE(BIN) DISP(64) /*# of CHANGEP requests*/
FLD: QTGSPEMX LEN(4) TYPE(BIN) DISP(68)
/*Max # of engines available for*/
* P-lock exit or Notify exit
* requests */
FLD: QTGSPEQW LEN(4) TYPE(BIN) DISP(72) /*# times an engine is not*/
* available for a P-lock exit
* or a Notify exit request */
*
FLD: QTGSFLMG LEN(4) TYPE(BIN) DISP(76)
/*# false contentions for LOCK*/
* and UNLOCK requests.
* A false contention
* occurs when different
* resource names hash to the
* same entry in the CF lock
* table. The CF detects
* contention within the hash
* entry, and XES uses inter-
* system messaging to determine
* that no actual resource
* contention exists.
* Note #1: when OA12164 and
* PK85159 are applied, this
* counter will report false
* contentions for a member
* against which the accounting
* report is run.
* Note #2: In the absence
* of OA12164 & PK85159, this
* counter is maintained on
* a per-LPAR basis. Therefore
* this counter will over-report
* false contentions in cases
* where multiple members from
* the same data sharing group
* run on the same z/OS image.
* 'FF'x is returned if data is
* unavailable due to error from
* returned from the XES service
* */
FLD: QTGSCREJ LEN(4) TYPE(BIN) DISP(80)
/*# failed DB2 lock requests to*/
* XES to process without delay.
* XES rejects the lock request
* since it could not process it
* synchronously */
FLD: QTGSFLGS LEN(4) TYPE(BIN) DISP(84) /*Flags that describe various*/
* counters in QTGS section */
COMP: QTGSFCON = X'80000000' /*1 QTGSFLMG reports counts per*/
FLD: QTGSEND LEN(1) DISP(88)
*******************************************************************
* QLES DSNDQLES * LE STATISTICS
*******************************************************************
***********************************************************************
**** DSNDQLES DSECT TABLE OF LE in ADMF COUNTERS
***********************************************************************
COMP: QLES_OFFSET =
WHEN(SM100RTY=100 AND QWS10R9N > 0) ASSIGN(QWS10R9O)
ELSE ASSIGN(99999)
FLD: DSNDQLES DISP(0) LEN(1) OFFSET(QLES_OFFSET)
/*TABLE OF LE in ADMF COUNTERS*/
FLD: QLES LEN(8) DISP(0)
FLD: QLHEAD LEN(4) TYPE(BIN) DISP(0) /*CONTROL BLOCK HEADER*/
FLD: QLID TYPE(HALF) DISP(0) /*CONTROL BLOCK ID*/
FLD: QLLEN TYPE(HALF) DISP(2) /*CONTROL BLOCK LENGTH*/
FLD: QLEYE LEN(4) DISP(4) /*CONTROL BLOCK EYE CATCHER*/
FLD: QLESTATS LEN(4) TYPE(BIN) DISP(8) /*STATISTICS*/
FLD: QLECREAT LEN(4) TYPE(BIN) DISP(8) /*(S)*/
FLD: QLETRMST LEN(4) TYPE(BIN) DISP(12) /*(S)*/
FLD: QLETRMER LEN(4) TYPE(BIN) DISP(16) /*(S)*/
FLD: QLETRMDL LEN(4) TYPE(BIN) DISP(20) /*(S)*/
FLD: QLENUMEC LEN(4) TYPE(BIN) DISP(24) /*(S)*/
FLD: QLENUMEM LEN(4) TYPE(BIN) DISP(28) /*(S)*/
FLD: QLENUMIC LEN(4) TYPE(BIN) DISP(32) /*(S)*/
FLD: QLENUMIM LEN(4) TYPE(BIN) DISP(36) /*(S)*/
FLD: QLESTGEC LEN(4) TYPE(BIN) DISP(40) /*(S)*/
FLD: QLESTGEM LEN(4) TYPE(BIN) DISP(44) /*(S)*/
FLD: QLESTGIC LEN(4) TYPE(BIN) DISP(48) /*(S)*/
FLD: QLESTGIM LEN(4) TYPE(BIN) DISP(52) /*(S)*/
FLD: QLELOWEC LEN(4) TYPE(BIN) DISP(56) /*(S)*/
FLD: QLELOWEM LEN(4) TYPE(BIN) DISP(60) /*(S)*/
FLD: QLELOWIC LEN(4) TYPE(BIN) DISP(64) /*(S)*/
FLD: QLELOWIM LEN(4) TYPE(BIN) DISP(68) /*(S)*/
FLD: QLESTG1M LEN(4) TYPE(BIN) DISP(72) /*(S)*/
FLD: QLELOW1M LEN(4) TYPE(BIN) DISP(76) /*(S)*/
FLD: QLEUSED LEN(8) DISP(80) /*(S)*/
FLD: QLETIME LEN(8) DISP(88) /*(S)*/
FLD: QLENTRDY LEN(8) DISP(96) /*(S)*/
FLD: QLETIMEW LEN(8) DISP(104) /*(S)*/
FLD: QLETIMEI LEN(8) DISP(112) /*(S)*/
FLD: QLETIMET LEN(8) DISP(120) /*(S)*/
FLD: QLETIMEM LEN(8) DISP(128) /*(S)*/
FLD: QLESEND LEN(4) TYPE(BIN) DISP(168)
*******************************************************************
* QISJ DSNDQISJ * STARJOIN POOL STATISTICS (S)
*******************************************************************
***********************************************************************
**** QISJ DSECT
***********************************************************************
COMP: QISJ_OFFSET =
WHEN(SM100RTY=100 AND QWS10RAN > 0) ASSIGN(QWS10RAO)
ELSE ASSIGN(99999)
FLD: QISJ DISP(0) LEN(1) OFFSET(QISJ_OFFSET)
FLD: QISJTRY LEN(4) TYPE(BIN) DISP(0) /*(S)*/
FLD: QISJFAIL LEN(4) TYPE(BIN) DISP(4) /*(S)*/
FLD: QISJSIZE LEN(4) TYPE(BIN) DISP(8) /*(S)*/
FLD: QISJMAX LEN(4) TYPE(BIN) DISP(12) /*(S)*/
FLD: QISJEND LEN(4) TYPE(BIN) DISP(16)
*******************************************************************
* Q8ST *
*******************************************************************
***********************************************************************
**** Q8ST DSECT
***********************************************************************
COMP: Q8ST_OFFSET =
WHEN(SM100RTY=100 AND QWS10RBN > 0) ASSIGN(QWS10RBO)
ELSE ASSIGN(99999)
FLD: Q8ST DISP(0) LEN(1) OFFSET(Q8ST_OFFSET)
FLD: Q8STNAME_OFF LEN(2) TYPE(BIN) DISP(0)
/*ACCELERATOR SERVER ID OFFSET*/
FLD: Q8STPRID LEN(8) DISP(2) /*ACCELERATOR PRODUCT ID*/
FLD: Q8STCONN LEN(8) TYPE(BIN) DISP(16) /*# OF ACCELERATOR CONNECTS.*/
FLD: Q8STREQ LEN(8) TYPE(BIN) DISP(24) /*# OF ACCELERATOR REQUESTS.*/
FLD: Q8STTOUT LEN(8) TYPE(BIN) DISP(32) /*# OF TIMED OUT REQUESTS.*/
FLD: Q8STFAIL LEN(8) TYPE(BIN) DISP(40) /*# OF FAILED REQUESTS.*/
FLD: Q8STBYTS LEN(8) TYPE(BIN) DISP(48) /*# OF BYTES SENT.*/
FLD: Q8STBYTR LEN(8) TYPE(BIN) DISP(56) /*# OF BYTES RETURNED.*/
FLD: Q8STMSGS LEN(8) TYPE(BIN) DISP(64) /*# OF MESSAGES SENT.*/
FLD: Q8STMSGR LEN(8) TYPE(BIN) DISP(72) /*# OF MESSAGES RETURNED.*/
FLD: Q8STBLKS LEN(8) TYPE(BIN) DISP(80) /*# OF BLOCKS SENT.*/
FLD: Q8STBLKR LEN(8) TYPE(BIN) DISP(88) /*# OF BLOCKS RETURNED.*/
FLD: Q8STROWS LEN(8) TYPE(BIN) DISP(96) /*# OF ROWS SENT.*/
FLD: Q8STROWR LEN(8) TYPE(BIN) DISP(104) /*# OF ROWS RETURNED.*/
FLD: Q8STSCPU TYPE(STCKTIME) DISP(112)
/*ACCELERATOR SERVICES CPU TIME.*/
FLD: Q8STSELA TYPE(STCKTIME) DISP(120)
/*ACCELERATOR SERVICES ELAPSED TIME.*/
FLD: Q8STTCPU TYPE(STCKTIME) DISP(128) /*ACCEL SVCS TCP/IP CPU TIME.*/
FLD: Q8STTELA TYPE(STCKTIME) DISP(136)
/*ACCEL SVCS TCP/IP ELAPSED TIME.*/
FLD: Q8STACPU TYPE(STCKTIME) DISP(144)
/*ACCUMULATED ACCELERATOR CPU TIME.*/
FLD: Q8STAELA TYPE(STCKTIME) DISP(152)
/*ACCUMULATED ACCELERATOR ELAPSED TIME.*/
FLD: Q8STTATE LEN(1) DISP(161) /*Accelerator state*/
* 0 = INITIALIZED
* 1 = ONLINE
* 2 = PAUSED
* 3 = OFFLINE
* 4 = STOPPED
* 5 = MAINTENANCE
* 6 = DOWN
* 7 = UNKNOWN
FLD: Q8STACTV TYPE(HALF) DISP(162)/*Current active requests*/
FLD: Q8STMAXA TYPE(HALF) DISP(164)/*Maximum active requests*/
FLD: Q8STAVGQ03 TYPE(HALF) DISP(166) /*Avg query queue len lst 3 hrs*/
FLD: Q8STMAXQ TYPE(HALF) DISP(168)
/*Query queue length high watermark*/
FLD: Q8STCCPU TYPE(HALF) DISP(170)/*Average cpu utilization on*/
* accelerator coordinator node
FLD: Q8STSKEW TYPE(HALF) DISP(172)/*Data Skew*/
FLD: Q8STWCPU TYPE(HALF) DISP(174)/*Average cpu utilization on*/
* accelerator worker nodes
FLD: Q8STWNOD TYPE(HALF) DISP(176)/*Number of active worker nodes*/
FLD: Q8STAVGQ24 TYPE(HALF) DISP(178) /*Avg query queue len lst 24 hrs*/
FLD: Q8STQUEW LEN(8) DISP(184) /*Average accelerator queue wait*/
* elapsed.
FLD: Q8STQUEM LEN(8) DISP(192) /*Maximum accelerator queue wait*/
* elapsed.
FLD: Q8STMIPS LEN(8) DISP(200) /*Accelerator processing capacity*/
FLD: Q8STCORS LEN(8) DISP(208) /*Total amount of processors within*/
* the accelerator
FLD: Q8STSREQ LEN(8) TYPE(BIN) DISP(216)
/*Total number of successful query*/
* requests since accelerator start
FLD: Q8STFREQ LEN(8) TYPE(BIN) DISP(224)
/*Total number of failed query*/
* requests since accelerator start
FLD: Q8STFINV LEN(8) TYPE(BIN) DISP(232)
/*Number of failed query requests*/
* due to invalid state
FLD: Q8STDSKA LEN(8) DISP(240) /*Disk storage (MB) available*/
FLD: Q8STDSKU LEN(8) DISP(248) /*Disk storage (MB) in use*/
FLD: Q8STDSKB TYPE(HALF) DISP(256)/*Disk storage in use for DB*/
FLD: Q8STCPMU LEN(8) DISP(258)
/*Physical memory (MB) average usage on*/
* accelerator coordinator node
FLD: Q8STNMDS TYPE(HALF) DISP(266)/*V2 Number of Data Slices*/
FLD: Q8STWPMU LEN(8) DISP(268)
/*Physical memory (MB) average usage on*/
* accelerator worker nodes
FLD: Q8STWSMA LEN(8) DISP(276) /*Shared memory (MB) data available on*/
* accelerator worker nodes
FLD: Q8STWSMU LEN(8) DISP(284)
/*Shared memory (MB) data average usage*/
* on accelerator worker nodes
FLD: Q8STWSMM LEN(8) DISP(292)
/*Maximum shared (MB) memory data in use*/
* on IWA worker nodes
FLD: Q8STAWAT TYPE(STCKTIME) DISP(300)
/*ACCUMULATED ACCELERATOR WAIT TIME.*/
FLD: Q8STEND LEN(4) TYPE(BIN) DISP(308)
***********************************************************************
**** Q8STNAME_D DSECT USE IF Q8STNAME_Off<>0
***********************************************************************
COMP: Q8STNAME_D_OFFSET =
WHEN(SM100RTY=100 AND QWS10RBN > 0 AND Q8STNAME_Off <> 0)
ASSIGN(QWS10RBO + Q8STNAME_Off)
ELSE ASSIGN(99999)
FLD: Q8STNAME_D DISP(0) LEN(1) OFFSET(Q8STNAME_D_OFFSET)
/*USE IF Q8STNAME_Off<>0*/
FLD: Q8STNAME_LEN TYPE(HALF) DISP(0) /*LENGTH OF THE FOLLOWING FIELD*/
FLD: Q8STNAME_VAR LEN(128) DISP(2)/*ACCELERATOR SERVER NAME*/
***********************************************************************
* *
* SMF 100 RECORD SUBTYPE 4 (?) (IFCID 225) FOLLOWS *
* *
* IFCID225 summarizes system storage usage
* The record is divided into data sections described as follows:
*
* Data Section 1: Address Space Summary (QW0225)
* This data section can be a repeating group.
* It will report data for DBM1 and DIST
* address spaces. Use QW0225AN to identify
* the address space being described.
* Data Section 2: Thread information (QW02252)
* Data Section 3: Shared and Common Storage Summary (QW02253)
* Data Section 4: Statement Cache and xPROC Detail (QW02254)
* Data Section 5: Pool Details (QW02255)
***********************************************************************
***********************************************************************
**** QWS4 DSECT
***********************************************************************
COMP: QWS4_OFFSET =
WHEN(SM100RTY=100 AND QWHSIID = 225) ASSIGN(28)
ELSE ASSIGN(99999)
FLD: QWS4 DISP(0) LEN(1) OFFSET(QWS4_OFFSET)
* DB2 SELF DEFINING SECTION MACRO FOR IFCID=0255
*
FLD: QWS40PSO LEN(4) TYPE(BIN) DISP(0)
/*OFFSET TO THE PRODUCT SECTION*/
FLD: QWS40PSL LEN(2) TYPE(BIN) DISP(4)
/*LENGTH OF THE PRODUCT SECTION*/
FLD: QWS40PSN LEN(2) TYPE(BIN) DISP(6) /*NUMBER OF PRODUCT SECTIONS*/
*
FLD: QWS40R1O LEN(4) TYPE(BIN) DISP(8) /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R1L LEN(2) TYPE(BIN) DISP(12) /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R1N LEN(2) TYPE(BIN) DISP(14) /*NUMBER OF DATA SECTIONS*/
*
FLD: QWS40R2O LEN(4) TYPE(BIN) DISP(16) /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R2L LEN(2) TYPE(BIN) DISP(20) /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R2N LEN(2) TYPE(BIN) DISP(22) /*NUMBER OF DATA SECTIONS*/
*
FLD: QWS40R3O LEN(4) TYPE(BIN) DISP(24) /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R3L LEN(2) TYPE(BIN) DISP(28) /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R3N LEN(2) TYPE(BIN) DISP(30) /*NUMBER OF DATA SECTIONS*/
*
FLD: QWS40R4O LEN(4) TYPE(BIN) DISP(32) /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R4L LEN(2) TYPE(BIN) DISP(36) /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R4N LEN(2) TYPE(BIN) DISP(38) /*NUMBER OF DATA SECTIONS*/
*
FLD: QWS40R5O LEN(4) TYPE(BIN) DISP(40) /*OFFSET TO THE DATA SECTION*/
FLD: QWS40R5L LEN(2) TYPE(BIN) DISP(44) /*LENGTH OF THE DATA SECTION*/
FLD: QWS40R5N LEN(2) TYPE(BIN) DISP(46) /*NUMBER OF DATA SECTIONS*/
*******************************************************************
* IFCID 0225 * Data Section 1: Address Space Summary
*******************************************************************
***********************************************************************
**** QW0225 DSECT
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QW0225, USE:
* INPUT: SMF100
* NORMWHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R1N > 0)
* NORMSMF(QWS40R1O)
***********************************************************************
COMP: QW0225_OFFSET =
WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R1N > 0)
ASSIGN(QWS40R1O)
ELSE ASSIGN(99999)
FLD: QW0225 DISP(0) LEN(1) OFFSET(QW0225_OFFSET)
FLD: QW0225AN LEN(4) DISP(0) /*! Address space name (DBM1 or DIST)*/
FLD: QW0225RG LEN(4) TYPE(BIN) DISP(4) /*! MVS extended region size*/
FLD: QW0225LO LEN(4) TYPE(BIN) DISP(8) /*! MVS 24 bit low private*/
FLD: QW0225HI LEN(4) TYPE(BIN) DISP(12) /*! MVS 24 bit high private*/
FLD: QW0225EL LEN(4) TYPE(BIN) DISP(16)
/*! MVS 31 bit extended low private*/
FLD: QW0225EH LEN(4) TYPE(BIN) DISP(20)
/*! MVS 31 bit extended high private*/
FLD: QW0225TP LEN(4) TYPE(BIN) DISP(24)
/*! Current high address of 24 bit private region*/
FLD: QW0225EP LEN(4) TYPE(BIN) DISP(28)
/*! Current high address of 31 bit private region*/
FLD: QW0225CR LEN(4) TYPE(BIN) DISP(32)
/*! 31 bit storage reserved for must complete*/
FLD: QW0225MV LEN(4) TYPE(BIN) DISP(36)
/*! 31 bit storage reserved for MVS*/
FLD: QW0225SO LEN(4) TYPE(BIN) DISP(40)
/*! Storage cushion warning to contract*/
FLD: QW0225GS LEN(4) TYPE(BIN) DISP(44)
/*! Total 31 bit getmained stack*/
FLD: QW0225SU LEN(4) TYPE(BIN) DISP(48) /*! Total 31 bit stack in use*/
FLD: QW0225VR LEN(4) TYPE(BIN) DISP(52)
/*! Total 31 bit variable pool storage*/
FLD: QW0225FX LEN(4) TYPE(BIN) DISP(56)
/*! Total 31 bit fixed pool storage*/
FLD: QW0225GM LEN(4) TYPE(BIN) DISP(60)
/*! Total 31 bit getmained storage*/
FLD: QW0225AV LEN(4) TYPE(BIN) DISP(64)
/*! Amount of available 31 bit storage*/
FLD: QW0225VA LEN(8) TYPE(BIN) DISP(72)
/*! Total 64 bit private variable pool storage*/
FLD: QW0225FA LEN(8) TYPE(BIN) DISP(80)
/*! Total 64 bit private fixed pool storage*/
FLD: QW0225GA LEN(8) TYPE(BIN) DISP(88)
/*! Total 64 bit private getmained storage*/
FLD: QW0225SM LEN(8) TYPE(BIN) DISP(96)
/*! Total 64 bit private storage for storage*/
* ! manager control structures
FLD: QW0225RL LEN(8) TYPE(BIN) DISP(104)
/*! Number of real 4K frames in use for*/
* ! 31 and 64-bit private
FLD: QW0225AX LEN(8) TYPE(BIN) DISP(112)
/*! Number of 4K auxiliary slots in use*/
* ! for 31 and 64-bit private
FLD: QW0225HVPAGESINREAL LEN(8) TYPE(BIN) DISP(120)
/*! Number of real 4K frames is use for*/
* ! 64-bit private (available in
* ! >= z/OS 1.11)
FLD: QW0225HVAUXSLOTS LEN(8) TYPE(BIN) DISP(128)
/*! Number of 4K auxiliary slots in use*/
* ! for 64-bit private (available in
* ! >= z/OS 1.11)
FLD: QW0225HVGPAGESINREAL LEN(8) TYPE(BIN) DISP(136)
/*! High water mark for number of real 4K*/
* ! frames is use for 64-bit private
* ! (available in >= z/OS 1.11)
FLD: QW0225HVGAUXSLOTS LEN(8) TYPE(BIN) DISP(144)
/*! High water mark for 4K auxiliary slots*/
* ! in use for 64-bit private
* ! (available in >= z/OS 1.11)
*
*******************************************************************
* IFCID 0225 Data Section 2: Thread information
*******************************************************************
***********************************************************************
**** QW02252 DSECT
***********************************************************************
COMP: QW02252_OFFSET =
WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R2N > 0)
ASSIGN(QWS40R2O)
ELSE ASSIGN(99999)
FLD: QW02252 DISP(0) LEN(1) OFFSET(QW02252_OFFSET)
FLD: QW0225AT LEN(4) TYPE(BIN) DISP(0) /*! # of active threads*/
FLD: QW0225DB LEN(4) TYPE(BIN) DISP(4)
/*! # of active and disconnected DBATs*/
FLD: QW0225CE LEN(4) TYPE(BIN) DISP(8) /*! # of castout engines*/
FLD: QW0225DW LEN(4) TYPE(BIN) DISP(12)
/*! # of deferred write engines*/
FLD: QW0225GW LEN(4) TYPE(BIN) DISP(16) /*! # of GBP write engines*/
FLD: QW0225PF LEN(4) TYPE(BIN) DISP(20) /*! # of prefetch engines*/
FLD: QW0225PL LEN(4) TYPE(BIN) DISP(24)
/*! # of P lock/notify exit engines*/
*
*******************************************************************
* IFCID 0225 Data Section 3: Shared and Common Storage Summary
*******************************************************************
***********************************************************************
**** QW02253 DSECT
***********************************************************************
COMP: QW02253_OFFSET =
WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R3N > 0)
ASSIGN(QWS40R3O)
ELSE ASSIGN(99999)
FLD: QW02253 DISP(0) LEN(1) OFFSET(QW02253_OFFSET)
FLD: QW0225EC LEN(4) TYPE(BIN) DISP(0) /*! MVS extended CSA size*/
FLD: QW0225FC LEN(4) TYPE(BIN) DISP(4)
/*! Total 31 bit common fixed pool storage*/
FLD: QW0225VC LEN(4) TYPE(BIN) DISP(8)
/*! Total 31 bit common variable pool storage*/
FLD: QW0225GC LEN(4) TYPE(BIN) DISP(12)
/*! Total 31 bit common getmained storage*/
FLD: QW0225FCG LEN(8) TYPE(BIN) DISP(16)
/*! Total 64 bit common fixed pool storage*/
FLD: QW0225VCG LEN(8) TYPE(BIN) DISP(24)
/*! Total 64 bit common variable pool storage*/
FLD: QW0225GCG LEN(8) TYPE(BIN) DISP(32)
/*! Total 64 bit common getmained storage*/
FLD: QW0225SMC LEN(8) TYPE(BIN) DISP(40)
/*! Total 64 bit common storage for*/
* ! storage manager control structures
FLD: QW0225SV LEN(8) TYPE(BIN) DISP(48)
/*! Total 64 bit shared variable pool storage*/
FLD: QW0225SF LEN(8) TYPE(BIN) DISP(56)
/*! Total 64 bit shared fixed pool storage*/
FLD: QW0225SG LEN(8) TYPE(BIN) DISP(64)
/*! Total 64 bit shared getmained storage*/
FLD: QW0225SMS LEN(8) TYPE(BIN) DISP(72)
/*! Total 64 bit shared storage for*/
* ! storage manager control structures
FLD: QW0225GSG_SYS LEN(8) TYPE(BIN) DISP(80)
/*! Total 64 bit shared system agent stack*/
FLD: QW0225SUG_SYS LEN(8) TYPE(BIN) DISP(88)
/*! Total 64 bit shared system agent stack*/
* ! in use
FLD: QW0225GSG LEN(8) TYPE(BIN) DISP(96)
/*! Total 64 bit shared non system agent*/
* ! stack
FLD: QW0225SUG LEN(8) TYPE(BIN) DISP(104)
/*! Total 64 bit shared non system agent*/
* ! stack in use
FLD: QW0225SHRNMOMB LEN(4) TYPE(BIN) DISP(116)
/*! Number of shared memory objects*/
* ! allocated for this MVS LPAR
FLD: QW0225SHRPAGES LEN(8) TYPE(BIN) DISP(120)
/*! Number of 64 bit shared memory pages*/
* ! allocated for this MVS LPAR (this
* ! count includes hidden pages)
FLD: QW0225SHRGBYTES LEN(8) TYPE(BIN) DISP(128)
/*! High water mark for number of 64 bit*/
* ! shared bytes for this MVS LPAR
FLD: QW0225SHRINREAL LEN(8) TYPE(BIN) DISP(136)
/*! Number of 64 bit shared pages backed*/
* ! in real storage (4K pages) for this
* ! MVS LPAR
FLD: QW0225SHRAUXSLOTS LEN(8) TYPE(BIN) DISP(144)
/*! Number of auxiliary slots used for*/
* ! 64-bit shared storage for this
* ! MVS LPAR
FLD: QW0225SHRPAGEINS LEN(8) TYPE(BIN) DISP(152)
/*! Number of 64 bit shared pages*/
* ! paged in from auxiliary storage for
* ! this MVS LPAR
FLD: QW0225SHRPAGEOUTS LEN(8) TYPE(BIN) DISP(160)
/*! Number of 64 bit shared pages*/
* ! paged out to auxiliary storage
* ! for this MVS LPAR
*
*******************************************************************
* IFCID 0225 Data Section 4: Statement Cache and xPROC Detail
*******************************************************************
***********************************************************************
**** QW02254 DSECT
***********************************************************************
COMP: QW02254_OFFSET =
WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R4N > 0)
ASSIGN(QWS40R4O)
ELSE ASSIGN(99999)
FLD: QW02254 DISP(0) LEN(1) OFFSET(QW02254_OFFSET)
FLD: QW0225SC LEN(4) TYPE(BIN) DISP(0)
/*! Total 31 bit xPROC storage for dynamic*/
* ! SQL used by active threads
* ! (31-bit DBM1 private variable pool)
FLD: QW0225LS LEN(4) TYPE(BIN) DISP(4)
/*! Allocated 31 bit xPROC storage for dynamic*/
* ! SQL used by active threads
FLD: QW0225SX LEN(4) TYPE(BIN) DISP(8)
/*! Total 31 bit xPROC storage for static*/
* ! SQL statements
* ! (31-bit DBM1 private variable pool)
FLD: QW0225HS LEN(4) TYPE(BIN) DISP(12)
/*! High water mark allocated for 31 bit xPROC*/
* ! storage for dynamic SQL used by active
* ! threads
FLD: QW0225LC LEN(4) TYPE(BIN) DISP(16)
/*! # of statements in 64 bit agent local pools*/
* ! (64-bit shared agent local variable pools)
FLD: QW0225HC LEN(4) TYPE(BIN) DISP(20)
/*! High water mark # of statements in 64 bit*/
* ! agent local pools at high storage time
* ! (64-bit shared agent local variable pools)
FLD: QW0225L2 LEN(8) TYPE(BIN) DISP(24)
/*! Allocated statement cache storage in 64 bit*/
* ! agent local pools
* ! (64-bit shared agent local variable pools)
FLD: QW0225H2 LEN(8) TYPE(BIN) DISP(32)
/*! High water mark for allocated statement*/
* ! cache storage in 64-bit agent local pools
* ! (64-bit shared agent local variable pools)
FLD: QW0225HT TYPE(STCKTIME) DISP(40)
/*! Timestamp of high water mark for storage*/
* ! allocated in 64-bit agent local pools
* ! since the last IFCID225 was written
* ! (64-bit shared agent local variable pools)
FLD: QW0225HT_D LEN(8) TYPE(STCKDATE) DISP(QW0225HT) /* Date */
FLD: QW0225S2 LEN(8) TYPE(BIN) DISP(48)
/*! Total 64 bit STMT CACHE BLOCKS 2G*/
* ! storage
* ! (64-bit shared variable pool)
FLD: QW0225F1 LEN(8) TYPE(BIN) DISP(56) /*! (S)*/
FLD: QW0225F2 LEN(8) TYPE(BIN) DISP(64) /*! (S)*/
*******************************************************************
* IFCID 0225 Data Section 5: Pool Details
*******************************************************************
***********************************************************************
**** QW02255 DSECT
***********************************************************************
COMP: QW02255_OFFSET =
WHEN(SM100RTY=100 AND QWHSIID=225 AND QWS40R5N > 0)
ASSIGN(QWS40R5O)
ELSE ASSIGN(99999)
FLD: QW02255 DISP(0) LEN(1) OFFSET(QW02255_OFFSET)
FLD: QW0225AL LEN(4) TYPE(BIN) DISP(0) /*! Total agent local storage*/
* ! (31-bit DBM1 private variable pools)
FLD: QW0225AS LEN(4) TYPE(BIN) DISP(4) /*! Total system agent storage*/
* ! (31-bit DBM1 private variable pools)
FLD: QW0225ALG LEN(8) TYPE(BIN) DISP(8) /*! Total agent local storage*/
* ! (64-bit shared variable pools)
FLD: QW0225ASG LEN(8) TYPE(BIN) DISP(16)
/*! Total system agent storage*/
* ! (64-bit shared variable pools)
FLD: QW0225BB LEN(8) TYPE(BIN) DISP(24)
/*! Total buffer manager storage blocks*/
* ! (31-bit DBM1 private variable pool)
FLD: QW0225RP LEN(8) TYPE(BIN) DISP(32) /*! Total RID pool storage*/
* ! (64-bit shared fixed pool)
FLD: QW0225CD LEN(8) TYPE(BIN) DISP(40)
/*! Total compression dictionary storage*/
* ! (64-bit DBM1 private getmained)
FLD: SMF100_END LEN(1) OFFSET(0) |
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)
