|
|
|
The DBPDSB (DB2 Buffer Pool Activity) File
---------------------------------------------------------------------------------------------------------------------------------- DICTIONARY RAW AVAILABLE IN DB2 VERSIONS ELEMENT ELEMENT DESCRIPTION MEMBER ELEMENT 8.1 9.1 10.1 ---------------------------------------------------------------------------------------------------------------------------------- DB2DSGN Data Sharing Group Name DB2DSGN QWHADSGN | X | X | X | DB2ISEQ Instrumentation Sequence Number DB2ISEQ QWHSISEQ | X | X | X | DB2MEMN DB2 Member Name DB2MEMN QWHAMEMN | X | X | X | DB2PID DB2 Buffer Pool Identifier DB2PID QBACPID | X | X | X | DB2RELN DB2 Release Identifier DB2RELN QWHSRELN | X | X | X | DSBABBP Active Buffers in Buffer Pool DSBABBP QBSTCBA | X | X | X | DSBACZ CF Writes Clean Pages DSBACZ QBGLAC | X | X | X | DSBAWZ CF Writes Changed Pages DSBAWZ QBGLAW | X | X | X | DSBBPSO Buffer Pool Data Sets Opened DSBBPSO QBSTDSO | X | X | X | DSBCIO Castout I/O Operations DSBCIO QBSTCIO | | X | X | DSBCMZ Read for Castout Multiple Requests DSBCMZ QBGLCM | X | X | X | DSBCNZ Castout Engine Not Available DSBCNZ QBGLCN | | | | DSBCRZ Read for Castout Requests DSBCRZ QBGLCR | X | X | X | DSBCTZ Castout Class Threshold Detected DSBCTZ QBGLCT | X | X | X | DSBDBPR Physical Database Page Requests DSBDBPR QBSTGET | X | X | X | DSBDBPU Database Page Updates DSBDBPU QBSTSWS | X | X | X | DSBDIO Async Read I/Os via Dynamic Prefetch DSBDIO QBSTDIO | X | X | X | DSBDMCT No. Times DM Critical WPHFWT Reached DSBDMCT QBSTDMC | X | X | X | DSBDPF No. Times Dynamic Prefetch Req. DB2DPF QBACDPF | X | X | X | DSBDPP Async Page Reads via Dynamic Pref. DSBDPP QBSTDPP | X | X | X | DSBDWRT Times Deferred Write Threshold Reached DSBDWRT QBSTDWT | X | X | X | DSBDWV Times Vert. Defer. Write Thresh DSBDWV QBSTDWV | X | X | X | DSBEXZ Explicit XIs DSBEXZ QBGLEX | X | X | X | DSBGGZ GETPAGEs for GBP-Dependent Pagesets DSBGGZ QBGLGG | X | X | X | DSBGTZ Group BP Castout Threshold Detected DSBGTZ QBGLGT | X | X | X | DSBIMWS Count of Immediate Writes System Pages DSBIMWS QBSTIMW | X | X | X | DSBJIS Total No. Pref. I/O Streams Denied DSBJIS QBSTJIS | X | X | X | DSBLIO Async Read I/Os via List Prefetch DSBLIO QBSTLIO | X | X | X | DSBLPF List Prefetch Requested DB2LPF QBSTLPF | X | X | X | DSBLPL No. LPL Inserts DSBLPL QBSTLPL | X | X | X | DSBLPP Async Page Reads via List Prefetch DSBLPP QBSTLPP | X | X | X | DSBMAX BP Not Supp Concur WK File DSBMAX QBSTMAX | X | X | X | DSBMDZ CF Reads Data Returned DSBMDZ QBGLMD | X | X | X | DSBMMRR Media Manager Read Requests DSBMMRR QBSTRIO | X | X | X | DSBMRZ CF Reads Data Not Returned Entry DSBMRZ QBGLMR | X | X | X | DSBNGT No. GETPAGE Requests Not Satisfied DB2NGT QBSTNGT | X | X | X | DSBNSG No. Seq GETPAGE Failures DSBNSG QBSTNSG | X | X | X | DSBOSZ Other CF Requests DSBOSZ QBGLOS | X | X | X | DSBPCO Pages Written for Castout I/Os DSBPCO QBSTPCO | | X | X | DSBPL1 Total Times Pref. Qty 1/2 Normal DSBPL1 QBSTPL1 | X | X | X | DSBPL2 Total Times Pref. Qty 1/4 Normal DSBPL2 QBSTPL2 | X | X | X | DSBRCZ Pages Castout to DASD DSBRCZ QBGLRC | X | X | X | DSBREEP Prefetch Request Disabled No Read DSBREEP QBSTREE | X | X | X | DSBRFXS Read Page-Fixed without Real Storage DSBRFXS QBSTRPI | X | X | X | DSBRFZ CF Read Requests No Storage DSBRFZ QBGLRF | | | | DSBSIO Sync Read I/Os Seq Access Req DB2SIO QBSTSIO | X | X | X | DSBSPDF Prefetch Request Disabled No Buffer DSBSPDF QBSTSPD | X | X | X | DSBSPPF Number of Pages Read Due to Prefetch DSBSPPF QBSTSPP | X | X | X | DSBSPWR System Pages Written to DASD DSBSPWR QBSTPWS | X | X | X | DSBSSEF Storage Shortage Expansion Fails DSBSSEF QBSTXFV | X | X | X | DSBSUZ CF Write Engine Not Available DSBSUZ QBGLSU | | | | DSBSWZ CF Writes For Changed Pages DSBSWZ QBGLSW | X | X | X | DSBTMIG No. Migrated Datasets Encountered DSBTMIG QBSTMIG | X | X | X | DSBTPF0 WK PF Abort - 0 PF QTY DSBTPF0 QBSTWKPD | X | X | X | DSBTPIO No. Prefetch Async Read I/Os DSBTPIO QBSTPIO | X | X | X | DSBTRTO No. Recall Time Outs DSBTRTO QBSTRTO | X | X | X | DSBVPA Successful VPOOL Expand/Contract DSBVPA QBSTVPA | X | X | X | DSBVPL No. Buffers Allocated for a VPOOL DSBVPL QBSTVPL | X | X | X | DSBWCZ CF Writes For Clean Pages DSBWCZ QBGLWC | X | X | X | DSBWDRP Pages Destruct Read Req DSBWDRP QBSTWDRP | X | X | X | DSBWFD Work Files Denied Sort Merge DSBWFD QBSTWFD | X | X | X | DSBWFF Poor Sort Merge - Buf Short DSBWFF QBSTWFF | X | X | X | DSBWFM Max WK File Alloc Sort Merge DSBWFM QBSTWFM | X | X | X | DSBWFR Req Query WK File Sort Merge DSBWFR QBSTWFR | X | X | X | DSBWFT Work Files Req Sort Merge DSBWFT QBSTWFT | X | X | X | DSBWFXS Write Page Fixed W/O Real Storage DSBWFXS QBSTWPI | X | X | X | DSBWFZ CF Write Requests No Storage DSBWFZ QBGLWF | X | X | X | DSBWMZ Write and Register Multiple Requests DSBWMZ QBGLWM | X | X | X | DSBWPZ Pages Written via WARM DSBWPZ QBGLWP | X | X | X | DSBWREE No. Times Write Engine Unavailable DSBWREE QBSTWEE | X | | | DSBWRMM Write I/Os By Media Manager DSBWRMM QBSTWIO | X | X | X | DSBWSZ Write and Register Requests DSBWSZ QBGLWS | X | X | X | DSBXDZ CF Reads Buffer XI DSBXDZ QBGLXD | X | X | X | DSBXFL Buffer Not Located -- VPOOL Full DSBXFL QBSTXFL | X | X | X | DSBXIS Max No. Concurrent Pref. Streams DSBXIS QBSTXIS | X | X | X | DSBXRZ CF Reads Entry Created DSBXRZ QBGLXR | X | X | X | ----------------------------------------------------------------------------------------------------------------------------------
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |