Database Copy

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

On 06/06/07, howie.lfc@googlemail.com <howie.lfc@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-list@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

if the target is the same as the source, eq you come from hpux11.11 940.FC4 and also goto hpux11.11 940.FC4 then a backup/restore should be the fastest way. Otherwise you may consider remote selects , High perf loader unload to fifos etc a lot of handy work, scripting... has been done before... 1.5 TB sap db was copied in less then 48 hours. using fifos, HPL and remote selects using steam pipe for smaller tables.... it was copied to another instance on the same machine though.... Superboer. howie.lfc@googlemail.com schreef: > 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

"Keith Simmons" <smiley73@googlemail.com> wrote in message news:mailman.109.1181127818.13675.informix-list@iiug.org... > On 06/06/07, howie.lfc@googlemail.com <howie.lfc@googlemail.com> wrote: > 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 !) Yes! This is a good point. Although Informix will stop you inadvertently creating a new chunk of a chunk already in use on the same db server, it'll quite happily let you fsck up the root dbspace of another instance with an inaccurate re-directed restore. Er, or so I'm told!

Hi, Howard. Just a thought. If you use all chunk on block file system(not using raw device), how about the following ? (Be aware, I do not test it.) mount new disk on HP-UX. Then dump / restore. dump 0f - /dev/rdsk/c0t0d0s7 | (cd /ifx_data; restore xf -) umount old disk (Need oninit -ky before umount). mount new disk on old device. Then oninit. How do you think my idea ? Just my $0.02. -- Tsutomu Ogiwara from Tokyo Japan. >From: "howie.lfc@googlemail.com" <howie.lfc@googlemail.com> >To: informix-list@iiug.org >Subject: Database Copy >Date: Wed, 06 Jun 2007 03:38:27 -0700 > >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-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ MSNグルメ「今日のレシピ」をRSSで毎日逃さずキャッチできる MSN版IE7 http://promotion.msn.co.jp/ie7/