DB2 Plan table on MVS

greenspun.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 (chuck_leviton@yahoo.com), September 10, 2002

Moderation questions? read the FAQ