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.
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
Re: Count of how many times a specific DBRM was executed2013-01-05T09:21:17ZThis is the accepted answer. This is the accepted answer.try reading about accounting traces here
Okonita 110000KYR29 Posts
Re: Count of how many times a specific DBRM was executed2013-08-23T07:44:01ZThis is the accepted answer. This is the accepted answer.
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.