Re: changing bad location for root chunk

On Mon, 12 May 2003 15:47:48 -0400, Peter Link wrote: Know that the Block device and the Character device both the same physical device. So, what you need to do is: 1- shutdown the engine 2- rename the Block device special file, 3- create a link, named the same as the Block device, which points to the character device. 4- restart the engine. I don't know about AIX but on DGUX and IB HPUX device special files are destroyed and recreated at boot time so your startup rc scripts will have to perform steps 2 & 3 again at boot time before starting the engine. I had to do this when I took over our servers here. Worked like a charm. Like everything you have not tried before, make safety backups, and have fun. Art S. Kagel > I've inherited an IDS 7.31 UD4 database running on AIX 4.3.3 ML10, which > unfortunately was set up 6 years ago with chunks pointing directly (no > symlinks) to the block devices instead of the character-special devices. > This includes the root chunk. > > We are working with our application vendor's DBA to move our > badly-interleaved tables to separate dbspaces that are correctly defined > with symlinks, raw disk, properly-sized extents, etc. > > My question is: is there a safe way to get the root chunk re-defined to > point to the character-special device instead of the block device, and > better yet, with a symlink? > > A secondary question: is it worth the bother to change it now? > > > Below are a few lines from onstat -d: Chunks > > address chk/dbs offset size free bpages flags pathname > > 60052210 1 1 125 62500 48881 PO- /dev/root_chunk > > > Peter Link > University of Michigan Health System > Ann Arbor, MI USA