Quick & Dirty Volume Duplication Question (AREV Specific)
At 21 DEC 2001 03:09:05PM Jim Jefferson wrote:
At the end of a month, we bulk copy (at the O/S level) the contents of our data volume to a month end "snapshot" volume. We go into REVMEDIA in the new volume and change the volume name so SETFILEs will work to the new volume.
Using this method, the indexes are not useable until we remove all indexing from the tables, delete all the !filename files, and rebuild indexing on all the tables. If we don't do this, attempts to query the files gives us messages like "!FILENAME is not available" etc.
What I suspect is that there is something in the !filename record in the !filename file (looks like the original volume label is in there) and maybe even in the ! program in that file.
Is there a quick method I can use to fix up whatever it is that is causing me to have to remove/rebuild the indexes in the snapshot volume? I sort of like this method over COPYTABLE because there are so many tables involved, but the reindexing takes back a lot of the time economy.
Thanks for any info or advice you might provide. Happy Holidays!
Jim
At 21 DEC 2001 04:08PM Victor Engel wrote:
One of the developer utility disks had a utility to do this. Basically, what you need to do is to change the token in the
REVMEDIA record of the REVMEDIA file and also in the appropriate records of the !filename file.
If your old and new labels are the same length, I think you can get away with a simple search/replace operation.
Look for the utility first, though. No need to reinvent the wheel.
At 21 DEC 2001 04:13PM Victor Engel wrote:
It is called RENAME-VOLUME as is located in DISKETTE_FOUR_BP file on disk 4, which is available for download at http://www.revelation.com/WEBSITE/SOFTWARE.NSF/76c3ba2a4214609785256421006d5324/f4747aeb1047084a852563fb006949eb?OpenDocument (Demos & Downloads).
At 24 DEC 2001 02:57AM Cameron Christie wrote:
Beware if you have any dependent indexing defined (also the subject of a Revmedia article, if memory serves.) I don't think this gets picked up by the rebuild utility, and it still needs to be done manually. (It's still heaps better than having to do ALL the tables though…)
At 27 DEC 2001 02:57PM Jim Jefferson wrote:
Thanks! That utility is exactly what I was looking for. I'll give it a whirl.
And thanks for the reminder about dependent indexes. Fortunately, we only have one of those, it only has to be accurate as of close-of-business the previous day, and is rebuilt by a batch process nightly (about the only scenario where I let "them" talk me into using one).
Appreciate the help.
Jim