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
As an Amazon Associate we earn from qualifying purchases.