There is also an API - List Object Locks (QWCLOBJL) that will check locks
for an specified object.
Mit freundlichen Grüßen / Best regards
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
Gesendet: Tuesday, 26.8 2014 16:47
An: 'Midrange Systems Technical Discussion'
Betreff: RE: method to view objects in production lib with locks on them
OK I agree the system catalog is the way to get a list of objects. Now that
I have my list of objects, how can I check each one to find locks on it?
For example, is there a DSPOBJLCK *ALL *PF *OUTFILE(outfilename) type of
command? How would I build my own?
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Sent: Tuesday, August 26, 2014 6:45 AM
To: Midrange Systems Technical Discussion
Subject: Re: method to view objects in production lib with locks on them
Once again, please keep in mind that IBM i comes with a built in database
called DB2. And DB2, like most databases, has something called a "system
catalog". There is no need to do a DSPOBJD of every file out there to an
output file. This file already exists and is automatically updated whenever
a file is created. Query the file SYSTABLES. If you want a list of each
partition (member) of each table (file) then use SYSPSTAT.
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
Kendallville, IN 46755
From: "Stone, Joel" <Joel.Stone@xxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 08/25/2014 04:50 PM
Subject: method to view objects in production lib with locks on
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
Each evening we bring down all users and run save-while-active on
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
This outbound email has been scanned for all viruses by the MessageLabs
For more information please visit http://www.symanteccloud.com