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

Next Topic: The DB2DDY (DB2 System DDF Statistics) File

The DB2DDU (DB2 User DDF Activity) File

The DB2DDU (DB2 User DDF 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 | 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 | 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 | DB2RLOCN DDF Remote Location ID DB2RLOCN QLSTLOCN | 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 | DDUABRR DDF Abort Requests Received From Remote DDUABRR QLACABRR | X | X | X | DDUABRS DDF Abort Requests Sent To Remote DDUABRS QLACABRS | X | X | X | DDUADAC DDF DRDA Connection Protocol DDUADAC QLACFLGS | X | X | | DDUBKRC DDF Backout Requests Received from the DDUBKRC QLACBKRC | X | X | | DDUBKSE DDF Backout Requests Sent to the DDUBKSE QLACBKSE | X | X | X | DDUBRBF DDF Received Blocks - Block Fetch DDUBRBF QLACBRBF | X | X | X | DDUBROW DDF Rows in Buffer - Block Fetch DDUBROW QLACBROW | X | X | | DDUBTBF DDF Transmit Blocks - Block Fetch DDUBTBF QLACBTBF | X | X | X | DDUBYTR DDF Data Bytes Received From Remote DDUBYTR QLACBYTR | X | X | X | DDUBYTS DDF Data Bytes Sent To Remote DDUBYTS QLACBYTS | X | X | X | DDUCBLB DDF Switch Continuous to Limited DDUCBLB QLACCBLB | X | X | | DDUCIEL DDF Max. Conversations Open DDUCIEL QLACCIEL | X | X | | DDUCNVA DDF Successful Conversations DDUCNVA QLACCNVA | X | X | | DDUCNVQ DDF Conv Req Queued Waiting Alloc DDUCNVQ QLACCNVQ | X | X | X | DDUCNVR DDF VTAM Convers. Received From Remote DDUCNVR QLACCNVR | X | X | X | DDUCNVS DDF VTAM Conversations Sent To Remote DDUCNVS QLACCNVS | X | X | X | DDUCNVT DDF Conversations Terminated DDUCNVT QLACCNVT | X | X | X | DDUCOMR DDF DB2 COMMITs Received From Remote DDUCOMR QLACCOMR | X | X | X | DDUCOMS DDF DB2 COMMITs Sent To Remote DDUCOMS QLACCOMS | X | X | X | DDUCPTR DDF Number of Commit Operations DDUCPTR QLACCPTR | X | X | | DDUCPUR DDF DBAT CPU Reported To Requester DDUCPUR QLACDBAT | X | X | | DDUCRSE DDF Commit Requests Sent to the DDUCRSE QLACCRSE | X | X | | DDUELPL DDF Local Elapsed Time DDUELPL QLACCPUL | X | X | X | DDUELPR DDF Remote Elapsed Time DDUELPR QLACCPUR | X | X | X | DDUFLGS DDF Type of Protocol DDUFLGS QLACFLGS | X | X | X | DDUINDT DDF Number of Threads That Became DDUINDT QLACINDT | X | X | X | DDULARC DDF Last Agent Requests Received from DDULARC QLACLARC | X | X | | DDULASE DDF Last Agent Requests Sent to the DDULASE QLACLASE | X | X | | DDUMABRR Max DDF Abort Req. Received From Remote DDUMABRR QLACABRR | X | X | X | DDUMABRS Max DDF Abort Requests Sent To Remote DDUMABRS QLACABRS | X | X | X | DDUMBYTR Max. DDF Data Bytes Received From Remote DDUMBYTR QLACBYTR | X | X | X | DDUMBYTS Max. DDF Data Bytes Sent To Remote DDUMBYTS QLACBYTS | X | X | X | DDUMCNVQ Max. DDF Convs. Queued Waiting Alloc. DDUMCNVQ QLACCNVQ | X | X | X | DDUMCNVR Max. DDF Convs. Received From Remote DDUMCNVR QLACCNVR | X | X | X | DDUMCNVS Max. DDF Conversations Sent To Remote DDUMCNVS QLACCNVS | X | X | X | DDUMCOMR Max. DDF COMMITs Received From Remote DDUMCOMR QLACCOMR | X | X | X | DDUMCOMS Max. DDF DB2 COMMITs Sent To Remote DDUMCOMS QLACCOMS | X | X | X | DDUMCPUR Max. DDF DBAT CPU Reported To Requester DDUMCPUR QLACDBAT | X | X | X | DDUMDWTM DDF Wait Tm DB Agent Due Max DBATs DDUMDWTM QLACMDWT | X | X | X | DDUMELPL Max. DDF DBAT Local Elapsed Time DDUMELPL QLACCPUL | X | X | X | DDUMELPR Max. DDF DBAT Remote Elapsed Time DDUMELPR QLACCPUR | X | X | X | DDUMMSGR Max. DDF Messages Received From Remote DDUMMSGR QLACMSGR | X | X | X | DDUMMSGS Max. DDF Messages Sent To Remote DDUMMSGS QLACMSGS | X | X | X | DDUMROWR Max. DDF Data Rows Received From Remote DDUMROWR QLACROWR | X | X | X | DDUMROWS Max. DDF Data Rows Sent To Remote DDUMROWS QLACROWS | X | X | X | DDUMSGR DDF Messages Received From Remote DDUMSGR QLACMSGR | X | X | X | DDUMSGS DDF Messages Sent To Remote DDUMSGS QLACMSGS | X | X | X | DDUMSQLR Max. DDF SQL Stmts. Received From Remote DDUMSQLR QLACSQLR | X | X | X | DDUMSQLS Max. DDF SQL Stmts. Sent To Remote DDUMSQLS QLACSQLS | X | X | X | DDUPRIDR DDF Product ID of the Remote Location DDUPRIDR QLACPRID | X | X | X | DDUPRRC DDF Prepare Requests Received from the DDUPRRC QLACPRRC | X | X | | DDUPRSE DDF Prepare Requests Sent to the DDUPRSE QLACPRSE | X | X | | DDURBND DDF Bound SQL for Remote DDURBND QLACRBND | X | X | | DDUROWR DDF Data Rows Received From Remote DDUROWR QLACROWR | X | X | X | DDUROWS DDF Data Rows Sent To Remote DDUROWS QLACROWS | X | X | X | DDURRRC DDF Forget Responses Received from DDURRRC QLACRRRC | X | X | | DDUSDAC DDF Private DB2 Connection Protocol DDUSDAC QLACFLGS | X | X | | DDURRSE DDF Forget Responses Sent to the DDURRSE QLACRRSE | X | X | | DDURUQL DDF Roll Up Flag DDURUQL QLACFLGS | | | X | DDUSQLR DDF SQL Statements Received From Remote DDUSQLR QLACSQLR | X | X | X | DDUSQLS DDF SQL Statements Sent To Remote DDUSQLS QLACSQLS | X | X | X | DDUSRQL DDF Summary Roll Up Flag DDUSRQL QLACFLGS | | | X | DDUTRNR DDF Transactions Received From Remote DDUTRNR QLACTRNR | X | X | | DDUTRNS DDF Transactions Sent To Remote DDUTRNS QLACTRNS | X | X | | DDUVNRC DDF Backout Responses Received from DDUVNRC QLACVNRC | X | X | | DDUVNSE DDF Backout Responses Sent to DDUVNSE QLACVNSE | X | X | | DDUVYRC DDF Request Commit Responses received DDUVYRC QLACVYRC | X | X | | DDUVYSE DDF Request Commit Responses sent to DDUVYSE QLACVYSE | X | X | | ----------------------------------------------------------------------------------------------------------------------------------