SMF Type 115 Record
This table shows the record layout for type 115 SMF records
(WebSphere MQ Performance Statistics (V8)).
List of other SMF record layouts available.
List of sample SMF reports.
Purpose: WebSphere MQ performance statistics are written as SMF type 115 records. Statistics records are produced periodically at a time interval specified by the STATIME parameter of the CSQ6SYSP system parameter module, or at the SMF global accounting interval if you specify zero for STATIME.
The information provided in the SMF records comes from the following components of WebSphere MQ:
- Buffer manager Manages the buffer pools in virtual storage and the writing of pages to page sets as the buffer pools become full. Also manages the reading of pages from page sets.
- Coupling Facility manager Manages the interface with the Coupling Facility.
- Data manager Manages the links between messages and queues. It calls the buffer manager to process the pages with messages on them.
- DB2 manager Manages the interface with the DB2 database that is used as the shared repository.
- Lock manager Manages locks for WebSphere MQ for z/OS.
- Log manager Manages the writing of log records, which are essential for maintaining the integrity of the system if there is a back out request, or for recovery, if there is a system or media failure.
- Message manager Processes all WebSphere MQ API requests.
- Storage manager Manages storage for WebSphere MQ for z/OS, for example, storage pool allocation, expansion, and deallocation.
WebSphere MQ statistics can be collected for two subtypes:
1 System information, for example, related to the logs and storage.
2 Information about number of messages, buffer and paging information. Queue-sharing group information related to the Coupling Facility and DB2.
It's easy to report on SMF 115 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 115 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 115 SMF Records WebSphere MQ Performance Statistics (V8)
***********************************************************************
* SPECTRUM SMF WRITER -- FILE DEFINITION STATEMENTS *
* SMF TYPE 115 RECORD - "WEBSPHERE MQ PERFORMANCE STATISTICS (V8)" *
***********************************************************************
OPTION: MISSOFFSET /* TREAT OFFSET ERRORS (99999) LIKE MISSING DATA */
OPTION: STCKADJ(0) /* NO GMT TO LOCAL CONVERSION - DURATIONS*/
*******************************************************************
* SMF COMMON HEADER MAPPING MACRO FOR STATISTICS TYPE 100
*******************************************************************
*
FLD: SMF115LEN LEN(2) DISP(0) /*SMF115 TOTAL LENGTH*/
FLD: SMF115SGD LEN(2) DISP(2) /*RESERVED*/
FLD: SMF115FLG LEN(1) DISP(4) /*SYSTEM INDICATOR*/
FLD: SMF115RTY LEN(1) TYPE(BIN) ACC(NO) DISP(5)
/*The SMF record type, for WebSphere MQ*/
* statistics records this is always
* 115 (X'73').
FLD: SMF115TME LEN(4) TYPE(B-SECS) DISP(6) DEC(2)
/*TIME SMF MOVED RECORD*/
FLD: SMF115DTE TYPE(P-CYYDDD) DISP(10) /*DATE SMF MOVED RECORD*/
FLD: SMF115SID LEN(4) DISP(14) /*z/OS subsystem ID. Defines the z/OS*/
* subsystem on which the records were
* collected. (EX: MV41)
FLD: SMF115SSI LEN(4) DISP(18)
/*WebSphere MQ subsystem ID. (EX: MQ07)*/
FLD: SMF115STF TYPE(HALF) DISP(22)/*RECORD SUBTYPE*/
FLD: SMF115RI LEN(3) DISP(24) /*WebSphere MQ version. (EX: 600)*/
FLD: SMF115SEQ LEN(1) DISP(27) /*RESERVED*/
FLD: SMF115SD LEN(1) DISP(28) /*self defining section starts*/
*
***
***The following 18 fields are only included with subtype 2
FLD: SMF115_QMSTO LEN(4) TYPE(BIN) DISP(36)
/*Offset to QMST message manager record section.*/
FLD: SMF115_QMSTL TYPE(HALF) DISP(40)
/*Length of QMST message manager record section.*/
FLD: SMF115_QMSTN TYPE(HALF) DISP(42)
/*Number of QMST message manager record sections.*/
FLD: SMF115_QISTO LEN(4) TYPE(BIN) DISP(44)
/*Offset to QIST data manager record section.*/
FLD: SMF115_QISTL TYPE(HALF) DISP(48)
/*Length of QIST data manager record section.*/
FLD: SMF115_QISTN TYPE(HALF) DISP(50)
/*Number of QIST data manager record sections.*/
FLD: SMF115_QPSTO LEN(4) TYPE(BIN) DISP(52)
/*Offset to QPST buffer manager record section.*/
FLD: SMF115_QPSTL TYPE(HALF) DISP(56)
/*Length of QPST buffer manager record section.*/
FLD: SMF115_QPSTN TYPE(HALF) DISP(58)
/*Number of QPST buffer manager record sections*/
* one for each buffer pool.
FLD: SMF115_QLSTO LEN(4) TYPE(BIN) DISP(60)
/*Offset to QLST lock manager record section.*/
FLD: SMF115_QLSTL TYPE(HALF) DISP(64)
/*Length of QLST lock manager record section.*/
FLD: SMF115_QLSTN TYPE(HALF) DISP(66)
/*Number of QLST lock manager record sections.*/
FLD: SMF115_Q5STO LEN(4) TYPE(BIN) DISP(68)
/*Offset to Q5ST DB2 manager record section.*/
FLD: SMF115_Q5STL TYPE(HALF) DISP(72)
/*Length of Q5ST DB2 manager record section.*/
FLD: SMF115_Q5STN TYPE(HALF) DISP(74)
/*Number of Q5ST DB2 manager record sections.*/
FLD: SMF115_QESTO LEN(4) TYPE(BIN) DISP(76)
/*Offset to QEST coupling manager record section.*/
FLD: SMF115_QESTL TYPE(HALF) DISP(80)
/*Length of QEST coupling manager record section.*/
FLD: SMF115_QESTN TYPE(HALF) DISP(82)
/*Number of QEST coupling manager record sections*/
FLD: SMF115_QTSTO LEN(4) TYPE(BIN) DISP(84)
/*Offset to QTST coupling manager record section.*/
FLD: SMF115_QTSTL TYPE(HALF) DISP(88)
/*Length of QTST coupling manager record section.*/
FLD: SMF115_QTSTN TYPE(HALF) DISP(90)
/*Number of QTST coupling manager record sections*/
FLD: SMF115_QESDO LEN(4) TYPE(BIN) DISP(92)
/*Offset to QESD coupling manager record section.*/
FLD: SMF115_QESDL TYPE(HALF) DISP(96)
/*Length of QESD coupling manager record section.*/
FLD: SMF115_QESDN TYPE(HALF) DISP(98)
/*Number of QESD coupling manager record sections.*/
***
***The following 6 fields are only included with subtype 1
FLD: SMF115_QSSTO LEN(4) TYPE(BIN) DISP(44)
/*Offset to QSST storage manager record section.*/
FLD: SMF115_QSSTL TYPE(HALF) DISP(48)
/*Length of QSST storage manager record section.*/
FLD: SMF115_QSSTN TYPE(HALF) DISP(50)
/*Number of QSST storage manager record sections.*/
FLD: SMF115_QJSTO LEN(4) TYPE(BIN) DISP(60)
/*Offset to QJST log manager record section.*/
FLD: SMF115_QJSTL TYPE(HALF) DISP(64)
/*Length of QJST log manager record section.*/
FLD: SMF115_QJSTN TYPE(HALF) DISP(66)
/*Number of QJST log manager record sections.*/
***
***The following 18 fields are only included with subtype 231
FLD: QWSX0PSO LEN(4) TYPE(BIN) DISP(28)
/*OFFSET TO THE PRODUCT SECTION*/
FLD: QWSX0PSL LEN(2) TYPE(BIN) DISP(32)
/*LENGTH OF THE PRODUCT SECTION*/
FLD: QWSX0PSN LEN(2) TYPE(BIN) DISP(34) /*NUMBER OF PRODUCT SECTIONS*/
* FOR CHINIT MAPPED BY CSQDQCCT CHINIT CONTROL INFO
FLD: QWSX0R1O LEN(4) TYPE(BIN) DISP(36) /*OFFSET TO THE DATA SECTION*/
FLD: QWSX0R1L LEN(2) TYPE(BIN) DISP(40) /*LENGTH OF THE DATA SECTION*/
FLD: QWSX0R1N LEN(2) TYPE(BIN) DISP(42) /*NUMBER OF DATA SECTIONS*/
* FOR DISPATCHER TASK MAPPED BY QCT_DSP
FLD: QWSX0R2O LEN(4) TYPE(BIN) DISP(44) /*OFFSET TO THE DATA SECTION*/
FLD: QWSX0R2L LEN(2) TYPE(BIN) DISP(48) /*LENGTH OF THE DATA SECTION*/
FLD: QWSX0R2N LEN(2) TYPE(BIN) DISP(50) /*NUMBER OF DATA SECTIONS*/
* FOR ADAPTER TASK MAPPED BY QCT_ADP
FLD: QWSX0R3O LEN(4) TYPE(BIN) DISP(52) /*OFFSET TO THE DATA SECTION*/
FLD: QWSX0R3L LEN(2) TYPE(BIN) DISP(56) /*LENGTH OF THE DATA SECTION*/
FLD: QWSX0R3N LEN(2) TYPE(BIN) DISP(58) /*NUMBER OF DATA SECTIONS*/
* FOR SSL SERVER TASK MAPPED BY QCT_SSL
FLD: QWSX0R4O LEN(4) TYPE(BIN) DISP(60) /*OFFSET TO THE DATA SECTION*/
FLD: QWSX0R4L LEN(2) TYPE(BIN) DISP(64) /*LENGTH OF THE DATA SECTION*/
FLD: QWSX0R4N LEN(2) TYPE(BIN) DISP(66) /*NUMBER OF DATA SECTIONS*/
* FOR DNS TASK MAPPED BY QCT_DNS
FLD: QWSX0R5O LEN(4) TYPE(BIN) DISP(68) /*OFFSET TO THE DATA SECTION*/
FLD: QWSX0R5L LEN(2) TYPE(BIN) DISP(72) /*LENGTH OF THE DATA SECTION*/
FLD: QWSX0R5N LEN(2) TYPE(BIN) DISP(74) /*NUMBER OF DATA SECTIONS*/
FLD: QWSX0END LEN(1) DISP(76) /*END OF THE SELF DEFINING SECTION*/
***********************************************************************
**** QSST DSECT , STORAGE MANAGER STATISTICS BLOCK
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QSST, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 1
* AND SMF115_QSSTN > 0)
* NORMSMF(SMF115_QSSTO)
***********************************************************************
COMP: QSST_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 1 AND SMF115_QSSTN > 0)
ASSIGN(SMF115_QSSTO)
ELSE ASSIGN(99999)
FLD: QSST DISP(0) LEN(72) OFFSET(QSST_OFFSET)
/*STORAGE MANAGER STATISTICS BLOCK*/
FLD: QSSTHEAD LEN(4) TYPE(BIN) DISP(0) /*CONTROL BLOCK HEADER*/
FLD: QSSTID LEN(2) DISP(0) /*CONTROL BLOCK ID*/
FLD: QSSTLEN TYPE(HALF) DISP(2) /*LENGTH OF CONTROL BLOCK*/
FLD: QSSTDESC LEN(4) DISP(4) /*EBCDIC EYE CATCHER*/
FLD: QSSTDATA LEN(4) TYPE(BIN) DISP(8) /*STATISTICAL COUNTERS*/
FLD: QSSTGPLF LEN(4) TYPE(BIN) DISP(8) /*FIXED POOLS CREATED*/
FLD: QSSTFPLF LEN(4) TYPE(BIN) DISP(12) /*FIXED POOLS DEALLOCATED*/
FLD: QSSTFREF LEN(4) TYPE(BIN) DISP(16) /*FIXED POOL SEGMENTS FREED*/
FLD: QSSTEXPF LEN(4) TYPE(BIN) DISP(20)
/*FIXED POOL SEGMENTS EXPANDED*/
FLD: QSSTCONF LEN(4) TYPE(BIN) DISP(24)
/*FIXED POOL SEGMENTS CONTRACTED*/
FLD: QSSTGPLV LEN(4) TYPE(BIN) DISP(28) /*VARIABLE POOLS CREATED*/
FLD: QSSTFPLV LEN(4) TYPE(BIN) DISP(32) /*VARIABLE POOLS DEALLOCATED*/
FLD: QSSTFREV LEN(4) TYPE(BIN) DISP(36)
/*VARIABLE POOL SEGMENTS FREED*/
FLD: QSSTEXPV LEN(4) TYPE(BIN) DISP(40)
/*VARIABLE POOL SEGMENTS EXPANDED*/
FLD: QSSTCONV LEN(4) TYPE(BIN) DISP(44)
/*VARIABLE POOL SEGMENTS CONTRACTED*/
FLD: QSSTGETM LEN(4) TYPE(BIN) DISP(48) /*GETMAIN ISSUED TO ALLOCATE*/
* STORAGE OTHER THAN FIXED AND
* VARIABLE BLOCKS
FLD: QSSTFREM LEN(4) TYPE(BIN) DISP(52)
/*FREEMAIN ISSUED TO DEALLOCATE*/
* STORAGE OTHER THAN FIXED AND
* VARIABLE BLOCKS
FLD: QSSTRCNZ LEN(4) TYPE(BIN) DISP(56) /*NONZERO RETURN CODES ISSUED*/
* BY GETMAIN/FREEMAIN
FLD: QSSTCONT LEN(4) TYPE(BIN) DISP(60)
/*CONTRACTIONS ISSUED FOR SHORT ON STORAGE*/
FLD: QSSTCRIT LEN(4) TYPE(BIN) DISP(64) /*SHORT ON STORAGE BIT SET*/
FLD: QSSTABND LEN(4) TYPE(BIN) DISP(68)
/*ABEND ISSUED BECAUSE OF SHORT ON STORAGE*/
FLD: QSSTCN64 LEN(4) TYPE(BIN) DISP(72)
/*V71 CONTRACTIONS FOR SHORT ON 64 BIT STORAGE*/
FLD: QSSTCR64 LEN(4) TYPE(BIN) DISP(76)
/*V71 SHORT ON 64 BIT STORAGE BIT SET*/
FLD: QSSTEND LEN(1) DISP(80) /*END OF CONTROL BLOCK*/
COMP: QSSTIDEN = X'003C' /*HEADER CONSTANT*/
COMP: QSSTEYEC = 'QSST' /*EYE CATCHER CONSTANT*/
***********************************************************************
**** QJST DSECT , Log Manager Statistics
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QJST, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 1
* AND SMF115_QJSTN > 0)
* NORMSMF(SMF115_QJSTO)
***********************************************************************
COMP: QJST_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 1 AND SMF115_QJSTN > 0)
ASSIGN(SMF115_QJSTO)
ELSE ASSIGN(99999)
FLD: QJST DISP(0) LEN(120) OFFSET(QJST_OFFSET)
/*Log Manager Statistics*/
FLD: QJSTID LEN(2) DISP(0) /*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 @D1C*/
* 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*/
FLD: QJSTLLCP LEN(4) TYPE(BIN) DISP(64) /*COUNT OF CHECKPOINTS ISSUED*/
FLD: QJSTWUR LEN(4) TYPE(BIN) DISP(68)
/*NUMBER OF READ ACCESSES DELAYED DUE TO*/
* UNAVAILABLE RESOURCE
FLD: QJSTLAMA LEN(4) TYPE(BIN) DISP(72)
/*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(76)
/*NUMBER OF LOOK AHEAD TAPE VOLUME MOUNTS*/
* PERFORMED.
FLD: QJSTLSUS LEN(4) TYPE(BIN) DISP(80)
/*NUMBER OF TIMES A LOG REQUEST RESULTED IN*/
* A SUSPEND FOR A LOG WRITE TO OCCUR.
FLD: QJSTLOGW LEN(4) TYPE(BIN) DISP(84)
/*TOTAL NUMBER OF LOG WRITE I/O REQUESTS.*/
FLD: QJSTCIWR LEN(4) TYPE(BIN) DISP(88)
/*TOTAL NUMBER OF LOG CI S WRITTEN.*/
FLD: QJSTSERW LEN(4) TYPE(BIN) DISP(92)
/*NUMBER OF SERIAL LOG WRITE REQUESTS FOR*/
* CI RE-WRITES WHEN DUAL LOGGING.
FLD: QJSTTHRW LEN(4) TYPE(BIN) DISP(96)
/*NUMBER OF TIMES A LOG WRITE REQUEST WAS*/
* SCHEDULED BECAUSE THE LOG WRITE THRESHOLD
* WAS REACHED.
FLD: QJSTBPAG LEN(4) TYPE(BIN) DISP(100)
/*NUMBER OF TIMES A LOG WRITE BUFFER HAD TO*/
* BE PAGED-IN BEFORE IT COULD BE USED.
FLD: QJSTEND LEN(4) TYPE(BIN) DISP(120)
***********************************************************************
**** QMST DSECT , Message Manager Statistics
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QMST, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 2
* AND SMF115_QMSTN > 0)
* NORMSMF(SMF115_QMSTO)
***********************************************************************
COMP: QMST_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 2 AND SMF115_QMSTN > 0)
ASSIGN(SMF115_QMSTO)
ELSE ASSIGN(99999)
FLD: QMST DISP(0) LEN(48) OFFSET(QMST_OFFSET)
/*Message Manager Statistics*/
FLD: QMSTID LEN(2) DISP(0) /*Control block identifier*/
COMP: QMSTIDV = X'D40F' /*Control block identifier value*/
FLD: QMSTLL LEN(2) TYPE(BIN) DISP(2) /*length of QMST block*/
FLD: QMSTEYEC LEN(4) DISP(4) /*eyecatcher*/
FLD: QMSTOPEN LEN(4) TYPE(BIN) DISP(8) /*# of MQOPEN requests*/
FLD: QMSTCLOS LEN(4) TYPE(BIN) DISP(12) /*# of MQCLOSE requests*/
FLD: QMSTGET LEN(4) TYPE(BIN) DISP(16) /*# of MQGET requests*/
FLD: QMSTPUT LEN(4) TYPE(BIN) DISP(20) /*# of MQPUT requests*/
FLD: QMSTPUT1 LEN(4) TYPE(BIN) DISP(24) /*# of MQPUT1 requests*/
FLD: QMSTINQ LEN(4) TYPE(BIN) DISP(28) /*# of MQINQ requests*/
FLD: QMSTINQL LEN(4) TYPE(BIN) DISP(32) /*Reserved*/
FLD: QMSTSET LEN(4) TYPE(BIN) DISP(36) /*# of MQSET requests*/
FLD: QMSTENDW LEN(4) TYPE(BIN) DISP(40) /*Reserved*/
FLD: QMSTCALH LEN(4) TYPE(BIN) DISP(44) /*# of Close All Handles reqs*/
***********************************************************************
**** QIST DSECT , Data Manager statistics
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QIST, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 2
* AND SMF115_QISTN > 0)
* NORMSMF(SMF115_QISTO)
***********************************************************************
COMP: QIST_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 2 AND SMF115_QISTN > 0)
ASSIGN(SMF115_QISTO)
ELSE ASSIGN(99999)
FLD: QIST DISP(0) LEN(80) OFFSET(QIST_OFFSET)
/*Data Manager statistics*/
FLD: QISTID LEN(2) DISP(0) /*Control block ID*/
COMP: QISTIDV = X'C90F' /*Control block ID value*/
FLD: QISTLL LEN(2) TYPE(BIN) DISP(2) /*Length of control block*/
FLD: QISTEYEC LEN(4) DISP(4) /*Control block eyecatcher*/
FLD: QISTMGET LEN(4) TYPE(BIN) DISP(8) /*# of Message Get requests*/
FLD: QISTMPUT LEN(4) TYPE(BIN) DISP(12) /*# of Message Put requests*/
FLD: QISTMBLR LEN(4) TYPE(BIN) DISP(16)
/*# of Release Browse Lock requests*/
FLD: QISTDCRE LEN(4) TYPE(BIN) DISP(20) /*# of Object Create requests*/
FLD: QISTDPUT LEN(4) TYPE(BIN) DISP(24) /*# of Object Put requests*/
FLD: QISTDDEL LEN(4) TYPE(BIN) DISP(28) /*# of Object Delete requests*/
FLD: QISTDGET LEN(4) TYPE(BIN) DISP(32) /*# of Object Get requests*/
FLD: QISTDLOC LEN(4) TYPE(BIN) DISP(36) /*# of Object Locate requests*/
FLD: QISTMCNT LEN(4) TYPE(BIN) DISP(40) /*# of Message Count requests*/
FLD: QISTALST LEN(4) TYPE(BIN) DISP(44)
/*# of Stgclass change requests*/
FLD: QISTLOMM LEN(4) TYPE(BIN) DISP(48)
/*# of Lock Marked Msg requests*/
FLD: QISTDLMM LEN(4) TYPE(BIN) DISP(52)
/*# of Delete Marked Msg requests*/
FLD: QISTENUM LEN(4) TYPE(BIN) DISP(56)
/*# of Enumerate/select requests*/
FLD: QISTRAIO LEN(4) TYPE(BIN) DISP(60) /*# of Read aheads doing I/O*/
FLD: QISTRABP LEN(4) TYPE(BIN) DISP(64)
/*# of Read aheads from Buff Pool*/
FLD: QISTGETD LEN(4) TYPE(BIN) DISP(68)
/*# of Gets that got msg off disk*/
FLD: QISTGETB LEN(4) TYPE(BIN) DISP(72)
/*# of Gets that got msg from BP*/
***********************************************************************
**** QPST DSECT , Buffer Manager Pool statistics
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QPST, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 215
* AND SMF115_QPSTN > 0)
* NORMSMF(SMF115_QPSTO)
***********************************************************************
COMP: QPST_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 215 AND SMF115_QPSTN > 0)
ASSIGN(SMF115_QPSTO)
ELSE ASSIGN(99999)
FLD: QPST DISP(0) LEN(104) OFFSET(QPST_OFFSET)
/*Buffer Manager Pool statistics*/
FLD: QPSTID LEN(2) DISP(0) /*Control block ID*/
COMP: QPSTIDV = X'D70F' /*Control block ID value*/
FLD: QPSTLL LEN(2) TYPE(BIN) DISP(2) /*Length of control block*/
FLD: QPSTEYEC LEN(4) DISP(4) /*Control block eyecatcher*/
FLD: QPSTPOOL LEN(4) TYPE(BIN) DISP(8) /*Buffer Pool Number*/
FLD: QPSTNBUF LEN(4) TYPE(BIN) DISP(12) /*# of buffers in pool*/
FLD: QPSTCBSL LEN(4) TYPE(BIN) DISP(16)
/*Lowest # of stealable buffers*/
FLD: QPSTCBS LEN(4) TYPE(BIN) DISP(20) /*# of stealable buffers*/
FLD: QPSTGETP LEN(4) TYPE(BIN) DISP(24)
/*# of Get Page (old) requests*/
FLD: QPSTGETN LEN(4) TYPE(BIN) DISP(28)
/*# of Get Page (new) requests*/
FLD: QPSTRIO LEN(4) TYPE(BIN) DISP(32) /*# of DASD read operations*/
FLD: QPSTSTW LEN(4) TYPE(BIN) DISP(36)
/*# of Set Write Intent requests*/
FLD: QPSTTPW LEN(4) TYPE(BIN) DISP(40) /*# of pages written to DASD*/
FLD: QPSTWIO LEN(4) TYPE(BIN) DISP(44) /*# of DASD write operations*/
FLD: QPSTIMW LEN(4) TYPE(BIN) DISP(48)
/*# of synchronous write operations*/
FLD: QPSTDWT LEN(4) TYPE(BIN) DISP(52)
/*# of times deferred write threshold X*/
FLD: QPSTDMC LEN(4) TYPE(BIN) DISP(56)
/*# of times synchronous write X*/
FLD: QPSTSTL LEN(4) TYPE(BIN) DISP(60) /*# of buffer steals*/
FLD: QPSTSTLA LEN(4) TYPE(BIN) DISP(64)
/*# of times hash chain modified X*/
FLD: QPSTSOS LEN(4) TYPE(BIN) DISP(68)
/*# times suspended for no stealable X*/
FLD: QPSTFLAG LEN(4) DISP(72) /*Flag word.*/
* Bit 0 on indicates buffer pool is
* located above the bar. Bit 1 on
* indicates that buffer pool is backed
* by fixed 4KB pages. Otherwise
* pageable 4KB pages are used. All
* other bits are reserved for
* expansion
***********************************************************************
**** QLST DSECT , Lock Manager statistics
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QLST, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 2
* AND SMF115_QLSTN > 0)
* NORMSMF(SMF115_QLSTO)
***********************************************************************
COMP: QLST_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 2 AND SMF115_QLSTN > 0)
ASSIGN(SMF115_QLSTO)
ELSE ASSIGN(99999)
FLD: QLST DISP(0) LEN(32) OFFSET(QLST_OFFSET)
/*Lock Manager statistics*/
FLD: QLSTID LEN(2) DISP(0) /*Control block id*/
COMP: QLSTIDV = X'D30F' /*Control block ID value*/
FLD: QLSTLL LEN(2) TYPE(BIN) DISP(2) /*Control block length*/
FLD: QLSTEYEC LEN(4) DISP(4) /*Eyecatcher*/
FLD: QLSTGETL LEN(4) TYPE(BIN) DISP(8) /*# of GET LOCK requests*/
FLD: QLSTHLDL LEN(4) TYPE(BIN) DISP(12)
/*# of times requested lock held*/
FLD: QLSTRELL LEN(4) TYPE(BIN) DISP(16) /*# of RELEASE LOCK requests*/
***********************************************************************
**** Q5ST DSECT , DB2 Manager Statistics
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF Q5ST, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 2
* AND SMF115_Q5STN > 0)
* NORMSMF(SMF115_Q5STO)
***********************************************************************
COMP: Q5ST_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 2 AND SMF115_Q5STN > 0)
ASSIGN(SMF115_Q5STO)
ELSE ASSIGN(99999)
FLD: Q5ST DISP(0) LEN(480) OFFSET(Q5ST_OFFSET)
/*DB2 Manager Statistics*/
FLD: Q5STID LEN(2) DISP(0) /*Control block identifier*/
COMP: Q5STIDV = X'F50F' /*Control block identifier value*/
FLD: Q5STLL LEN(2) TYPE(BIN) DISP(2) /*length of Q5ST block*/
FLD: Q5STEYEC LEN(4) DISP(4) /*eyecatcher*/
*
FLD: NUMTASK LEN(4) TYPE(BIN) DISP(8) /*# of server tasks*/
FLD: ACTTASK LEN(4) TYPE(BIN) DISP(12) /*# of active server tasks*/
FLD: CONNCNT LEN(4) TYPE(BIN) DISP(16) /*# of connect requests*/
FLD: DISCCNT LEN(4) TYPE(BIN) DISP(20) /*# of disconnect requests*/
FLD: DHIGMAX LEN(4) TYPE(BIN) DISP(24) /*Max. request queue depth*/
FLD: ABNDCNT LEN(4) TYPE(BIN) DISP(28) /*# of DB2SRV task abends*/
FLD: REQUCNT LEN(4) TYPE(BIN) DISP(32) /*# of request requeues*/
FLD: DEADCNT LEN(4) TYPE(BIN) DISP(36) /*# of deadlock timeouts*/
*
FLD: DELECNT LEN(4) TYPE(BIN) DISP(40) /*# of delete requests*/
FLD: LISTCNT LEN(4) TYPE(BIN) DISP(44) /*# of list requests*/
FLD: READCNT LEN(4) TYPE(BIN) DISP(48) /*# of read requests*/
FLD: UPDTCNT LEN(4) TYPE(BIN) DISP(52) /*# of update requests*/
FLD: WRITCNT LEN(4) TYPE(BIN) DISP(56) /*# of write requests*/
FLD: SCSSEL LEN(4) TYPE(BIN) DISP(60)
/*SCST selects Shared Ch. status*/
FLD: SCSINS LEN(4) TYPE(BIN) DISP(64)
/*SCST inserts Shared Ch. status*/
FLD: SCSUPD LEN(4) TYPE(BIN) DISP(68)
/*SCST updates Shared Ch. status*/
FLD: SCSDEL LEN(4) TYPE(BIN) DISP(72)
/*SCST deletes Shared Ch. status*/
FLD: SSKSEL LEN(4) TYPE(BIN) DISP(76)
/*SSKT selects Shared sync. key*/
FLD: SSKINS LEN(4) TYPE(BIN) DISP(80)
/*SSKT inserts Shared sync. key*/
FLD: SSKDEL LEN(4) TYPE(BIN) DISP(84)
/*SSKT deletes Shared sync. key*/
FLD: SCSBFTS LEN(4) TYPE(BIN) DISP(88)
/*SCST # of times buffer too small*/
FLD: SCSMAXR LEN(4) TYPE(BIN) DISP(92) /*SCST maximum rows on query*/
FLD: DELETCUW TYPE(STCKTIME) DISP(104)
/*Cumulative STCK diff Thread delete*/
FLD: DELETMXW TYPE(STCKTIME) DISP(112)
/*Maximum STCK diff Thread delete*/
FLD: DELESCUW TYPE(STCKTIME) DISP(120)
/*Cumulative STCK diff SQL delete*/
FLD: DELESMXW TYPE(STCKTIME) DISP(128) /*Maximum STCK diff SQL delete*/
FLD: LISTTCUW TYPE(STCKTIME) DISP(136)
/*Cumulative STCK diff Thread list*/
FLD: LISTTMXW TYPE(STCKTIME) DISP(144)
/*Maximum STCK diff Thread list*/
FLD: LISTSCUW TYPE(STCKTIME) DISP(152)
/*Cumulative STCK diff SQL list*/
FLD: LISTSMXW TYPE(STCKTIME) DISP(160) /*Maximum STCK diff SQL list*/
FLD: READTCUW TYPE(STCKTIME) DISP(168)
/*Cumulative STCK diff Thread read*/
FLD: READTMXW TYPE(STCKTIME) DISP(176)
/*Maximum STCK diff Thread read*/
FLD: READSCUW TYPE(STCKTIME) DISP(184)
/*Cumulative STCK diff SQL read*/
FLD: READSMXW TYPE(STCKTIME) DISP(192) /*Maximum STCK diff SQL read*/
FLD: UPDTTCUW TYPE(STCKTIME) DISP(200)
/*Cumulative STCK diff Thread update*/
FLD: UPDTTMXW TYPE(STCKTIME) DISP(208)
/*Maximum STCK diff Thread update*/
FLD: UPDTSCUW TYPE(STCKTIME) DISP(216)
/*Cumulative STCK diff SQL update*/
FLD: UPDTSMXW TYPE(STCKTIME) DISP(224) /*Maximum STCK diff SQL update*/
FLD: WRITTCUW TYPE(STCKTIME) DISP(232)
/*Cumulative STCK diff Thread write*/
FLD: WRITTMXW TYPE(STCKTIME) DISP(240)
/*Maximum STCK diff Thread write*/
FLD: WRITSCUW TYPE(STCKTIME) DISP(248)
/*Cumulative STCK diff SQL write*/
FLD: WRITSMXW TYPE(STCKTIME) DISP(256) /*Maximum STCK diff SQL write*/
FLD: SCSSTCUW TYPE(STCKTIME) DISP(264)
/*Cumulative STCK diff Thread select*/
FLD: SCSSTMXW TYPE(STCKTIME) DISP(272)
/*Maximum STCK diff Thread select*/
FLD: SCSSSCUW TYPE(STCKTIME) DISP(280)
/*Cumulative STCK diff SQL select*/
FLD: SCSSSMXW TYPE(STCKTIME) DISP(288) /*Maximum STCK diff SQL select*/
FLD: SCSITCUW TYPE(STCKTIME) DISP(296)
/*Cumulative STCK diff Thread insert*/
FLD: SCSITMXW TYPE(STCKTIME) DISP(304)
/*Maximum STCK diff Thread insert*/
FLD: SCSISCUW TYPE(STCKTIME) DISP(312)
/*Cumulative STCK diff SQL insert*/
FLD: SCSISMXW TYPE(STCKTIME) DISP(320) /*Maximum STCK diff SQL insert*/
FLD: SCSUTCUW TYPE(STCKTIME) DISP(328)
/*Cumulative STCK diff Thread update*/
FLD: SCSUTMXW TYPE(STCKTIME) DISP(336)
/*Maximum STCK diff Thread update*/
FLD: SCSUSCUW TYPE(STCKTIME) DISP(344)
/*Cumulative STCK diff SQL update*/
FLD: SCSUSMXW TYPE(STCKTIME) DISP(352) /*Maximum STCK diff SQL update*/
FLD: SCSDTCUW TYPE(STCKTIME) DISP(360)
/*Cumulative STCK diff Thread delete*/
FLD: SCSDTMXW TYPE(STCKTIME) DISP(368)
/*Maximum STCK diff Thread delete*/
FLD: SCSDSCUW TYPE(STCKTIME) DISP(376)
/*Cumulative STCK diff SQL delete*/
FLD: SCSDSMXW TYPE(STCKTIME) DISP(384) /*Maximum STCK diff SQL delete*/
FLD: SSKSTCUW TYPE(STCKTIME) DISP(392)
/*Cumulative STCK diff Thread select*/
FLD: SSKSTMXW TYPE(STCKTIME) DISP(400)
/*Maximum STCK diff Thread select*/
FLD: SSKSSCUW TYPE(STCKTIME) DISP(408)
/*Cumulative STCK diff SQL select*/
FLD: SSKSSMXW TYPE(STCKTIME) DISP(416) /*Maximum STCK diff SQL select*/
FLD: SSKITCUW TYPE(STCKTIME) DISP(424)
/*Cumulative STCK diff Thread insert*/
FLD: SSKITMXW TYPE(STCKTIME) DISP(432)
/*Maximum STCK diff Thread insert*/
FLD: SSKISCUW TYPE(STCKTIME) DISP(440)
/*Cumulative STCK diff SQL insert*/
FLD: SSKISMXW TYPE(STCKTIME) DISP(448) /*Maximum STCK diff SQL insert*/
FLD: SSKDTCUW TYPE(STCKTIME) DISP(456)
/*Cumulative STCK diff Thread delete*/
FLD: SSKDTMXW TYPE(STCKTIME) DISP(464)
/*Maximum STCK diff Thread delete*/
FLD: SSKDSCUW TYPE(STCKTIME) DISP(472)
/*Cumulative STCK diff SQL delete*/
FLD: SSKDSMXW TYPE(STCKTIME) DISP(480) /*Maximum STCK diff SQL delete*/
***********************************************************************
**** QEST DSECT , CF Manager Statistics
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QEST, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 2
* AND SMF115_QESTN > 0)
* NORMSMF(SMF115_QESTO)
***********************************************************************
COMP: QEST_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 2 AND SMF115_QESTN > 0)
ASSIGN(SMF115_QESTO)
ELSE ASSIGN(99999)
FLD: QEST DISP(0) LEN(4104) OFFSET(QEST_OFFSET)
/*CF Manager Statistics*/
FLD: QESTID LEN(2) DISP(0) /*Control block identifier*/
COMP: QESTIDV = X'C513' /*Control block identifier value*/
FLD: QESTLL LEN(2) TYPE(BIN) DISP(2) /*length of QEST block*/
FLD: QESTEYEC LEN(4) DISP(4) /*eyecatcher*/
FLD: QESTZERO LEN(8) DISP(8)
FLD: QESTSTUC_ARRAY LEN(4096) DISP(8)
/*Array of 64 elements (each 64 in size*/
***********************************************************************
**** QESTSTUC DSECT , Overlay the array
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QESTSTUC, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 2
* AND SMF115_QESTN > 0)
* NORMALIZE(QESTSTUC, 64)
***********************************************************************
COMP: QESTSTUC_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 2 AND SMF115_QESTN > 0)
ASSIGN(SMF115_QESTO + 8)
ELSE ASSIGN(99999)
FLD: QESTSTUC DISP(0) LEN(64) OFFSET(QESTSTUC_OFFSET)
/*Overlay the array*/
FLD: QESTSTR LEN(12) DISP(0) /*Structure name*/
FLD: QESTSTRN LEN(4) TYPE(BIN) DISP(12) /*Structure number*/
FLD: QESTCSEC LEN(4) TYPE(BIN) DISP(16) /*Number of IXLLSTE calls*/
FLD: QESTCMEC LEN(4) TYPE(BIN) DISP(20) /*Number of IXLLSTM calls*/
FLD: QESTSSTC LEN(8) DISP(24) /*Time spent doing IXLLSTE Calls*/
FLD: QESTMSTC LEN(8) DISP(32) /*Time spent doing IXLLSTM calls*/
FLD: QESTRSEC LEN(4) TYPE(BIN) DISP(40) /*Number of IXLLSTE redrives*/
FLD: QESTRMEC LEN(4) TYPE(BIN) DISP(44) /*Number of IXLLSTM redrives*/
FLD: QESTSFUL LEN(4) TYPE(BIN) DISP(48) /*Number of structure fulls*/
FLD: QESTMNUS LEN(4) TYPE(BIN) DISP(52)
/*Max number of entries in use*/
FLD: QESTMLUS LEN(4) TYPE(BIN) DISP(56)
/*Max number of elements in use*/
***********************************************************************
**** CSQDQTST DSECT , Data Manager statistics
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF CSQDQTST, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 2
* AND SMF115_QTSTN > 0)
* NORMSMF(SMF115_QTSTO)
***********************************************************************
COMP: CSQDQTST_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 2 AND SMF115_QTSTN > 0)
ASSIGN(SMF115_QTSTO)
ELSE ASSIGN(99999)
FLD: CSQDQTST DISP(0) LEN(104) OFFSET(CSQDQTST_OFFSET)
/*Data Manager statistics*/
FLD: QTST LEN(8) DISP(0)
FLD: QTSTID LEN(2) DISP(0) /*Control block ID ('A302')*/
FLD: QTSTLL LEN(2) TYPE(BIN) DISP(2) /*Length of control block*/
FLD: QTSTEYEC LEN(4) DISP(4) /*Control block eyecatcher 'QTST'*/
FLD: QTSTSTOT LEN(4) TYPE(BIN) DISP(8) /*Total subscription requests*/
FLD: QTSTSDUR LEN(4) TYPE(BIN) DISP(12)
/*Durable subscription requests*/
* 1=API, 2=ADMIN, 3 = PROXY
FLD: QTSTSHIG LEN(4) TYPE(BIN) DISP(16) /*Sub. high water mark array*/
FLD: QTSTSLOW LEN(4) TYPE(BIN) DISP(28) /*Sub. low water mark array*/
FLD: QTSTSEXP LEN(4) TYPE(BIN) DISP(40) /*Subscriptions expired*/
FLD: QTSTTMSG LEN(4) TYPE(BIN) DISP(44) /*Total msgs put to Sub queue*/
FLD: QTSTSPHW LEN(4) TYPE(BIN) DISP(48) /*Single pub subscriber HW.*/
* 1=API, 2=ADMIN, 3 = PROXY
FLD: QTSTPTOT LEN(4) TYPE(BIN) DISP(52) /*Total Publication requests*/
FLD: QTSTPHIG LEN(4) TYPE(BIN) DISP(64) /*Pub. high water mark array*/
FLD: QTSTPLOW LEN(4) TYPE(BIN) DISP(68) /*Pub. low water mark array*/
FLD: QTSTPNOS LEN(4) TYPE(BIN) DISP(72)
/*Count of publishes to no SUB*/
FLD: QTSTETHW TYPE(STCKTIME) DISP(80) /*Elapse time HW on publish*/
FLD: QTSTETTO TYPE(STCKTIME) DISP(88) /*Elapse time total on publish*/
***********************************************************************
**** CSQDQESD DSECT , CF Manager data set stats V7.1
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF CSQDQESD, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 2
* AND SMF115_QESDN > 0)
* NORMSMF(SMF115_QESDO)
***********************************************************************
COMP: CSQDQESD_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 2 AND SMF115_QESDN > 0)
ASSIGN(SMF115_QESDO)
ELSE ASSIGN(99999)
FLD: CSQDQESD DISP(0) LEN(328) OFFSET(CSQDQESD_OFFSET)
/*CF Manager data set stats V7.1*/
FLD: QESD LEN(328) DISP(0) /*CF Manager data set statistics*/
FLD: QESDID LEN(2) DISP(0) /*Control block identifier*/
FLD: QESDLL LEN(2) TYPE(BIN) DISP(2) /*Control block length*/
FLD: QESDEYEC LEN(4) DISP(4) /*Control block eyecatcher 'QESD'*/
FLD: QESDSTR LEN(12) DISP(8) /*Application structure name*/
FLD: QESDSTRN LEN(4) TYPE(BIN) DISP(20) /*Structure number*/
FLD: QESDSM LEN(72) DISP(24) /*SMDS space map statistics*/
FLD: QESDSMU LEN(24) DISP(24) /*Space map usage information*/
FLD: QESDSMBT LEN(4) TYPE(BIN) DISP(24)
/*Logical blocks total for SMDS*/
FLD: QESDSMBS LEN(4) TYPE(BIN) DISP(28)
/*Logical blocks for space map*/
FLD: QESDSMBD LEN(4) TYPE(BIN) DISP(32)
/*Logical blocks for message data*/
FLD: QESDSMBU LEN(4) TYPE(BIN) DISP(36)
/*Data blocks currently in use*/
FLD: QESDSMBF LEN(4) TYPE(BIN) DISP(40) /*Data blocks currently free*/
FLD: QESDSMMC LEN(4) TYPE(BIN) DISP(44)
/*Count of messages in data set*/
FLD: QESDSMC LEN(36) DISP(48) /*Request and result counts*/
FLD: QESDSMAR LEN(4) TYPE(BIN) DISP(48) /*Allocated space for message*/
FLD: QESDSMFR LEN(4) TYPE(BIN) DISP(52) /*Freed space*/
FLD: QESDSMRR LEN(4) TYPE(BIN) DISP(56)
/*Reallocated space (for restart)*/
FLD: QESDSMCR LEN(4) TYPE(BIN) DISP(60)
/*Cleaned up space (normal close)*/
FLD: QESDSMAP LEN(4) TYPE(BIN) DISP(64) /*Allocated pages*/
FLD: QESDSMFP LEN(4) TYPE(BIN) DISP(68) /*Freed pages*/
FLD: QESDSMRP LEN(4) TYPE(BIN) DISP(72) /*Reallocated pages*/
FLD: QESDSMCP LEN(4) TYPE(BIN) DISP(76) /*Clean up pages released*/
FLD: QESDSMFL LEN(4) TYPE(BIN) DISP(80)
/*Allocate failed, data set full*/
FLD: QESDSMM LEN(12) DISP(84) /*Maximum and minimum values*/
FLD: QESDSMMM LEN(4) TYPE(BIN) DISP(84) /*Maximum message count*/
FLD: QESDSMMU LEN(4) TYPE(BIN) DISP(88) /*Maximum used blocks*/
FLD: QESDSMMF LEN(4) TYPE(BIN) DISP(92) /*Minimum free blocks*/
FLD: QESDBF LEN(120) DISP(96) /*SMDS buffer pool statistics*/
FLD: QESDBFU LEN(32) DISP(96) /*Usage values*/
FLD: QESDBFSZ LEN(4) TYPE(BIN) DISP(96) /*Buffer size in bytes*/
FLD: QESDBFTO LEN(4) TYPE(BIN) DISP(100) /*Total buffers in pool*/
FLD: QESDBFUS LEN(4) TYPE(BIN) DISP(104) /*Used shared buffers*/
FLD: QESDBFUP LEN(4) TYPE(BIN) DISP(108) /*Used private buffers*/
FLD: QESDBFFS LEN(4) TYPE(BIN) DISP(112) /*Free saved buffers*/
FLD: QESDBFFE LEN(4) TYPE(BIN) DISP(116) /*Free empty buffers*/
FLD: QESDBFPW LEN(4) TYPE(BIN) DISP(120)
/*Pool waiters (for any buffer)*/
FLD: QESDBFBW LEN(4) TYPE(BIN) DISP(124)
/*Buffer waiters (buffer busy)*/
FLD: QESDBFC LEN(72) DISP(128) /*Request counts and times*/
FLD: QESDBFGB LEN(4) TYPE(BIN) DISP(128)
/*Number of times got a buffer*/
FLD: QESDBFGV LEN(4) TYPE(BIN) DISP(132) /*Got valid buffer*/
FLD: QESDBFGM LEN(4) TYPE(BIN) DISP(136)
/*Got matching buffer but empty*/
FLD: QESDBFGF LEN(4) TYPE(BIN) DISP(140) /*Got a free empty buffer*/
FLD: QESDBFGL LEN(4) TYPE(BIN) DISP(144)
/*Got (stole) LRU saved buffer*/
FLD: QESDBFGN LEN(4) TYPE(BIN) DISP(148)
/*Got no buffer (conditional)*/
FLD: QESDBFRR LEN(4) TYPE(BIN) DISP(152) /*Number of read requests*/
FLD: QESDBFRS LEN(4) TYPE(BIN) DISP(156) /*Number of times read saved*/
FLD: QESDBFRP LEN(4) TYPE(BIN) DISP(160)
/*Number of times read partial*/
FLD: QESDBFWR LEN(4) TYPE(BIN) DISP(164) /*Number of write requests*/
FLD: QESDBFFB LEN(4) TYPE(BIN) DISP(168)
/*Freed buffer with valid data*/
FLD: QESDBFDB LEN(4) TYPE(BIN) DISP(172) /*Discarded buffer as empty*/
FLD: QESDBFWP LEN(4) TYPE(BIN) DISP(176)
/*Waited for pool (free buffer)*/
FLD: QESDBFWB LEN(4) TYPE(BIN) DISP(180)
/*Waited for buffer (when busy)*/
FLD: QESDBFPT TYPE(STCKTIME) DISP(184) /*Total pool wait time*/
FLD: QESDBFBT TYPE(STCKTIME) DISP(192) /*Total buffer wait time*/
FLD: QESDBFM LEN(16) DISP(200) /*Maximum and minimum values*/
FLD: QESDBFMU LEN(4) TYPE(BIN) DISP(200) /*Maximum used buffers*/
FLD: QESDBFMF LEN(4) TYPE(BIN) DISP(204) /*Minimum free buffers*/
FLD: QESDBFMP LEN(4) TYPE(BIN) DISP(208) /*Max number of pool waiters*/
FLD: QESDBFMB LEN(4) TYPE(BIN) DISP(212)
/*Max number of buffer waiters*/
FLD: QESDIO LEN(112) DISP(216) /*SMDS I/O statistics*/
FLD: QESDIOU LEN(16) DISP(216) /*Data set usage values*/
FLD: QESDIOHA LEN(4) TYPE(BIN) DISP(216)
/*High allocated control interval*/
FLD: QESDIOHU LEN(4) TYPE(BIN) DISP(220) /*High used control interval*/
FLD: QESDIOCI LEN(4) TYPE(BIN) DISP(224) /*Control interval size*/
FLD: QESDIOCA LEN(4) TYPE(BIN) DISP(228) /*Control area size*/
FLD: QESDIOC LEN(96) DISP(232) /*Request counts, pages and times*/
FLD: QESDIOF LEN(24) DISP(232) /*Format write statistics*/
FLD: QESDIOFR LEN(4) TYPE(BIN) DISP(232)
/*Format write (extend) requests*/
FLD: QESDIOFP LEN(4) TYPE(BIN) DISP(236) /*Format total pages*/
FLD: QESDIOFT LEN(8) DISP(240) /*Format I/O time*/
FLD: QESDIOFW TYPE(STCKTIME) DISP(248) /*Format wait time*/
FLD: QESDIOW LEN(24) DISP(256) /*Normal write statistics*/
FLD: QESDIOWR LEN(4) TYPE(BIN) DISP(256) /*Write requests*/
FLD: QESDIOWP LEN(4) TYPE(BIN) DISP(260) /*Write total pages*/
FLD: QESDIOWT LEN(8) DISP(264) /*Write I/O time*/
FLD: QESDIOWW TYPE(STCKTIME) DISP(272) /*Write wait time*/
FLD: QESDIOR LEN(24) DISP(280) /*Reads from owned data set*/
FLD: QESDIORR LEN(4) TYPE(BIN) DISP(280) /*Local read requests*/
FLD: QESDIORP LEN(4) TYPE(BIN) DISP(284) /*Local read total pages*/
FLD: QESDIORT LEN(8) DISP(288) /*Local read I/O time*/
FLD: QESDIORW TYPE(STCKTIME) DISP(296) /*Local read wait time*/
FLD: QESDIOO LEN(24) DISP(304) /*Reads from other data sets*/
FLD: QESDIOOR LEN(4) TYPE(BIN) DISP(304) /*Other read requests*/
FLD: QESDIOOP LEN(4) TYPE(BIN) DISP(308) /*Other read total pages*/
FLD: QESDIOOT LEN(8) DISP(312) /*Other read I/O time*/
FLD: QESDIOOW TYPE(STCKTIME) DISP(320) /*Other read wait time*/
***********************************************************************
**** CSQDQCCT DSECT , Chinit control info. Sub 231
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF CSQDQCCT, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 231
* AND QWSX0R1N > 0)
* NORMSMF(QWSX0R1O)
***********************************************************************
COMP: CSQDQCCT_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 231 AND QWSX0R1N > 0)
ASSIGN(QWSX0R1O)
ELSE ASSIGN(99999)
FLD: CSQDQCCT DISP(0) LEN(48) OFFSET(CSQDQCCT_OFFSET)
/*Chinit control info. Sub 231*/
FLD: QCCT LEN(8) DISP(0)
FLD: QCCTID LEN(2) DISP(0) /*Control block ID*/
FLD: QCCTLL LEN(2) TYPE(BIN) DISP(2) /*Length of control block*/
FLD: QCCTEYEC LEN(4) DISP(4) /*Control block eyecatcher*/
FLD: QCCTJOBN LEN(8) DISP(8) /*Chinit job name*/
FLD: QCCTQSGN LEN(4) DISP(16) /*QSG name*/
FLD: QCCTNOCC LEN(4) TYPE(BIN) DISP(20)
/*High water mark of current chls*/
FLD: QCCTMXCC LEN(4) TYPE(BIN) DISP(24) /*Maximum current channels*/
FLD: QCCTNOAC LEN(4) TYPE(BIN) DISP(28)
/*High water mark of active chls*/
FLD: QCCTMXAC LEN(4) TYPE(BIN) DISP(32) /*Maximum active channels*/
FLD: QCCTMXTP LEN(4) TYPE(BIN) DISP(36) /*Maximum TCP/IP channels*/
FLD: QCCTMXLU LEN(4) TYPE(BIN) DISP(40) /*Maximum LU 6.2 channels*/
FLD: QCCTSTUS LEN(4) TYPE(BIN) DISP(44) /*Storage usage for Chinit*/
***********************************************************************
**** QCT_DSP DSECT ,
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QCT_DSP, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 231
* AND QWSX0R2N > 0)
* NORMSMF(QWSX0R2O)
***********************************************************************
COMP: QCT_DSP_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 231 AND QWSX0R2N > 0)
ASSIGN(QWSX0R2O)
ELSE ASSIGN(99999)
FLD: QCT_DSP DISP(0) LEN(4) OFFSET(QCT_DSP_OFFSET)
FLD: QCTCHLN LEN(4) TYPE(BIN) DISP(0)
/*Num of channels running on this disp task*/
*
***********************************************************************
**** QCT_ADP DSECT ,
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QCT_ADP, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 231
* AND QWSX0R3N > 0)
* NORMSMF(QWSX0R3O)
***********************************************************************
COMP: QCT_ADP_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 231 AND QWSX0R3N > 0)
ASSIGN(QWSX0R3O)
ELSE ASSIGN(99999)
FLD: QCT_ADP DISP(0) LEN(4) OFFSET(QCT_ADP_OFFSET)
*
***********************************************************************
**** QCT_SSL DSECT ,
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QCT_SSL, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 231
* AND QWSX0R4N > 0)
* NORMSMF(QWSX0R4O)
***********************************************************************
COMP: QCT_SSL_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 231 AND QWSX0R4N > 0)
ASSIGN(QWSX0R4O)
ELSE ASSIGN(99999)
FLD: QCT_SSL DISP(0) LEN(16) OFFSET(QCT_SSL_OFFSET)
FLD: QCTQCTLSTM TYPE(STCKTIME) DISP(0) /*Time of day of max SSL req*/
FLD: QCTQCTLSDU TYPE(STCKTIME) DISP(8) /*Duration of max SSL req*/
*
***********************************************************************
**** QCT_DNS DSECT ,
***********************************************************************
***********************************************************************
* TO REPORT ON ALL OCCURRENCES OF QCT_DNS, USE:
* INPUT: SMF115
* NORMWHEN(SMF115RTY = 115 AND SMF115STF = 231
* AND QWSX0R5N > 0)
* NORMSMF(QWSX0R5O)
***********************************************************************
COMP: QCT_DNS_OFFSET =
WHEN(SMF115RTY = 115 AND SMF115STF = 231 AND QWSX0R5N > 0)
ASSIGN(QWSX0R5O)
ELSE ASSIGN(99999)
FLD: QCT_DNS DISP(0) LEN(16) OFFSET(QCT_DNS_OFFSET)
FLD: QCTQCTLGTM TYPE(STCKTIME) DISP(0) /*Time of day of max DNS req*/
FLD: QCTQCTLGDU TYPE(STCKTIME) DISP(8) /*Duration of max DNS req*/
FLD: SMF115_END LEN(1) OFFSET(0) |
In this report, we read the SMF file and select just the type 115 subtype 2 Websphere MQ performance statistics records. (See SMF 115 record layout.) We use all of the the multiply recurring QPST (Buffer Pool Management) sections from each SMF record to show statistics for each subpool during the period just ended.
The statistics include number of buffer pools, number of stealable buffers, lowest number of stealable buffers during the period, actual number of buffer steals, number of get page old and get page new requests, count of DASD read and write ops, pages written to DASD, etc.
All of this with just a few lines of code!
Sample Report from SMF 115 Subtype 2 Records
Showing Statistics on Buffer Pool Management
The sample SMF report below was created with Spectrum SMF Writer,
the low-cost 4GL SMF report writer.
Why not install a Spectrum SMF Writer trial right now and start making your own SMF reports!
These Spectrum SMF Writer Statements:
INPUT: SMF115
NORMWHEN(SMF115RTY=115 AND SMF115STF=2 AND SMF115_QPSTN>0)
NORMALIZE(QPST_SECTION, SMF115_QPSTN)
INCLUDEIF: SMF115RTY = 115 AND SMF115STF = 2
COLUMNS:
SMF115SID('Z/OS|SUB|SYSTEM')
SMF115TME('PERIOD|ENDING' TPIC'Z9:99:99')
QPSTPOOL('BUFFER|POOL|NUMBER' 6)
QPSTNBUF('# OF|BUFFERS|IN POOL' 8)
QPSTCBSL('LOWEST|# OF|STEALABLE|BUFFERS' 9)
QPSTCBS('# OF|STEALABLE|BUFFERS' 9)
QPSTSTL('# OF|BUFFER|STEALS' 9)
QPSTGETP('# OF|GET PAGE|(OLD)|REQUESTS' 11)
QPSTGETN('# OF|GET PAGE|(NEW)|REQUESTS' 11)
QPSTRIO('# OF|DASD|READ|OPS' 6)
QPSTSTW('# OF|SET WRITE|INTENT|REQUESTS' 9)
QPSTTPW('# OF|PAGES|WRITTEN|TO DASD' 9)
QPSTWIO('# OF|DASD|WRITE|OPS' 6)
TITLE: 'SMF 115 - WEBSPHERE MQ PERFORMANCE REPORT'
TITLE: 'BUFFER POOL MANAGER STATISTICS'
Produce This SMF Report:
SMF 115 - WEBSPHERE MQ PERFORMANCE REPORT
BUFFER POOL MANAGER STATISTICS
LOWEST # OF # OF # OF # OF # OF # OF
Z/OS BUFFER # OF # OF # OF # OF GET PAGE GET PAGE DASD SET WRITE PAGES DASD
SUB PERIOD POOL BUFFERS STEALABLE STEALABLE BUFFER (OLD) (NEW) READ INTENT WRITTEN WRITE
SYSTEM ENDING NUMBER IN POOL BUFFERS BUFFERS STEALS REQUESTS REQUESTS OPS REQUESTS TO DASD OPS
______ ________ ______ ________ _________ _________ _________ ___________ ___________ ___________ ___________ _________ ______
ZSA 11:00:07 0 50,000 49,618 49,943 0 833,658 26,025 0 736,158 386 112
ZSA 11:00:07 1 20,000 17,424 18,457 0 1,318,813 507,094 0 1,016,252 2,518 689
ZSA 11:00:07 2 50,000 49,990 49,993 0 2,962 528 0 2,962 14 14
ZSA 11:00:07 3 20,000 19,830 19,885 0 198,242 5,373 0 56,514 144 41
ZSA 11:00:07 4 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 5 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 6 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 7 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 8 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 9 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 10 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 11 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 12 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 13 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 14 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:07 15 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 0 50,000 49,972 49,972 0 38 0 0 28 0 0
ZSA 11:00:36 1 20,000 19,999 19,999 0 0 0 0 0 0 0
ZSA 11:00:36 2 50,000 49,995 49,995 0 5 1 0 5 0 0
ZSA 11:00:36 3 20,000 19,992 19,992 0 20 4 0 20 0 0
ZSA 11:00:36 4 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 5 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 6 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 7 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 8 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 9 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 10 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 11 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 12 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 13 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 14 0 0 0 0 0 0 0 0 0 0
ZSA 11:00:36 15 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 0 7,000 6,945 6,947 0 944,557 20,985 0 888,051 102 36
ZSC 11:24:43 1 5,000 4,997 4,997 0 12 0 0 12 12 12
ZSC 11:24:43 2 80,000 21,100 26,499 0 1,143,307 1,222,176 0 1,781,528 107,246 26,832
ZSC 11:24:43 3 5,000 4,871 4,917 3,699,704 226,849,650 22,659 3,698,301 179,207 230 66
ZSC 11:24:43 4 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 5 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 6 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 7 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 8 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 9 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 10 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 11 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 12 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 13 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 14 0 0 0 0 0 0 0 0 0 0
ZSC 11:24:43 15 0 0 0 0 0 0 0 0 0 0
*** GRAND TOTAL ( 48 ITEMS)
360 377,000 314,733 321,596 3,699,704 231,291,264 1,804,845 3,698,301 4,660,737 110,652 27,802
