Copy Informix Chunks using dd ?

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

irvingdba@gmail.com said: > 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. It has been done, it does work. It is not supported. -- Bye now, Obnoxio http://obotheclown.blogspot.com/

irvingdba@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

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-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Paul Watson (Oninit) Sent: Friday, 1 August 2008 5:14 a.m. To: informix-list@iiug.org Subject: Re: Copy Informix Chunks using dd ? irvingdba@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-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

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 - Hello Thank you all, Copying the chunks with dd command worked very well, with no issues. However I have to try the mirroring option mentioned by Jarrod Teale. Thanks you