Re: renaming a chunk

On 04/06/07, floyd@fwellers.com <floyd@fwellers.com> wrote: > > Hi, > We are using IDS10.0FC5 > We would like to rename a chunk to satisfy a link checking script that we > have running on startup. > It seems that the recommended ( apparently only available ) way is to do a > rename during restore. That is not an option for us. > > I was wondering if it would work to : > > Bring the database to single user mode > drop the chunk with onspaces, > drop the link that points it to the device > recreate the link, pointing to the exact same device, but with the new chunk > name, > add the chunk with onspaces. > > I'm assuming that since we're pointing to the same raw device, the data will > still be intact and the database won't care. > > Any thoughts ? > > Thanks, > Floyd > > > ======================== > email: floyd@fwellers.com > Home: 703-430-0805 > Cell: 703-477-6045 > ======================== > > www.one.org > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > Floyd You can rename a table at any time, or even a database, but you can only rename a chunk at restore. Trying your suggestion will send the data of that chunk (and probably dbspace) bye-byes for good, rapidly followed by your reputation, employment and company !! Even if you could get close to dropping then when you try to re-add the engine will initialise the structures and your data will be unavailable again ! You could migrate all your data from the space then drop and recreate it, however I think amending the script might be simpler, quicker and much safer. Keith