Hi, I can confirm (at least on Unx/Linux systems) that a symbolic link would work, even if you change from a
raw device to a cooked file, keeping the path.
Shut down DB, move the file, create the symbolic link from old location and restart DB (check access rights).
Ontape would also work, with rename option.
I would try to perform an external restore with ontape -p -e, followed by the rename option, which might work
in place.
Depending on the size of DB, a backup/restore might produce a too long downtime.
-> make a L0 backup (just to make sure you are able to recover first)
-> shutdown DB cleanly with onmode -ukcy
-> rename your chunk file on OS level
-> ontape -p -e -rename ......
DB should be starting, resulting in recovery mode, you need to change mode afterwards to online with onmode -m
I think I tried something like that a while ago, could be the way with the smallest downtime if mirroring is no option,
which would possibly work with no downtime, while needing double space temporarily.
Good luck
------------------------------
Marcus Haarmann
------------------------------
Original Message:
Sent: Thu March 24, 2022 11:55 PM
From: Gary McNair
Subject: renaming a chunk file pathname
Many thanks to everyone, great suggestions. I will give the backup/restore a try. I am on 12.10 but will keep the mirroring in mind for the future.
------------------------------
Gary McNair
Original Message:
Sent: Wed March 23, 2022 08:30 PM
From: Gary McNair
Subject: renaming a chunk file pathname
Hello,
I have a chunk file that I want to move to a different directory. This is not the online_root file, just a different file that holds a few dbspaces.
After doing some searching, I found a page on the IBM support site that says this can be achieved during a restore with 'ontape'.
ontape –r -rename –p old_path -o oldo_ffset -n new_path -o new_offset
Our DB's are transactionless, our TAPEDEV and LTAPEDEV=/dev/null (Linux). So I don't understand what I can restore from, and would prefer not to do a restore.
Thanks for any advice,
Gary
------------------------------
Gary McNair
------------------------------
#Informix