Re: Problem with dbexport

Posted in 1999

Robert Taylor — Mon, 18 Oct 1999 16:59:55 +0100 — source: Informix-list mailing list archive (1991-1998)

We've had it at our site. It was a constant pain in the butt. To solve it our Sysadmin created a Perl script which would check the unload file against the schema and correct the number of rows in the schema. If I talk to him nice he'll let me send you it. This was on Informix version 4 running on SCO OpenServer. Apparently the total rows in the DBSChema is incorrect and the rows unloaded is correct. Try running an UPDATE STATISTICS before dbexport. We've since upgraded to version 7 and haven't experienced the problem, but then again we haven't done a dbexport ....... ; )