IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 2 replies
  • Latest Post - ‏2013-08-23T07:44:01Z by Okonita
efra9999
efra9999
11 Posts

Pinned topic Count of how many times a specific DBRM was executed

‏2012-07-16T17:32:41Z |
Are there any statistics accumulated in any ibm db2 system table or some sort of tool to use to determine how many times a specific dbrm member was called?

Example: I have plan X that has two DBRM members (Member A and B).

I can determine how many times plan X has been invoked, but I'm not sure how I can get more granular to see if it was Member A, Member B or both that was used.

Any direction or reference material that can be read to get this information would be very helpful. I scowered the internet to no avail.

Thank you,
Ed Franke
Updated on 2013-01-05T09:21:17Z at 2013-01-05T09:21:17Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    3105 Posts

    Re: Count of how many times a specific DBRM was executed

    ‏2013-01-05T09:21:17Z  
    try reading about accounting traces here
    http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z9.doc.perf/src/tpc/db2z_accountingtrace.htm
  • Okonita
    Okonita
    9 Posts

    Re: Count of how many times a specific DBRM was executed

    ‏2013-08-23T07:44:01Z  

    Hi,

     

    Yes this is old news, but just in case, to get information about specific DBRM, the ACCOUNTING trace class 2,7,8, 10 must be enabled along with IFCID several IFCIDs specifically IFCID 0239 for package details.