Debug

Doing more sysadmin so a lot of this stuff has gotten rusty...

Trying to debug a stored procedure.
Figured out that I needed to have the line
SET OPTION DBGVIEW =*SOURCE
After these lines
CREATE PROCEDURE MY_PROCEDURE
LANGUAGE SQL MODIFIES SQL DATA
Tried debugging interactively. Apparently that requires me to start a 5250 session and I need to run some command which I can't remember what. So I figured out I'd try batch.
Seemed to be coming along. Got called away for something else, for some time. Got back to it and I think it timed out.
So I'm trying to debug it again and now I'm getting a message that the SBMJOB failed.
I still have connection to the lpar.
Nothing in DSPLOG jumps out.
Nothing in my DSPMSG
DSPMSG QSYSOPR has one which may be related and it appears in that time frame:
CPI2417 Job message queue for 731944/QUSER/QZRCSRVS has been wrapped. Lots of these in the joblog:
Client request - run program QSYS/QUSRJOBI
Job //*INT currently not available.
Client request - run program QSYS/QUSRJOBI
Client request - run program QGY/QGYOLJOB.
Client request - run program QSYS/QUSRJOBI
Client request - run program QGY/QGYOLJOB.
Client request - run program QSYS/QUSRJOBI
Client request - run program QSYS/QUSRJOBI
Client request - run program QSYS/QUSRJOBI
IDK if it is related or not.
Any suggestions?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com