DB2 Plan table on MVSgreenspun.com : LUSENET : DBAzine : One Thread
I am trying to use the plan_table to determine if a query uses a particular index. I am looking to see if the accessname field has the name of the index. I hope this is the right aproach. I am not sure how to match the queryno to the DBRM however. I converted queryno to hex and looked in the DBRM, no match. How do I use the queryno to determine which statement in the program I am looking for?
-- charles leviton (firstname.lastname@example.org), September 10, 2002