Re: Update Statistic question

Huy Vu wrote: > > Thanks again for your answers. > > I always do an export with 'dbexport'. > If I don't do 'update statistic' before running 'dbexport' sometime > 'dbimport' stops in complaining the nrows of 'tableA' is not match with > 'tableA'.unl file for example. (or data corrupted). This is when the number of rows found in the unl file is validated against the number in your export sql script. This is in the comments, so be very careful about modifying even the comments in this file. As far as I know (I haven't seen 7.31) this value is taken from the actual rows unloaded, not the statistics. But that could have changed if the update statistics commands are also exported now. > How about the 'update statistic' if I have to migrate a Informix SE > database to IDS? The rules remain the same, make sure you run update statistics AFTER the load, whether after the dbimport, or during the dbimport with the generated commands. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | 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 |/ ////////| +----------------------+-----------------------------------+-----------+