Re: Converting large amount of data [PRIVATE REPLY]

There may be some way to monitor this.
I know it was a HUGE thing upon restores. We once had to wait a week (but
this was a long time ago) until access paths were completely rebuilt. IBM
realized they were killing people so they changed the default on saves to
also save access paths. Caused saves to take longer and eat more tape but
what's the point of a save if you cannot restore and get your business
running right away?
I think that last question is a Larry dictum.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
smith5646midrange@xxxxxxxxx
Sent: Tuesday, March 9, 2021 7:07 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx

Subject: RE: Converting large amount of data [PRIVATE REPLY]

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know
the content is safe.


After submitting some additional tests and closely watching the system,
what I found is that the OS hands the logicals off to the DBSERVxx jobs and
they rebuild the indexes.

I don’t know what this means to our conversion duration since they are not
rebuilt real time. Just because all of our data is converted doesn't mean
the system is done building indexes.



-----Original Message-----
From: smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Tuesday, March 9, 2021 4:55 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx

Subject: RE: Converting large amount of data [PRIVATE REPLY]

*immed

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Charles Wilt
Sent: Tuesday, March 9, 2021 3:31 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Converting large amount of data [PRIVATE REPLY]

Is the LF defined MAINT(*DLY) or MAINT(*REBLD)?

That would explain it..

Charles

On Tue, Mar 9, 2021 at 1:10 PM <smith5646midrange@xxxxxxxxx> wrote:

I’m resurrecting this old post because I have a problem.



We have rewritten our conversion to use CHGPF where we can. Today
someone tried to DBU a logical file built over a huge physical (182M
records) and it took 15 minutes (this is a severely restricted
machine) and it said something about rebuilding the index.



I thought CHGPF updated the indexes while it was running (excluding
the mismatched ones that we discussed earlier). We can’t use the
CHGPF if that is going to delay the normal processing the first time
that it tries to use the index.



Is there something I missed in all of this?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com