INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...your web site's great! I've been using this system for almost a year now and find it really, really helpful. The people have been helpful in answering just about any question you post in the forums..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > IBM: DB2 Forum

Trace db2 sql code - Any Application?

Read More Threads Like This One

julen (Programmer)

29 Jul 08 7:20

Hi everybody!!!

I have been writing db2 sql code for two years, and now, I wonder if anyone knows if exists any programm or application to debug/trace easily this code.

Can you help me?

Thank you very much.

MarcLodge (Programmer)

29 Jul 08 7:49

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

julen (Programmer)

29 Jul 08 8:33

Hi MarcLodge!!

I don´t know if I am clear. What I want to know is if it is possible with an application, point the exact line of error in my code.

My sql db2 is for an as/400.

Any ideas of different applications??

Thanks again

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To IBM: DB2