Re: Replacing a PF with logical - without recompile

Hi, Mark,

You should be able to do it something like this:

1. Remove all of the LF members using RMVM from the existing LFs over the
PF in question. This leaves the *FILE LF itself as an "empty shell" (or
"prototype" if you will), with no LF member (for now).

2. Move the PF out, and move or create the new replacement PF in its
place (in the library where the original PF was)

3. Copy the data desired into the new PF. (You could have done this ahead
of time, before moving the PF into the desired library.)

4. Re-add each of the LF members back again, one by one, using ADDLFM.
You can automate this by writing a CL program to loop over the list of LF
names. (ADDLFM requires the name of the LF as well as the "based on" PF
lib/file and member name.)

NOTE: beware of any join LFs. :-/

I may have over-simplified this a bit. Try it out carefully on a few
small test files first, to get familiar with and comfortable with the
technique.

Step 4 re-builds the access paths for each LF over the new data in the new
PF member.

All the best,

Mark S. Waterbury

On Thursday, October 24, 2024 at 07:35:36 PM EDT, Mark Villa <

iseries.4.me@xxxxxxxxx> wrote:

I want to move a huge PF to an offline library (not in the library list)
and copy a year of records back to a new online copy.

I remember doing this long ago and the logicals just started working with
the newly created PF - because they were in the same LIBRARY.

I tried this on a 7.3 system and the logicals followed the PF when I moved
them to another LIBRARY. The database relations appear to be much more
tightly managed with the newer OS's ??

Is there a way for me to designate (point) the new PF to the existing
logical's (rebuilding the index with the new live PF) without
recompile?

I did not see an option for this on CHGPF, etc. The files are managed by a
3rd party tool and I don't want to recreate - or delete millions of records
(cleanup) in the online file.

Thank You,
Mark Villa
--
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.