Re: Logical files not in same library as physical files

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Disaster recovery DISASTER.

Aside from being confusing, opening the door to getting the index/view on
the wrong table due to library list issues, and generally being a real
pain, it sets a bunch of landmines for any kind of recovery.
IBM has done quite a bit of work in SAVE/RESTORE to try and mitigate the
dangers, but they still lurk.

90% of the test recoveries we do, and almost 100% of the actual recoveries
are not complete due to cross attached logical files, requiring extended
downtime to re-restore or rebuild them.  Keeping in mind a logical is
different from a stand alone index or view, it is a hybrid object that
contains both.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On Thu, Oct 21, 2021 at 10:11 AM Richard Reeve <rjrjr64@xxxxxxxxx> wrote:

> All,
>
>        I know that we can create logical files in different libraries than
> the physical files, but I don't like that idea.  What are your thoughts as
> to the advantages/drawbacks of the multi library approach?
>
> All the best,
>
> Richard Reeve
> --
> 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