Oninit cdi / Archive
Talk to an expert →

Re: Copy Informix Chunks using dd ?

Posted in 2008

Topics: Storage & Space Management, Server Administration, Migration, Import/Export & Data Conversion

irvingdba@gmail.com — — source: Usenet: comp.databases.informix

On Jul 31, 3:15 pm, "Jarrod Teale" <Jarrod.Te...@fonterra.com> wrote: >  Another option is to get the engine to do the work. > Create the new chunk on the new device as a mirror to the first, > existing chunk. > Change the new chunk to be the primary, break the mirror and voila! You > data is moved! > > Jarrod > > > > -----Original Message----- > From: informix-list-boun...@iiug.org > > [mailto:informix-list-boun...@iiug.org] On Behalf Of Paul Watson > (Oninit) > Sent: Friday, 1 August 2008 5:14 a.m. > To: informix-l...@iiug.org > Subject: Re: Copy Informix Chunks using dd ? > > irving...@gmail.com wrote: > > Hi, > >     We are thinking to copy one of the chunks (which has database > > system tables and other small tables ) using dd unix command in a > > dbspace to a new raw device, break the existing link and relink the > > new raw device with same path, because it is a big database and we > > need to release a raw volume because of some Volume manager reorg. > > Instead of using either HPL or dbimport/export which takes lot of > > time, so we are thinking to copy only one chunk which is less than 4 > > GB takes less time. Did any one try this and worked? Any comments, > > suggestions are greately appreciated. Thanks in advance. > > > -DBA > > As long as the instance is offline you'll be fine, make the block size > nice and large and it will fly along > > Cheers > Paul > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text - > > - Show quoted text - Jarrod, How can I change the status of Mirror chunk as Primary chunk ? -- D

↪ replying to irvingdba@gmail.com
Superboer — — source: Usenet: comp.databases.informix

> Jarrod, > How can I change the status of Mirror chunk as Primary > chunk ? > -- D mirror the whole dbspace in question. bring down the chunk you want to move using onspaces.(primary) relink the chunk to be moved to a new unused raw device.(make sure permissions are ok!!) bring up the 'moved ' and 'downed' chunk using onspaces. get rid of mirorring if required. Superboer.

Glossary