dbexport problem

Hi all, I am relatively new to informix. I need to (db)export a database from a machine (sco/informix 6) and (db)import it on another (linux/informix 7). dbexport fails on the first machine saying "100 -ISAM error - ...". It looks that an unique index contain duplicate values (I cannot figure out how this could be possible). I tried a lot to make the export work (I ran secheck) but I was unable to export the database. I searched the Internet but found nothing. There is anybody that encountered this problem and can suggest a solution ? Thanks Giampaolo Gallo

I had a problem which may or may not be related when creating an index on a big table table. The column being indexed was serial , therefore I used create UNIQUE which would seem like the sensible option. However I got an error about duplicate values ( wierd but true ). My solution was just to leave the UNIQUE bit out, worked for me. <gp@nospam-mabltd.com> wrote in message news:3829526E.EA66DA49@nospam-mabltd.com... > > > Hi all, > > I am relatively new to informix. > > I need to (db)export a database from a machine (sco/informix 6) and > (db)import it on > > another (linux/informix 7). dbexport fails on the first machine > saying "100 -ISAM error - ...". > > It looks that an unique index contain duplicate values (I cannot figure > out how this > > could be possible). I tried a lot to make the export work (I ran secheck) > but I was unable to > > export the database. I searched the Internet but found > nothing. There is anybody that encountered this > > problem and can suggest a solution ? > > Thanks > > Giampaolo Gallo > > > > > >

Robert Taylor wrote: > > I had a problem which may or may not be related when creating an index on a > big table table. > > The column being indexed was serial , therefore I used create UNIQUE which > would seem like the sensible option. > However I got an error about duplicate values ( wierd but true ). Different problem from Giampaolo's. When you declare a column type SERIAL it returns the next available serial number if a zero is inserted, it does NOT guarantee the uniqueness of the values in the column unless you create a UNIQUE index on the column BEFORE any data is inserted, certainly before any duplicate rows are created. > My solution was just to leave the UNIQUE bit out, worked for me. Ahh, but now you can still have applications inserting and updating rows to contain duplicated explicit values in that serial column. The REAL solution is to clear out the duplicates and then create a UNIQUE index, or to unload the table, empty (or drop/create) it, and reload using something like dbload or my ul.ec program that can ignore and log the duplicates so you can review and delete the incorrect rows and insert the correct ones. Alternatively you could unload the data ORDER BY the serial column and manually edit the unload file to remove or modify the duplicate rows. Art S. Kagel > <gp@nospam-mabltd.com> wrote in message > news:3829526E.EA66DA49@nospam-mabltd.com... > > > > > > Hi all, > > > > I am relatively new to informix. > > > > I need to (db)export a database from a machine (sco/informix 6) and > > (db)import it on > > > > another (linux/informix 7). dbexport fails on the first machine > > saying "100 -ISAM error - ...". > > > > It looks that an unique index contain duplicate values (I cannot figure > > out how this > > > > could be possible). I tried a lot to make the export work (I ran secheck) > > but I was unable to > > > > export the database. I searched the Internet but found > > nothing. There is anybody that encountered this > > > > problem and can suggest a solution ? > > > > Thanks > > > > Giampaolo Gallo > > > > > > > > > > > >