Jim
This is EXACTLY what I was looking for - and I had just sent out a link with this in
Hope it helps me with my problem
Just to keep everyone up to date
I started my job again, and then in STRSQL I ran the following
SELECT V_SQL_STATEMENT_TEXT FROM TABLE(QSYS2.GET_JOB_INFO(
'948485/COMPILE/BICUSTXTRJ')) a
Where '948485/COMPILE/BICUSTXTRJ' is my job that is currently running
The response I received was
V_SQL00001
create table QTEMP.CUSTMEDIAN as (SELECT a.bcmpy, a.CUST2, a.BAYY, a.BAMMDD, a.BAXXX, a.ORDNUM, a.AMTREM, a.AMTTAX, b.MCST# FROM
******* End of data ********
Which is the 4th sql command in my SQL script
NNNIIIIICCCCCEEE
This is the link showing all of the tables and services IBM offers to view system information via SQL.
http://ibm.biz/DB2foriServices<
https://www.linkedin.com/redir/redirect?url=http%3A%2F%2Fibm%2Ebiz%2FDB2foriServices&urlhash=LIhP&_t=tracking_anet>
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
From: Alan Shore
Sent: Thursday, May 25, 2017 11:02 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Running a program interactively or in batch
ThanKS Jim
I will definitely look into that
Sent via the Samsung GALAXY S(r) 5, an AT&T 4G LTE smartphone
-------- Original message --------
From: Jim It <jim_it@xxxxxxxxxxx<mailto:jim_it@xxxxxxxxxxx>>
Date: 5/25/17 10:19 PM (GMT-05:00)
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx<mailto: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<mailto: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<mailto: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<mailto:support@xxxxxxxxxxxx> for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
