Re: Index Rebuild

[John McKee <jmmckee@xxxxxxxxxxxxxx>]

Don't know how helpful this will be, but.....

Why are you performing RSTOBJ?  Why not just do a RSTLIB (specifying
the RSTLIB parameter)?

When initial save is performed, is the command including ACCPTH(*YES)?

John McKee

On Thu, Apr 12, 2012 at 12:40 PM, Jerry C. Adams <midrange@xxxxxxxx> wrote:
> First, we're on V5R1.  So this may be (oh, heck, IS) an issue.
>
>
>
> Every night I save a copy of our data library to a test library, which I can
> use for testing (no partitions).  The test library is then saved to a save
> file.  I can restore the test library from the save file, if my tests, well,
> screw up.
>
>
>
> I don't often have to restore it in the middle of the day, but it does
> happen.  In fact, today I've done it twice (bad day).  Obviously things go a
> little slow (to put it mildly) during the restore.  But even after my
> command returns to the menu, there are still jobs running that are building
> indices.  WRKACTJOB shows:
>
>
>
> Subsystem/Job  User        Type  CPU %  Function        Status
>
>  QDBSRV05     QSYS        SYS    46.8  IDX-A.HISLA1     RUN
>
>  QDBSRV04     QSYS        SYS    43.3  IDX-D.LYMDRL01   RUN
>
>
>
> The restore is done by, first, clearing the library.  Then doing a RSTOBJ to
> the test library.  Is there a better, quicker way to do this?  I never
> noticed this before (i.e., on other systems on which I have worked using the
> same technique), but I would have thought (erroneously it seems) that the
> indices would have simply been restored from the save file, instead of
> under-going a complete rebuild.  The LFs are in the save file.  The disks
> are mirrored.
>
>
>
> Jerry C. Adams
>
> IBM i Programmer/Analyst
>
> You'll never make it - four groups are out.  Go back to Liverpool. - Decca
> Records executive to the Beatles (1962)
>
> --
>
> A&K Wholesale
>
> Murfreesboro, TN
>
> 615-867-5070
>
>
>
> --
> 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.