Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2005
    Posts
    16

    Question Unanswered: Debugging Stored Procedure

    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 ..

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    debug

    have you followed the procedure from infocenter - prepare for debug -
    create debug tables - populate debug tables .. ??
    classpath correctly set ?
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Dec 2005
    Posts
    16
    Quote Originally Posted by przytula
    have you followed the procedure from infocenter - prepare for debug -
    create debug tables - populate debug tables .. ??

    I using Db2 version 8.0
    I compiled the Stored procedure for Debug mode using DB2 Developement center.
    Then when clicked on Debug option , i get the mentioned error.


    classpath correctly set ?
    How to check this ???

  4. #4
    Join Date
    Nov 2004
    Posts
    374

    debug

    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  5. #5
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    How about SQL stored procedure debugging?

    What is the procedure to follow for SQL SP?

    Thanks in advance.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    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.

  8. #8
    Join Date
    Jun 2006
    Posts
    471
    This is possible with dwb
    will make some screenshots
    but in the object explorer right click and select debug....
    will come back
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •