Re: Running a program interactively or in batch

Hi Alan,

Did it actually start at 00:01? Check using WRKJOB option 1, Started Date
and Time.

Using WRKJOB option 3, press F5=Refresh and see if the "CPU time used" is
increasing. What is the current amount right now?

Check the QHST history log and see what other jobs were running at the same
time. Perhaps the job was locked due to a backup that runs until the
morning. Perhaps the job was running but didn't get enough of the CPU.

Using WRKJOB option 12, are there any locks it is currently waiting on?


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (905) 486-1162 x 239
Cell: (416) 317-3144


On 25 May 2017 at 14:35, Alan Shore <ashore@xxxxxxxx> wrote:

Hi everyone
Before I forget - we are on v7r1
I have a program that I have been running interactively now for a couple
of weeks with no problems
Takes approximately 90 to 120 minutes
This CLLE program copies files, clears some other files then uses the
command RUNSQLSTM using a text file containing a number of SQL scripts with
COMMIT(*NONE) and creates files in QTEMP

I have now created a WRKJOBSCDE to run the same program at one minute past
midnight
I came in this morning to see that the job was still running
No locks
No msgw
I looked at the job log - nothing out of the ordinary
But I am unable to determine where the program is in the SQL run

I looked at option 14. Display open files, if active, then pressed F11 to
see the relative record number of files
I have now been doing this for a few hours and nothing seems to be moving
The call stack doesn't change either

Does anyone know what I can look at to determine whats happening?



Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://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: http://amzn.to/2dEadiD