Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trace db2 sql code - Any Application? 1
- Thread starter julen
- Start date
-
1
- #2
Hi Julen,
When you say trace, do you wish to see what access paths are being taken etc.? If so, you need to look into the EXPLAIN feature. There any many products on the market, suitable for whatever platform you happen to be on, that take DB2's basic EXPLAIN feature and enhance it to be more user friendly, but basically you EXPLAIN your SQL which writes rows to a table called PLAN_TABLE. This can then be looked at to see what order the tables are being accessed and whether indexes are being used or table scans done.
Hope this helps.
Marc
When you say trace, do you wish to see what access paths are being taken etc.? If so, you need to look into the EXPLAIN feature. There any many products on the market, suitable for whatever platform you happen to be on, that take DB2's basic EXPLAIN feature and enhance it to be more user friendly, but basically you EXPLAIN your SQL which writes rows to a table called PLAN_TABLE. This can then be looked at to see what order the tables are being accessed and whether indexes are being used or table scans done.
Hope this helps.
Marc
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question