RE: Index Rebuild

Oh, I don't know if there's any real good reason for using the RSTOBJ as
opposed to SAVLIB. The only thing that occurred to me is that (a) I have
different profiles for production and test, and (b) on a day like today I
did the restore while in my test profile; I'm just too callous or lazy to
always sign off so the RSTOBJ doesn't care about the library list.

That said, I've never done any tests regarding differences in
time-to-complete between RSTOBJ and RSTLIB. Like I said, probably more
laziness than anything else.

Jerry C. Adams
IBM i Programmer/Analyst
This portion of "Women on the Run" is brought to you by Phillip's Milk of
Magnesia. - Harry Von Zell, radio announcer (1950's)
--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John McKee
Sent: Thursday, April 12, 2012 12:51 PM
To: Midrange Systems Technical Discussion
Subject: Re: Index Rebuild

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.

--
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.