Re: estimating RGZPFM runtime

[Evan Harris <auctionitis@xxxxxxxxx>]

My recollection is that using this process (i.e. Reorg while active) you
will still need to perform a re-org with an exclusive lock to actually
perform the file truncation and regain the associated storage.

The way I understand it works is that all the deleted records are "moved"
 to the end of the file (or more likely the active records at the end of
the file are rewritten into the spaces left by deleting records in the
"body" of the table). Either way, the net result is that you end up with a
table with all active records at the beginning of the file and all deleted
records at the end. When the reorg with a lock is done the file is
truncated where the deleted records "start". The truncation requires an
exclusive lock but is pretty quick in my experience.

The only other quirk to be aware of is that re-org while active can
generate a huge amount of journal entries (depends on how many deleted
recrods there are), so it can have quite an impact on storage and HA
products and possibly bandwisth if you are remote journaling.



On Tue, Nov 19, 2013 at 10:40 AM, Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>wrote:

> Joel,
>
> If you use RGZPFM while active, no down time. We created a process (CLs
> and qry), using RGZ While Active, does all PF with deleted records.
>
> STRJRNPF   FILE(&MBLIB/&MBFILE) JRN(QGPL/RGZPFM)
>
> SNDPGMMSG  MSG('RGZPFM starting for ' *BCAT &MBLIB *BCAT +
>              '/' *BCAT &MBFILE *BCAT '.')
>
> RGZPFM     FILE(&MBLIB/&MBFILE) MBR(&MBNAME) +
>              RBDACCPTH(*NO) ALWCANCEL(*YES) +
>              LOCK(*SHRUPD) /* rgzpfm while active */
> MONMSG     MSGID(CPF2981 CPF3135 CPF9801 CPF9809 +
>              CPF9810 CPF9820 CPF2982) EXEC(GOTO +
>              CMDLBL(ERROR2))
>
>
> ENDJRNPF   FILE(&MBLIB/&MBFILE) JRN(QGPL/RGZPFM)
> MONMSG     MSGID(CPF9803) EXEC(GOTO CMDLBL(ERROR4))
>
> Thanks
> Paul
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
> midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
> Sent: Monday, November 18, 2013 4:24 PM
> To: Midrange Systems Technical Discussion
> Subject: estimating RGZPFM runtime
>
> How can I estimate down-time required to RGZPFM a file?  Is there a
> utility or rule-of-thumb on these?
>
> Can it be killed if not completed OR will the file then be compromised?
>
> Thanks!
>
>
>
> ______________________________________________________________________
> This outbound email has been scanned for all viruses by the MessageLabs
> Skyscan service.
> For more information please visit http://www.symanteccloud.com______________________________________________________________________
> --
> 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.
>
> --
> 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.