We have a job that does reorgs every Sunday in the wee
hours of the morning and that is where we do a CLRLIB
on QRPLOBJ. One of the things this process does it
obtain a list of database locks and perform an ENDJOB
on anyone still having a lock so this helps reduce the
chance of someone being online at the time and holding
a lock on an object in QRPLOBJ.
At one time we cleared QRPLOBJ at the end of QSTRUP but
since we don't IPL much anymore it made more sense to
run it a little more frequently.
Our Production system is used by a few hundred people
with two active programmers and we're constantly making
changes (in one form or another) so it's nice to get it
done periodically.
Terry
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Schutte
Sent: Monday, April 11, 2016 2:09 PM
To: Midrange Systems Technical Discussion
Subject: QRPLOBJ Clean Library.
I know there's been discussions in the past. But I just wanted to get verification that I'm good to do this.
Our development partition is used by maybe 10-15 people. We sign off everyday. We rarely do we do an IPL. Rarely, do we work weekends. I could ask for it to IPL every weekend. But short of doing that I was thinking of creating a program.
1. Get a list of objects in QRPLOBJ, save to a file 2. Read the file, scanning for the library of the original object in the object description field 3. If library is one of our development libraries and the last used date is more than a day ago delete the object from QRPLOBJ.
Our QRPLOBJ is quite large mainly from the recompiles and promotes within our development libraries and Q/A environments.
Looks like it's 4.3 Gigabytes.
--
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.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Confidentiality Notice: The preceding e-mail message (including any attachments) contains information that may be confidential, protected by applicable legal privileges, or constitute non-public information. It is intended to be conveyed only to the designated recipient(s). If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution or reproduction of this message by unintended recipients is not authorized and may be unlawful.
midrange.com
