ANSI mode DB's and DBIMPORT

Posted in 1999

FProse — Tue, 12 Oct 1999 10:38:30 -0700 — source: Informix-list mailing list archive (1991-1998)

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?