dbexport and dbimport problem .... help

I'm using Informix Online on AIX. Have problem with dbexport to a 4mm tape (2Gb) and then dbimport back. Done dbexport with stated command : dbexport dbname -t /dev/rmt0 -b 16 -s 2048000 When dbimport, it is not complete. dbimport dbname -t /dev/rmt0 -b 16 -s 2048000 But some tables are missing. Thank God I have a backup. Tried again dbexport and dbimport, still same problem. Could anyone help me?

Ameerul@mesiniaga.com.my wrote: > I'm using Informix Online on AIX. Have problem with dbexport to a 4mm tape (2Gb) and then dbimport > back. Done dbexport with stated command : > dbexport dbname -t /dev/rmt0 -b 16 -s 2048000 > > When dbimport, it is not complete. > > dbimport dbname -t /dev/rmt0 -b 16 -s 2048000 > > But some tables are missing. Thank God I have a backup. > > Tried again dbexport and dbimport, still same problem. Could anyone help me? Hi, I assume you ran the job with DBA privileges. Are there any massages in the logfiles of dbexport / dbimport that indicate a problem? Regards -- Helmut Leininger Bull AG / Vienna Open Systems Support Email: h.leininger@bull.at helmut.leininger@bull.net This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.

I also had this problem and Informix suggested using multiple tapes as other people have described. But I got the following error when I tried to reload: *** load table *** load file has different number of columns than table. This did not make sense as I have exported and imported this database before to/from disk. So I used "dd" to get some data of the tape onto disk and tried the import again but pointing to the file on disk which started to work. It obviously fell over as I only took a few Meg from tape. Informix suggested using a diff delimiter from "|" and to check that there were no "|"'s in the date. The load file looked ok and rather than try exporting to tape using a diff delimiter I just exported to disk and compressed the unload files as I knew I could def get the import working this way.

If a column has the delimiter (usually "|") embedded in its field value, the row will be mis-parsed and the dbimport may fail. Hope this helps. Tam McLaughlin wrote: > I also had this problem and Informix suggested using multiple tapes as other > people > have described. But I got the following error when I tried to reload: > > *** load table *** > load file has different number of columns than table. > > This did not make sense as I have exported and imported this database before > to/from > disk. So I used "dd" to get some data of the tape onto disk and tried the > import again but pointing > to the file on disk which started to work. It obviously fell over as I only > took a few Meg from tape. > Informix suggested using a diff delimiter from "|" and to check that there > were no "|"'s in the date. > The load file looked ok and rather than try exporting to tape using a diff > delimiter I just exported to disk and compressed the unload files as I knew > I could def get the import working this way.