Re: Dbexport: Does not unload all tables...

Tom Downs wrote: > > I work for a company where we recently upgraded our informix 4gl from > v4.1 to 5.1. However, as of this date, I have not recreated the > database under the new version. It has been recommended to me that I > use dbexport & dbimport to recreate the database. When I attempted to > run dbexport, it finished with in 2 minutes. When I looked at the > unload files, only half of the existing tables were unloaded. No error > messages were shown. (And yes, I ran dbexport with the -c option.) > > I am curious if anyone else has encountered this, and if so, what to do > to get all tables to unload. > I've experienced this on 4.1 - the -c option seemed to have no effect. There were some problems in data (I can't remember what) and the export bombed each time it hit one. As dbexport dbimport may have to be done quickly to minimise down-time I suggest running test unloads ahead of the scheduled conversion. Ian