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.
This topic has been locked.
2 replies Latest Post - 2013-08-23T07:44:01Z by Okonita
Pinned topic Count of how many times a specific DBRM was executed
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-05T09:21:17Z at 2013-01-05T09:21:17Z by SystemAdmin
SystemAdmin 110000D4XK3105 Posts
Okonita 110000KYR29 PostsACCEPTED ANSWER
Re: Count of how many times a specific DBRM was executed2013-08-23T07:44:01Z in response to efra9999
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.