RE: RGZPFM mistake on a giant file at mid-day

["Sims, Ken" <KSIMS@xxxxxxxxxxxxxxxx>]

Hi Joel -

>Date: Mon, 7 Feb 2000 13:52:20 -0500 
>From: "Stone, Joel" <StoneJ@GourmetAward.com>
>Subject: RGZPFM mistake on a giant file at mid-day

Side note ... please turn off the HTML if you can.  It's really, really ugly
in digest mode.

>1)     Is there any way to recover?  Or our they out of business until
>tomorrow?
>
>2)     Is there an undo button where the RGZPFM can be ended and the file
>and LF's restored to their prior state?

I think you're stuck.  If the job is indexing logicals, even if you could
kill it there is no way to make the logicals available except to rebuild
them.  Or to delete the whole mess and restore from a backup, but that if
you didn't save access paths that would be just as long.

>3)     Is there a way to monitor the progress of the RGZPFM which shows
>estimated time of completion, which access path
>       it is currently crunching on, and which paths can share other paths,
>and how long each path will take?

If you look at the job in WRKACTJOB or WRKUSRJOB, the Function will show you
what logical is being rebuilt.

>4)     What sequence does it build the logicals in?  Is it creation
>sequence?  

It is the order in which they are displayed with DSPDBR [physicalfilename].
If this same set of physical and logicals exist in multiple libraries (like
a production environment and a test environmet), make sure that you do
DSPDBR against the physical file which is the one actually being
reorganized; the order can be different.

>5)     Does RGZPFM ensure that if a logical file can share the access path
>of another logical, that it does indeed share it?
>       Even if they were built in a different sequence years ago?

If the logical is not already marked to share an access path, I don't think
the reorganize process will detect that sharing is possible.  I believe that
it will just go ahead and rebuild the logical as it was.

Ken
Southern Wine and Spirits of Nevada, Inc.
Opinions expressed are my own and do not necessarily represent the views of
my employer or anyone else.

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---