RE: ANSI mode DB's and DBIMPORT

I'll put in my two-cents worth on ANSI and dbexport/dbimport. The way Informix works with an ANSI database is that you can change the logging mode TO ANSI, but once changed you cannot change it back. The way that I know to address FP's issue is this: Use dbimport with no logging to get the database loaded. Set TAPEDEV to /dev/null. Use ontape -s -ANSI dbname to change the logging mode to ANSI. Set TAPEDEV back to your 'normal' setting. This completely avoids the problem with logs filling up during your import. In their best incarnation, ANSI databases are a pain in the rear. This gets multiplied if you have mixed ownership of the database objects -- You can never get a clean 100% accurate dbschema. -----Original Message----- From: ghansen@ecc.com [mailto:ghansen@ecc.com] Sent: Friday, October 15, 1999 9:31 AM To: informix-list@iiug.org Subject: 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 |/ ////////| +----------------------+-----------------------------------+-----------+