Hi All,

I'm trying to debug an SPL stored procedure with the graphical debugger.

I'm on V7R3M0, ACS 1.1.8.0 and the System Debugger is V7R2M0.  I'm
following Kent Milligan's article ([1]Graphical debugging makes procedural
SQL debugging on IBM i even easier) .

I enter the name of the C program and library (which was created from the
CREATE PROCEDURE statement) but when I press enter I keep receiving a
message box that says

Job is already being serviced, traced, or debugged.

Cause . . . . . :   One of the following requests have been made:
--Service a job that is being serviced. --Service a job that is being
traced. --Service a job that is being debugged. --Trace a job that is
being serviced. --Trace a job that is being traced.

Recovery  . . . :   When current servicing, tracing, or debugging is
complete, try the request again.

I've tried restarting my sql session multiple times but I keep receiving
the same message.

I created this simple procedure to test with and I'm still unable to
debug.

CREATE OR REPLACE PROCEDURE rrogersonw.SimpleProc1 (IN parameter1
  INTEGER, OUT variable1 INTEGER)
  LANGUAGE SQL
  SET OPTION DBGVIEW=*SOURCE
  P1: BEGIN
      SET variable1 = parameter1 + 5;
  END P1;

Does anyone know why I'm receiving this error or how I can determine what
job is servicing my sql session.

Thanks,

Rob

References

Visible links
1. https://tinyurl.com/yy67w9h9

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].