MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2014

RE: method to view objects in production lib with locks on them



fixed

Write a program that lists all active jobs on the system. Use the List Job (QUSLJOB) API and Retrieve Job Locks (QWCRJBLK) API.

Both are found under API interfaces category Work Management.

Basic procedure will be...

1. Use QUSLJOB to list the jobs running on the system.
2. Spin through the list using QWCRJBLK to check for locks on stuff you want to know about.
3. Perform the action you wish to occur, including ending the job if you so choose.

Gary


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Tuesday, August 26, 2014 7:43 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: method to view objects in production lib with locks on them

Chuck - the issue is that the online system is brought down, along with all online users. Unfortunately once in a while an independent batch job named "BrokenJob" will be hung or msgw status, with a lock on a PF named "ImportantFile". Or maybe it is an FTP file transfer in progress, or a web interface file lock.

So my question is, how can I identify and send an email or text message stating something like "SWA cannot perform nightly backups because BrokenJob has a lock on ImportantFile".

Is there a DSPOBJLCK type command that can write to an outfile (instead of a printer?)


Thanks!




-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Monday, August 25, 2014 6:08 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: method to view objects in production lib with locks on them

On 25-Aug-2014 15:50 -0500, Stone, Joel wrote:
Each evening we bring down all users and run save-while-active on
production files.

Once in a while the save-while-active job cannot get a lock on a file.

After bringing down the online system, we would like to run a job
prior to the save that sends a text message to a few people showing
the JOB/lib/file of any production objects with a lock on them.

This would avoid the scenario where the SAVE job cannot get a lock on
each and every object for a moment.

Is a good method to <<SNIP>>

Seems there is a flaw in the attempt to use SWA. If the "online system" is _brought down_ [and "all users" as well], yet there are still locks on the objects of that application\system, then the problem would seem to be with if\how the application is being terminated to free those resources.

Having approached the issue from that perspective, there should remain no need to try to figure out who\what holds those resources still, except in what would hopefully be rare cases of defects in the processing that should both /bring down/ the application and prevent anyone starting any new instances of that application until after the checkpoint processing can be achieved.

--
Regards, Chuck
--
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.


________________________________________________________________________
This inbound email has been scanned for all viruses by the MessageLabs SkyScan service.
________________________________________________________________________

______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com ______________________________________________________________________
--
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.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact