To the List:
It's been a while since I needed to use this command... Aren't most files
on the AS/400 set to "Reuse deleted records: YES"? If not then can this
attribute be changed on live files? That might be a better solution for
rhunt than going in and having to reorganize the physical files every so
often.
Just a thought. When I used this command (years ago) I had a CL program
that analysed the files and determined which ones needed reorging.
Regards,
Gerald
rhunt
<rhunt@highwoods. To:
[email protected]
com> cc:
Sent by: Subject: RGZPFM on AS400
jdelist-bounces@j
delist.com
08/25/2003 11:33
AM
Please respond to
JDELIST One World
/ XE Discussions
Is there a way to either execute an RGZPFM against the entire system
instead of just one object? Also, if not, is there a SQL statement that
can be run to list tables that fit a certain criteria (in other words,
determine through SQL what objects have a lot of deleted records)?
Finally, what is the downside to the RGZPFM? I'm assuming IBM has a reason
that deleted records are not reclaimed by the systems ASP.ThanksRyan Hunt
OneWorld XE, XU5, SP21_E1
Citrix 1.8 on Win2k TSE
AS400 Enterprise Server
Win2k Deployment
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat
=&Board=OW&Number=60402
This is the JDELIST One World / XE Mailing List. To stop receiving these
messages, login to
http://www.jdelist.com/forums, click Control Panel,
then click Edit by "Subscribe / Unsubscribe from receiving board posts by
email, change message notifications, etc." and adjust your subscription
preferences. JDEList is not affiliated with JDEdwards®