Previous Topic: The DBPDBP (DB2 Plan Buffer Pool Activity) File

Next Topic: The DB2DDP (DB2 Plan DDF Activity) File

The DBPDBU (DB2 User Buffer Pool Activity) File

The DBPDBU (DB2 User Buffer Pool Activity) File

---------------------------------------------------------------------------------------------------------------------------------- DICTIONARY RAW AVAILABLE IN DB2 VERSIONS ELEMENT ELEMENT DESCRIPTION MEMBER ELEMENT 8.1 9.1 10.1 ---------------------------------------------------------------------------------------------------------------------------------- DBUCIMW No. of Immed. Sync Write I/Os DB2CIMW QBACIMW | X | X | X | DBUDPF No. Times Dynamic Prefetch Req DB2DPF QBACDPF | X | X | X | DBUGPGR GETPAGE Requests DB2GPGR QBACGET | X | X | X | DBULPF No. Times LIST PREFETCH req. DB2LPF QBACLPF | X | X | X | DBUNGT No. Time GETPAGE Req Not Satisfied DB2NGT QBACNGT | X | X | X | DBUPRFH PREFETCH Read Requests DB2PRFH QBACSEQ | X | X | X | DBUSIO No. Async Pages Read by Prefetch DB2SIO QBSTSIO | X | X | X | DBUSPRU System Page Record Update DB2SPRU QBACSWS | X | X | X | DBUSRIO 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 | ----------------------------------------------------------------------------------------------------------------------------------