|
|
|
The DB2DDP (DB2 Plan 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 | DDPABRR DDF Abort Reqs Recvd From Remote DDPABRR QLACABRR | X | X | X | DDPABRS DDF Abort Reqs Sent To Remote DDPABRS QLACABRS | X | X | X | DDPADAC DDF DRDA DB2 Protocol DDPADAC QLACFLGS | X | X | | DDPBKRC DDF Backout Requests Received from the DDPBKRC QLACBKRC | X | X | | DDPBKSE DDF Backout Requests Sent to the DDPBKSE QLACBKSE | X | X | | DDPBRBF DDF Received Blocks - Block Fetch DDPBRBF QLACBRBF | X | X | X | DDPBROW DDF Rows in Buffer - Block Fetch DDPBROW QLACBROW | X | X | | DDPBTBF DDF Transmit Blocks - Block Fetch DDPBTBF QLACBTBF | X | X | X | DDPBYTR DDF Bytes Recvd From Remote DDPBYTR QLACBYTR | X | X | X | DDPBYTS DDF Bytes Sent To Remote DDPBYTS QLACBYTS | X | X | X | DDPCBLB DDF Switch Continuous to Limited DDPCBLB QLACCBLB | X | X | | DDPCIEL DDF Max. Conversations Open DDPCIEL QLACCIEL | X | X | | DDPCNVA DDF Successful Conversations DDPCNVA QLACCNVA | X | X | | DDPCNVQ DDF Conv Req Queued Waiting Alloc DDPCNVQ QLACCNVQ | X | X | X | DDPCNVR DDF Convs Recvd From Remote DDPCNVR QLACCNVR | X | X | X | DDPCNVS DDF Convs Sent To Remote DDPCNVS QLACCNVS | X | X | X | DDPCNVT DDF Conversations Terminated DDPCNVT QLACCNVT | X | X | X | DDPCOMR DDF COMMIT Reqs Recvd From Remote DDPCOMR QLACCOMR | X | X | X | DDPCOMS DDF COMMIT Reqs Sent To Remote DDPCOMS QLACCOMS | X | X | X | DDPCPTR DDF Number of Commit Operations DDPCPTR QLACCPTR | X | X | | DDPCPUR DDF DBAT CPU Reported To Requestor DDPCPUR QLACCPUR | X | X | | DDPCRSE DDF Commit Requests Sent to the DDPCRSE QLACCRSE | X | X | | DDPELPL DDF Local Elapsed Time DDPELPL QLACCPUL | X | X | X | DDPELPR DDF Remote Elapsed Time DDPELPR QLACCPUR | X | X | X | DDPINDT DDF Number of Threads That Became DDPINDT QLACINDT | X | X | X | DDPLARC DDF Last Agent Requests Received from DDPLARC QLACLARC | X | X | | DDPLASE DDF Last Agent Requests Sent to the DDPLASE QLACLASE | X | X | | DDPMBRBF Max DDF Received Blocks - Block Fetch DDPMBRBF QLACBRBF | X | X | X | DDPMBROW Max DDF Rows in Buffer - Block Fetch DDPMBROW QLACBROW | X | X | X | DDPMBTBF Max DDF Transmit Blocks - Block Fetch DDPMBTBF QLACBTBF | X | X | X | DDPMCBLB Max DDF Switch Continuous to Limited DDPMCBLB QLACCBLB | X | X | X | DDPMCIEL Max DDF Conversations Open DDPMCIEL QLACCIEL | X | X | X | DDPMCNVA Max DDF Successful Conversations DDPMCNVA QLACCNVA | X | X | X | DDPMCNVQ Max DDF Convs. Queued Waiting Alloc. DDPMCNVQ QLACCNVQ | X | X | X | DDPMCNVT Max DDF Conversations Terminated DDPMCNVT QLACCNVT | X | X | X | DDPMELPL Max DDF DBAT Local Elapsed Time DDPMELPL QLACCPUL | X | X | X | DDPMELPR Max DDF DBAT Remote Elapsed Time DDPMELPR QLACCPUR | X | X | X | DDPMRBND Max DDF Bound SQL for Remote DDPMRBND QLACRBND | X | X | X | DDPMSGR DDF Messages Recvd From Remote DDPMSGR QLACMSGR | X | X | X | DDPMSGS DDF Messages Sent To Remote DDPMSGS QLACMSGS | X | X | X | DDPPRIDR DDF Product ID of the Remote Location DDPPRIDR QLACPRID | X | X | X | DDPPRRC DDF Prepare Requests Received from the DDPPRRC QLACPRRC | X | X | | DDPPRSE DDF Prepare Requests Sent to the DDPPRSE QLACPRSE | X | X | | DDPRBND DDF Bound SQL for Remote DDPRBND QLACRBND | X | X | | DDPRBTR DDF Number of Rollback Operations DDPRBTR QLACRBTR | X | X | | DDPROWR DDF Rows Recvd From Remote DDPROWR QLACROWR | X | X | X | DDPROWS DDF Rows Sent To Remote DDPROWS QLACROWS | X | X | X | DDPRRRC DDF Forget Responses Received from DDPRRRC QLACRRRC | X | X | | DDPRRSE DDF Forget Responses Sent to the DDPRRSE QLACRRSE | X | X | | DDPRUQL DDF Roll Up Flag DDPRUQL QLACFLGS | | | X | DDPSDAC DDF Private DB2 Protocol DDPSDAC QLACFLGS | X | X | | DDPSQLR DDF SQL Stmts Recvd From Remote DDPSQLR QLACSQLR | X | X | X | DDPSQLS DDF SQL Stmts Sent To Remote DDPSQLS QLACSQLS | X | X | X | DDPSRQL DDF Summary Roll Up Flag DDPSRQL QLACFLGS | | | X | DDPTRNS DDF Trans Sent To Remote DDPTRNS QLACTRNS | X | X | | DDPVNRC DDF Backout Responses Received from DDPVNRC QLACVNRC | X | X | | DDPVNSE DDF Backout Responses Sent to DDPVNSE QLACVNSE | X | X | | DDPVYRC DDF Request Commit Responses received DDPVYRC QLACVYRC | X | X | | DDPVYSE DDF Request Commit Responses sent to DDPVYSE QLACVYSE | X | X | | ----------------------------------------------------------------------------------------------------------------------------------
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |