RE: changing bad location for root chunk

You can using Informix mirroring to mirror the root dbspace, then move the primary chunk off line, and start it up moving the mirror to the primary. Wayne Martin Database Administrator Kmart Corporation -----Original Message----- From: plink1@excite.com [mailto:plink1@excite.com] Sent: Monday, May 12, 2003 3:48 PM To: informix-list@iiug.org Subject: changing bad location for root chunk 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 This message and its contents (to include attachments) are the property of Kmart Corporation (Kmart) and may contain confidential and proprietary information. You are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on information contained herein is strictly prohibited. Unauthorized use of information contained herein may subject you to civil and criminal prosecution and penalties. If you are not the intended recipient, you should delete this message immediately.