Re: Do any of you have a policy on rebuilding indexes?

Basically that allows you to determine when access paths get rebuilt. Right away, or delayed, meaning when they are first used. I believe you could also order them by a priority. That came in real handy when we needed to get the paths used in the on line applications built before users signed on, then do the batch related access paths later.

We always kept the system in a restricted state until they were done, first to make it a shade faster, and to keep the users from complaining about the sometimes abysmal response times they would get as an access path completed rebuilding.

Jim Oberholtzer
Agile Technology Architects

On Apr 1, 2023, at 5:37 PM, Patrik Schindler <poc@xxxxxxxxxx> wrote:

Hello Marc,

Am 01.04.2023 um 22:52 schrieb Marc Rauzier <marc.rauzier@xxxxxxxxx>:

FYI, EDTRBDAP command might help when this case happens, as well as after an IPL following an abnormal power down if there are invalid access paths to rebuild.

I've seen a similar screen on V4R4 and older after an abnormal IPL being shown in the course of a manual IPL.

Taking time now to read the help text and understand about this screen. Thanks for bringing this up!

:wq! PoC

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