Re: Database Copy

On 6 Jun, 11:57, "Keith Simmons" <smile...@googlemail.com> wrote: > On 06/06/07, howie....@googlemail.com <howie....@googlemail.com> wrote: > > > > > Informix Ver 9.40.FC4 > > HP-UX 11.11 > > > We have a 350Gb database running baan that the customer wishes to > > replicate. > > They are in the process of purchasing enough disks for this to be > > carried out on the same server as live. > > > The question I have is there any way of copying the database other > > than to use export/import as this has been calculated to take in the > > region of 6 days! > > > The last time I had to carry out anything like this was onto a new > > server which I did by creating all the dbspaces/chunks as live then > > used the level 0 backup to copy the data across....not an option here > > I guess... > > > Thanks in advance.... > > > Howard > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > Howard > > Best way of doing this is to create a new set of disk spaces of the > same size as your existing, create a new onconfig file (with > associated entries in sqlhosts and /etc/services) then restore an > ontape -L 0 using the chunk rename option.> Dead easy, dead quick and totally safe (unless you stuff your links or > renames up !) > > Keith- Hide quoted text - > > - Show quoted text - Thanks Keith, I will take a look at this solution as it appears to be the best way.... On another tack, does anyone have an idea on how to find out which version of informix driver is being used on our system?

Hi Howard. cat $INFORMIXDIR/etc/*cr in your system. HTH. -- Tsutomu from Tokyo Japan. >From: "howie.lfc@googlemail.com" <howie.lfc@googlemail.com> >To: informix-list@iiug.org >Subject: Re: Database Copy >Date: Thu, 07 Jun 2007 14:43:59 -0700 > >On 6 Jun, 11:57, "Keith Simmons" <smile...@googlemail.com> wrote: > > On 06/06/07, howie....@googlemail.com <howie....@googlemail.com> wrote: > > > > > > > > > Informix Ver 9.40.FC4 > > > HP-UX 11.11 > > > > > We have a 350Gb database running baan that the customer wishes to > > > replicate. > > > They are in the process of purchasing enough disks for this to be > > > carried out on the same server as live. > > > > > The question I have is there any way of copying the database other > > > than to use export/import as this has been calculated to take in the > > > region of 6 days! > > > > > The last time I had to carry out anything like this was onto a new > > > server which I did by creating all the dbspaces/chunks as live then > > > used the level 0 backup to copy the data across....not an option here > > > I guess... > > > > > Thanks in advance.... > > > > > Howard > > > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list > > > > Howard > > > > Best way of doing this is to create a new set of disk spaces of the > > same size as your existing, create a new onconfig file (with > > associated entries in sqlhosts and /etc/services) then restore an > > ontape -L 0 using the chunk rename option.> > Dead easy, dead quick and totally safe (unless you stuff your links or > > renames up !) > > > > Keith- Hide quoted text - > > > > - Show quoted text - > >Thanks Keith, > >I will take a look at this solution as it appears to be the best >way.... > >On another tack, does anyone have an idea on how to find out which >version of informix driver is being used on our system? > >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ 最新ブラウザ MSN版IE7をまだ体験していない方は、こちらからダウンロード！ http://promotion.msn.co.jp/ie7/

On 8 Jun, 01:54, "Ogiwara Tsutomu" <tsutomu_ogiw...@hotmail.com> wrote: > Hi Howard. > > cat $INFORMIXDIR/etc/*cr in your system. > > HTH. > -- > Tsutomu from Tokyo Japan. > > > > > > >From: "howie....@googlemail.com" <howie....@googlemail.com> > >To: informix-l...@iiug.org > >Subject: Re: Database Copy > >Date: Thu, 07 Jun 2007 14:43:59 -0700 > > >On 6 Jun, 11:57, "Keith Simmons" <smile...@googlemail.com> wrote: > > > On 06/06/07, howie....@googlemail.com <howie....@googlemail.com> wrote: > > > > > Informix Ver 9.40.FC4 > > > > HP-UX 11.11 > > > > > We have a 350Gb database running baan that the customer wishes to > > > > replicate. > > > > They are in the process of purchasing enough disks for this to be > > > > carried out on the same server as live. > > > > > The question I have is there any way of copying the database other > > > > than to use export/import as this has been calculated to take in the > > > > region of 6 days! > > > > > The last time I had to carry out anything like this was onto a new > > > > server which I did by creating all the dbspaces/chunks as live then > > > > used the level 0 backup to copy the data across....not an option here > > > > I guess... > > > > > Thanks in advance.... > > > > > Howard > > > > > _______________________________________________ > > > > Informix-list mailing list > > > > Informix-l...@iiug.org > > > >http://www.iiug.org/mailman/listinfo/informix-list > > > > Howard > > > > Best way of doing this is to create a new set of disk spaces of the > > > same size as your existing, create a new onconfig file (with > > > associated entries in sqlhosts and /etc/services) then restore an > > > ontape -L 0 using the chunk rename option.> > > Dead easy, dead quick and totally safe (unless you stuff your links or > > > renames up !) > > > > Keith- Hide quoted text - > > > > - Show quoted text - > > >Thanks Keith, > > >I will take a look at this solution as it appears to be the best > >way.... > > >On another tack, does anyone have an idea on how to find out which > >version of informix driver is being used on our system? > > >_______________________________________________ > >Informix-list mailing list > >Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > _________________________________________________________________ > MSN IE7 http://promotion.msn.co.jp/ie7/- Hide quoted text - > > - Show quoted text - when looking in $INFORMIXDIR/etc/*cr these files are displayed.... IDS2000-cr MSG-cr 2004 GLS-cr The contents being... IDS2000-cr IBM Informix Dynamic Server Version 9.40.FC4 Copyright (C) 1986-2004 IBM Corporation, All rights reserved MSG-cr IBM Informix Dynamic Server Version 9.40.FC4 Copyright (C) 1986-2004 IBM Corporation, All rights reserved GLS-cr INFORMIX LIBGLS LIBRARY Version 4.00.FC4 Copyright (C) 1986-2004 IBM Corporation, All rights reserved My question is, where does it say which Informix driver is being used?

howie.lfc@googlemail.com wrote: > On 8 Jun, 01:54, "Ogiwara Tsutomu" wrote: >> cat $INFORMIXDIR/etc/*cr in your system. > > when looking in $INFORMIXDIR/etc/*cr these files are displayed.... > IDS2000-cr > MSG-cr > 2004 GLS-cr > The contents being... > IDS2000-cr > IBM Informix Dynamic Server Version 9.40.FC4 > Copyright (C) 1986-2004 IBM Corporation, All rights reserved > > MSG-cr > IBM Informix Dynamic Server Version 9.40.FC4 > Copyright (C) 1986-2004 IBM Corporation, All rights reserved > > GLS-cr > INFORMIX LIBGLS LIBRARY Version 4.00.FC4 > Copyright (C) 1986-2004 IBM Corporation, All rights reserved > > My question is, where does it say which Informix driver is being used? That information tells you that none of the client software is installed, so no driver per se is in use. I'm not clear from the removed part of the messages why you need to know about the driver. The DB-Export and DB-Import programs come with IDS, so the version you have is 9.40.FC4. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/