Re: Problem with dbexport

Hi Ravi ! I have similar problem with HDR replication pair - when you're running dbexport on the secondary server, and users inserts/updates tables. --------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 Ravi Krishna <srkrishna@yahoo.com> wrote in message news:7uf9u0$ib6$1@nnrp1.deja.com... > Hi, > > For some reasons we had to take the dbexport of the database, to be > dbimported later. The dbexport went off smoothly, or so we thought. > When he had to dbimport back it ran into problems, as mentioned below:- > > 1.{ unload file name = area_00100.unl number of rows = 120 } > > The "number of rows" mentioned above is critical for dbimport, bcos it > matches it with the .unl file. In our case we found that while the .unl > file has correct # of rows, the number of rows mentoned above was > incorrect. It was much less than the actual # of rows. Consequently > dbimport died with error message "dbimport data corrputed". > > 2. One table had a field missing in the table definition but that field > was present in the .unl file. As a result dbimport died with an error > message "no of fields do not match no of columns". > > 3. Some of the stored procedures weren't up to date. It was reflecting > the older version. > > We were forced to reload data from the tape and take dbexport again. But > this time it was successful. > > Version: Informix IDS 7.30UC8 > Hardware: IBM RS6000 running AIX 4.3.2 > > Has anyone experienced this problem before. Is dbexport unreliable. > > Ravi. > > > Sent via Deja.com http://www.deja.com/ > Before you buy.