|
|
|
The DBPDBP (DB2 Plan Buffer Pool Activity) File
---------------------------------------------------------------------------------------------------------------------------------- DICTIONARY RAW AVAILABLE IN DB2 VERSIONS ELEMENT ELEMENT DESCRIPTION MEMBER ELEMENT 8.1 9.1 10.1 ---------------------------------------------------------------------------------------------------------------------------------- DBPCIMW No. of Immed. Sync Write I/Os DB2CIMW QBACIMW | X | X | X | DBPDPF No. Times Dynamic Prefetch Req DB2DPF QBACDPF | X | X | X | DBPGPGR GETPAGE Requests DB2GPGR QBACGET | X | X | X | DBPLPF No. Times LIST PREFETCH req. DB2LPF QBACLPF | X | X | X | DBPNGT No. Time GETPAGE Req Not Satisfied DB2NGT QBACNGT | X | X | X | DBPPRFH PREFETCH Read Requests DB2PRFH QBACSEQ | X | X | X | DBPSIO No. Async Pages Read by Prefetch DB2SIO QBSTSIO | X | X | X | DBPSPRU System Page Record Update DB2SPRU QBACSWS | X | X | X | DBPSRIO Synchronous Read I/Os DB2SRIO QBACRIO | X | X | X | DB2ACE DB2 Agent Control Element DB2ACE QWHSACE | X | X | X | DB2ATNM Active Trace Number Mask DB2ATNM QWHSMTN | X | X | X | DB2AUTH Authorization Identifier DB2AUTH QWHCAID | X | X | X | DB2CONN Connection Identifier DB2CONN QWHCCN | X | X | X | DB2CORR Correlation Identifier DB2CORR QWHCCV | X | X | X | DB2CPU DB2 CPU Time DB2CPU QWHUCPU | X | X | X | DB2DDFCT DDF COMMIT Count DB2DDFCT QWHSLUCC | X | X | X | DB2DSGN Data Sharing Group Name DB2DSGN QWHADSGN | X | X | X | DB2DSTSN Destination Sequence Number DB2DSTSN QWHSWSEQ | X | X | X | DB2ISEQ Instrumentation Sequence Number DB2ISEQ QWHSISEQ | X | X | X | DB2LOCN DDF Local Location ID DB2LOCN QWHSLOCN | X | X | X | DB2LUNAM DB2 Logical Unit Name DB2LUNAM QWHSLUNM | X | X | X | DB2MEMN DB2 Member Name DB2MEMN QWHAMEMN | X | X | X | DB2NETID Network Identifier DB2NETID QWACNID | X | X | X | DB2OPID Original Operator ID DB2OPID QWHCOPID | X | X | X | DB2PID DB2 Buffer Pool Identifier DB2PID QBSTPID | X | X | X | DB2PLAN Plan Name DB2PLAN QWHCPLAN | X | X | X | DB2RELN DB2 Release Identifier DB2RELN QWHSRELN | X | X | X | DB2REQID DDF Requester Location ID DB2REQID QWHDRQNM | X | X | X | DB2STCK DB2 Store Clock At End Event DB2STCK QWHSSTCK | X | X | X | DB2UNIQ DDF Instance Number Identifier DB2UNIQ QWHSLUUV | X | X | X |
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |