MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2014

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



fixed

Joel,

Have you tried ending the database and file host servers

ENDHOSTSVR SERVER(*DATABASE *FILE) ENDACTCNN(*DATABASE *FILE)

and TCP server *DDM?

ENDTCPSVR SERVER(*DDM)

It may seem to be a bit heavy handed but this will definitely eliminate a number of lock issues pertaining to ODBC/JDBC and DDM/DRDA.

Thanks,

Gary


On Aug 25, 2014, at 4:50 PM, "Stone, Joel" <Joel.Stone@xxxxxxxxxx> 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 DSPOBJD to an outfile of all PFs in the lib, and then RCVF thru the outfile with ???

Would it only be necessary to check PFs? Ie would a LF lock also show that the underlying PF has a lock?

Then what? ALCOBJ to each object, trying to get a *EXCL lock on it? And if ALCOBJ fails, then send a text message?

Is there a TAATOOL that will accomplish this? Or maybe a different OS400 tool?

Thanks!



______________________________________________________________________
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.

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