RE: Running a program interactively or in batch

ThanKS Jim
I will definitely look into that



Sent via the Samsung GALAXY S® 5, an AT&T 4G LTE smartphone


-------- Original message --------
From: Jim It <jim_it@xxxxxxxxxxx>
Date: 5/25/17 10:19 PM (GMT-05:00)
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Running a program interactively or in batch

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,

you can use the GET_JOB_INFO DB2 function to view the V_SQL_STATEMENT_TEXT column which shows the Statement text of the last SQL statement to run or the SQL statement that is currently running.

Jim
--
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