Re: renaming a chunk

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. You assume incorrectly - the data will be there and the engine will duly zap parts of it upon adding it back. Also, it's unlikely (there are caveats) that you will be able to drop the chunk while it is not empty, and this is not necessarily a bad thing. (you should also have enough hints on how to modify your strategy) > > Any thoughts ? > > Thanks, > Floyd > -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm