Kiru
You can always let DB2 do the work for you. Bind the package with EXPLAIN(YES) and it will take all the information and place it in the plan table for you to view. Everything it touches and the details regarding access, etc
More Info;
Specify the EXPLAIN(YES) option when you bind the plan or package. With EXPLAIN(YES), only a small amount of additional processing is required to insert the results in a plan table. The same processing for access path selection is performed, regardless of whether you use EXPLAIN(YES) or EXPLAIN (NO).
Here is the link for your reference
http://pic.dhe.ibm.com/infocenter/dzich ... ininfo.htmPM