|
|
|
The DB2DPP (DB2 Package/DBRM Activity) File
---------------------------------------------------------------------------------------------------------------------------------- DICTIONARY RAW AVAILABLE IN DB2 VERSIONS ELEMENT ELEMENT DESCRIPTION MEMBER ELEMENT 8.1 9.1 10.1 ---------------------------------------------------------------------------------------------------------------------------------- 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 | DB2CRDNT CICS/RRSAF/DB Access Network Name DB2CRDNT QWHCTOKN | | | | DB2CRDLU CICS/RRSAF/DB Access LU Name DB2CRDLU QWHCTOKN | | | | DB2CRDUV CICS/RRSAF/DB Access Uniqueness Value DB2CRDUV QWHCTOKN | | | | 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 | DB2NETID Network Identifier DB2NETID QWACNID | X | X | X | DB2OPID Original Operator ID DB2OPID QWHCOPID | X | X | X | DB2PKNM Package/DBRM Name DB2PKNM QPACCOLN | X | X | X | DB2PKNM Package/DBRM Name DB2PKNM QPACCONT | X | X | X | DB2PKNM Package/DBRM Name DB2PKNM QPACLOCN | X | X | X | DB2PKNM Package/DBRM Name DB2PKNM QPACPKID | X | X | X | DB2PKNM Package/DBRM Name DB2PKNM QPACPKNM | 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 | DPPAAFG Activity Flag DPPAAFG QPACAAFG | X | X | X | DPPAANM Name of Activity DPPAANM QPACAANM | X | X | X | DPPALGTM Accum Wait Archive Log DPPALGTM QPACALOG | X | X | X | DPPALLTM Accum Lock/Latch Time DPPALLTM QPACAWTL | X | X | X | DPPALWTM Accum Wait Time - Latch Suspension DPPALWTM QPACAWLH | | | X | DPPARLCT Archive Log Suspensions DPPARLCT QPACALCT | X | X | X | DPPASCH Nested Activity Schema Name DPPASCH QPACASCH | X | X | X | DPPAWATM Accum Wt Time - Log Reads DPPAWATM QPACAWAR | X | X | X | DPPAWBTM Accum Wt Time - TCP/IP LOB Material. DPPAWBTM QPACALBW | | X | X | DPPAWCTM Accum Wt Time - Drain Wait DPPAWCTM QPACAWCL | X | X | X | DPPAWDTM Accum Wait Time - Drain Lock DPPAWDTM QPACAWDR | X | X | X | DPPAWETM Accum Wait Sync Exec Unit Switch DPPAWETM QPACAWTE | X | X | X | DPPAWGTM Accum Wait Time - Sending Messages DPPAWGTM QPACAWTG | X | X | X | DPPAWITM Accum I/O Elapsed Time This Thread DPPAWITM QPACAWTI | X | X | X | DPPAWJTM Accum Wait Time - Global Lock Contention DPPAWJTM QPACAWTJ | X | X | X | DPPAWPTM Accum Wait Time - Latch Contention DPPAWPTM QPACAWTP | X | X | X | DPPAWRTM Accum Wait Read Other Time DPPAWRTM QPACAWTR | X | X | X | DPPAWWTM Accum Wait Write Other Time DPPAWWTM QPACAWTW | X | X | X | DPPBEGSC Package/DBRM Beginning Store Clock DPPBEGSC QPACSCB | X | X | X | DPPBGTCB Package/DBRM TCB Time at Entry to DB2 DPPBGTCB QPACBJST | X | X | X | DPPCLS7 No. Packages/DBRMs With Class 7 Data DPPCLS7 QPACFLGS | X | X | X | DPPCLS8 No. Packages/DBRMs With Class 8 Data DPPCLS8 QPACFLGS | X | X | X | DPPDBRM Number of DBRMs DPPDBRM QPACFLGS | X | X | | DPPENDSC Package/DBRM Ending Store Clock DPPENDSC QPACSCE | X | X | X | DPPENTCB Package/DBRM TCB Time At Exit From DB2 DPPENTCB QPACEJST | X | X | X | DPPENTEX Entry/Exit Events Processed DPPENTEX QPACARNA | X | X | X | DPPFLGS Program Type Execution Flags DPPFLGS QPACFLGS | X | X | X | DPPINSP No. Packages Loaded by Stored Proc. DPPINSP QPACFLGS | X | X | X | DPPNSTP Number of Native SQL Procedures DPPNSTP QPACAAFG | | X | X | DPPNIUDF Non-Inline User Defined Function DPPNIUDF QPACAAFG | | | X | DPPPACK Number of Packages DPPPACK QPACFLGS | X | X | | DPPRLNU No. Threads Roll Data to Pkg Section DPPRLNU QPACRLNU | | | X | DPPRNKCL No. Wait Trace Glbl Cont. Child LLock DB2RNKCL QPACARNK | X | X | X | DPPRNMOL No. Wait Trace Glbl Cont. Other LLock DB2RNMOL QPACARNM | X | X | X | DPPRNNPL No. Wait Trace Glbl Cont. PP PLock DB2RNNPL QPACARNN | X | X | X | DPPRNOPL No. Wait Trace Glbl Cont. PG PLock DB2RNOPL QPACARNO | X | X | X | DPPRNQOL No. Wait Trace Glbl Cont. Other PLock DB2RNQOL QPACARNQ | X | X | X | DPPROLL Package Roll Up Flag DPPROLL QPACFLGS | | | X | DPPRUSM Package Summary Roll Up Flag DPPRUSM QPACFLGS | | | X | DPPSPNS No. Stored Procedures Executed DPPSPNS QPACSPNS | X | X | X | DPPSQLC Sql Stmts Issued DPPSQLC QPACSQLC | X | X | X | DPPSTPR Number of External Stored Procedures DPPSTPR QPACAAFG | X | X | X | DPPSUAC No. Successful Authorization Checks DPPSUAC QPACFLGS | X | X | X | DPPSWTCH Number of Package Switches DPPSWTCH QPACSWITCH | | X | X | DPPTCBTM Total TCB Time All Executions DPPTCBTM QPACTJST | X | X | X | DPPTREX Number of Trigger Executions DPPTREX QPACAAFG | X | X | X | DPPUDNU No. User-Defined Functions Scheduled DPPUDNU QPACUDNU | X | X | X | DPPWATRA Wt Trace for Log Reads DPPWATRA QPACANAR | X | X | X | DPPWATRB Wt Trace for TCP/IP LOB Material. DPPWATRB QPACALBC | | X | X | DPPWATRC Wait Trace Events - Claims DPPWATRC QPACARNC | X | X | X | DPPWATRD Wait Trace Events - Drain Lock DPPWATRD QPACARND | X | X | X | DPPWATRG Wait Trace Events - Sending Messages DPPWATRG QPACARNG | X | X | X | DPPWATRJ Wt Trace Events - Global Lock Content DPPWATRJ QPACARNJ | X | X | X | DPPWATRL Wait Trace Events - Lock/Latch DPPWATRL QPACARNL | X | X | X | DPPWATRP Wt Trace for Latch Contention DPPWATRP QPACARNH | X | X | X | DPPWATRR Wait Trace Events - Read Other DPPWATRR QPACARNR | X | X | X | DPPWATRW Wait Trace Events - Write Other DPPWATRW QPACARNW | X | X | X | DPPWATSE Wait Trace Events - Sync Exec DPPWATSE QPACARNS | X | X | X | DPPWATTR Wait Trace Events Processed DPPWATTR QPACARNE | X | X | X | DPPWLCTM Glbl Contention Child L-Lock Wait Time DB2WLCTM QPACAWTK | X | X | X | DPPWLGTM Glbl Contention PG P-Lock Wait Time DB2WGLTM QPACAWTO | X | X | X | DPPWLLTM Glbl Contention Other L-Locks Wait Time DB2WLLTM QPACAWTM | X | X | X | DPPWLPTM Glbl Contention PP P-Lock Wait Time DB2WLPTM QPACAWTN | X | X | X | DPPWTEPL Wait Trace Events - Waits on Latches DPPWTEPL QPACANLH | | | X | DPPWTOTM Glbl Contention Other P-Locks Wait Time DB2WTOTM QPACAWTQ | X | X | X | DPPZTCBT Total TCB Time All Executions on zIIP DPPZTCBT QPACCLS7_ZIIP | X | X | X | ----------------------------------------------------------------------------------------------------------------------------------
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |