FW: FW: FW: FW: FW: Explain (more is better?)

-----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Obnoxio The Clown Sent: Thursday, December 14, 2000 1:08 PM To: informix-list@iiug.org Subject: Re: FW: FW: FW: FW: Explain (more is better?) In the year of Our Lord Thu, 14 Dec 2000 12:14:59 +0200, "Dirk Moolman" <dirkm@reach.co.za> broke a vow of silence to utter: >-----Original Message----- >From: owner-informix-list@iiug.iiug.org > >In the year of Our Lord Wed, 13 Dec 2000 07:15:23 +0200, "Dirk Moolman" ><dirkm@reach.co.za> broke a vow of silence to utter: > >>-----Original Message----- >>From: owner-informix-list@iiug.iiug.org >> >>In the year of Our Lord Tue, 12 Dec 2000 10:02:36 +0200, "Dirk Moolman" >><dirkm@reach.co.za> broke a vow of silence to utter: >> >>>If we do, everyone else also missed it. We have a case (related to >>>performance) open with Tech Support now for about 4 months. We've looked >>at >>>HP patches, configuration changes, kernel parameters - the works ....... >> >>>Mmmmm....well, I've run plenty of different OLTP systems on HP using >>OPTCOMPIND>>>0, and never had a problem. >> >>>Have you guys ever done a full dbexport/initialise/dbimport? >> >>Not recently no, but we only went live in August this year, so the database >>wasn't initialised long ago. We unloaded from Online5 and loaded into >>9.21FC1 > >>How? > >1) mounted filesystem of target machine on source machine >2) on source: unload to ...... select * from ........... >3) on target: load from ...... insert into ........ > >Simple and easy (just not the fastest way) >Simple and easy? As opposed to dbexport/dbimport? You're right or course, dbexport / dbimport would have been easy too (see, I'm still having problems with the BRAIN=1 parameter). The only real work I had to do was designing the new layouts (disks & dbspaces) and editing the scripts for the new dbspaces. We redesigned, moving from - "old machine" to HP L2000 (forgive the ignorance, but I don't know the old machine was, a K-something .....) - Informix mirroring to hardware mirroring (raid01), etc. HP-UX 10.xx to HP-UX 11.00 Online5 to IDS2000 9.21FC1

Dirk Moolman wrote: [SNIP] > > > >1) mounted filesystem of target machine on source machine > >2) on source: unload to ...... select * from ........... > >3) on target: load from ...... insert into ........ > > > >Simple and easy (just not the fastest way) > > >Simple and easy? As opposed to dbexport/dbimport? > > You're right or course, dbexport / dbimport would have been easy too (see, > I'm still having problems with the BRAIN=1 parameter). The only real work I > had to do was designing the new layouts (disks & dbspaces) and editing the > scripts for the new dbspaces. My dbexport/dbimport replacement utility myexport/myimport can do the dbspace mapping for you. Available from the IIUG Software Repository. Art S. Kagel > We redesigned, moving from - > "old machine" to HP L2000 (forgive the ignorance, but I don't know the old > machine was, a K-something .....) - Informix mirroring to hardware mirroring > (raid01), etc. > HP-UX 10.xx to HP-UX 11.00 > Online5 to IDS2000 9.21FC1