There is also an API - List Object Locks (QWCLOBJL) that will check locks
for an specified object.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

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

-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
Stone, Joel
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?

Any ideas?


-----Original Message-----
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.

Rob Berendt
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
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
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


This outbound email has been scanned for all viruses by the MessageLabs
Skyscan service.
For more information please visit

This thread ...


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