Re: Most Efficient Way of Purging File

[Pete Hall <pbhall@xxxxxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Last time I looked, rgzpfm actually does make a copy of the table data
in order to get rid of the deleted rows. Therefore, there must be enough
space available on disk for 2x the original data size. Might not be
possible with that many rows.

Pete Hall
pbhall@xxxxxxxxxxxxx


Pete Massiello wrote:
> Why don't use the reorganize while active feature of RGZPFM, this way it can
> take a few days to run, but you can be accessing the file all the time.
>
> Pete
>
> Pete Massiello
> iTech Solutions
> http://www.itechsol.com
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jonathan Mason
> Sent: Monday, December 08, 2008 5:19 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Most Efficient Way of Purging File
>
> We have a file that has an enormous number of records in (just over 1.9
> billion) and want to clear it down a bit to reclaim some much needed
> DASD.  The trouble is that because of the file size our standard purge
> routine takes longer than the available 17 hour window that we have for
> running housekeeping tasks.
>
> At the moment we think we have two choices available to us:
>
> 1. Use SQL DELETE to remove all the records we want to purge and then
> run a RGZPFM over the file
>
> 2. Restore a copy of the file from tape to a second server, and use CPYF
> to create a new version of the physical with only those records we want
> to retain and then restore that over the original.  We think this will
> automatically perform the RGZPFM as part of the restore/copy.
>
> Does anybody have any experience or advice on performing this sort of
> "purge", ideas on how to improve performance, etc, etc.
>
> We're running V5R4 and there are eight logicals over the file.
>
> Thanks
>
> Jonathan
>
>
>
>
>
>
>
>
> _______________________________________________________
> This message was sent using NOCC v1.14 webmail software
> _______________________________________________________
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkk9Qg4ACgkQpcZsDl8OX6kqEgCeLJZBJpdUMZkgXfH0KPmGU2mi
urMAoLw4CUS9xqCbBJuIUN80hyUta/Cc
=m98Z
-----END PGP SIGNATURE-----