Checking if a job, which has a record lock, is doing anything before ending it
Home > IT Answers > AS/400 > Checking if a job, which has a record lock, i...
REDHED
0 pts.
0
Q:
Checking if a job, which has a record lock, is doing anything before ending it
RPG
We have some RPG code which will end a job if it has a record lock, but I would like to be sure that the job is not 'active' (not doing anything) before doing so. Is this sort of detail available via an API call ? Any examples would be gratefully received.
ASKED: Jan 27 2005  8:06 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
TomLiotta
8025 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Hi,

I'm not quite sure I understand what you're getting at. As far as the Operating System would be concerned the job would be *ACTIVE as it is waiting for a record lock to be released.

As the job would be in a LCKW status, the implication is that it would not actually be doing anything at the time although the job could be in the middle of a transactional process (i.e. some files may have been updated, but others not) in which case ending the job could leave you with half completed transactions in your database.

If that is the sort of thing you want to guard against then you need to look into the use of journals and commitment control. This would allow you to update all files in a transaction set and then commit the updates to the database once they have all been made. Should the job end before the commitment step is done, the updates would be rolled back out of the files and you would need to recreate the entire transaction.

All the best

Jonathan

===================================================================

You possibly want the Retrieve Job Information (QUSRJOBI) API for format JOBI0200. Look for 'Active job status'. One of the most likely statuses that could indicate the job isn't doing anything might be DSPW "Waiting for input from a work station display".

You'll have some decisions to make about what it means not to be 'doing anything'.

Tom
Last Answered: Oct 20 2009  1:11 AM GMT by TomLiotta   8025 pts.
Latest Contributors: astradyne   370 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

TheQuigs   0 pts.  |   Feb 7 2005  3:56PM GMT

You can use the QUSRJOBI api documented at: <a href="http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/apis/qusrjobi.htm" title="http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/apis/qusrjobi.htm" target="_blank">http://publib.boulder.ibm.com/iseries/v5…</a> to retrieve the Processing unit time used. (This is returned by format JOBI0150.) I would check the time used, then check again after a brief delay and see if the time used has increased. If it has, the job is defintely actively doing something.

 
0