Re: ANSI mode DB's and DBIMPORT

Gary D. Hansen@ECCI 10/15/99 09:31 AM I have a DB that runs in ANSI mode. When you do a dbimport -ansi your logical logs will fill at a rapid rate. What I do before doing the dbimport is set my logical log tape device to /dev/null and bounce Informix or set my logical log tape device to /dev/null and run ontape -a every once in a while durring the dbimport. "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> on 10/14/99 06:07:18 PM To: FProse <fprose@rocketmail.com> cc: informix-list@iiug.org (bcc: Gary D. Hansen/AMPAC/ECCI) Subject: Re: ANSI mode DB's and DBIMPORT FProse wrote: > > Ran into an 'interesting' situation this weekend using > dbexport/dbimport to move an ANSI db between two servers (the > destination was 7.3). > > when we performed the dbimport using: > > dbimport dbname -d dbs01 -l -ansi > > dbimport started filling up the logical logs. I've used the "-l" > option before, and only seen a minimum amount of log usage. The > "-ansi" switch just blew us out of the water. The log space we > maintain is more than adequate for production OLTP but not even close > for this activity. Informix couldn't dump and checkpoint fast enough! > > We finally ended up importing without the "-l" and "-ansi" switch and > then using ontape to "convert". > > Do I have a bug here? I don't think you will find many people with ANSI MODE experience (watch them flood in NOW! :). They are just more trouble than they are worth. It is possible that they use more log space, but I would check with Informix regarding known problems. Certainly loading with no logging and switching on after the load is the preferred method. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock http://www.informix.com |//////// /| | mailto:mdstock@mydas.freeserve.co.uk |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+

ghansen@ecc.com wrote: > > Gary D. Hansen@ECCI > 10/15/99 09:31 AM > > I have a DB that runs in ANSI mode. When you do a dbimport -ansi your logical > logs will fill at a rapid rate. What I do before doing the dbimport is set my > logical log tape device to /dev/null and bounce Informix or set my logical log > tape device to /dev/null and run ontape -a every once in a while durring the > dbimport. [SNIP] You do not have to bounce the engine to enable the change in LTAPEDEV if you make the change using onmonitor instead of just editing the ONCONFIG file as onmonitor will change the in-shared-memory value of LTAPEDEV also. Art S. Kagel