I'm trying to debug an SPL stored procedure with the graphical debugger.
I'm on V7R3M0, ACS 18.104.22.168 and the System Debugger is V7R2M0. I'm
following Kent Milligan's article (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
CREATE OR REPLACE PROCEDURE rrogersonw.SimpleProc1 (IN parameter1
INTEGER, OUT variable1 INTEGER)
SET OPTION DBGVIEW=*SOURCE
SET variable1 = parameter1 + 5;
Does anyone know why I'm receiving this error or how I can determine what
job is servicing my sql session.