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: Wednesday, December 13, 2000 10:44 PM To: informix-list@iiug.org Subject: Re: FW: FW: FW: Explain (more is better?) 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)