I think I had something similar. The debug gets kind of disconnected from you but it really keeps running and running and running. And if you have the loop from hell you may start noticing some severe system hits. Luckily it was a test lpar.
Looking for an object lock on your user profile, or,
looking for jobs where you are the "current" (not job) user is another way.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Robert Rogerson
Sent: Sunday, March 17, 2019 6:50 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Unable to debug an SPL stored procedure...
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 is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
