MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2014

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



fixed

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.






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