Hi Frnds ,
I want to Debug a stored procedure .
I am using db2 8.0.
I started the distrubuted debugger on port 4553

I get following exception :

VL000039 - Debug started.
VL000039 - Exception occurred while debugging:
[IBM][CLI Driver][DB2] SQL0440N No authorized routine named "DB2DEBUG.CREATE_SESSION" of type "" having compatible arguments was found. SQLSTATE=42884

Friends , please help me ..

have you followed the procedure from infocenter - prepare for debug -
create debug tables - populate debug tables .. ??
classpath correctly set ?

How to check this ???

restart all using
http://www.revealnet.com/newsletter-v4/0803_A.htm

How about SQL stored procedure debugging?

What is the procedure to follow for SQL SP?

Thanks in advance.

For SQL Procedures, you have to 'Build for Debug' when creating the stored procs from Development Centre or Developer Workbench. (AFAIK, you cannot do this on command line)

Then 'Run for Debug' and step through the code. Developer workbench has more options for debug than its predecessor.

Open the tool you are using and explore the tool bar .. You should be able to figure out quiet easily ..

Cheers
Sathyaram

I have downloaded 'Developer Workbench' to debug a SP. However, I'm not able to effectively debug...

What I'm looking for with respect to debugging is...
1. Trace the SP step by step, for the values with which it is called
2. See where it fails and get the corresponding SQL code

Is this possible? If so, can I have the steps to be followed.

BTW, I've already followed the tutorial provided with DWB and also the document on 'DB2 Developer Workbench, Part 2: Developer Workbench and stored procedures' to pursue debugging effectively, but to no avail.

The platform is Windows, DB2 UDB V9 and DB2 Developer Workbench.

Thanks in advance.

This is possible with dwb
will make some screenshots
but in the object explorer right click and select debug....
will come back