Red Hat Enterprise Linux Server release 5.8 (Tikanga)
$ dbschema -d $DBNAME -t invc_hdr
DBSCHEMA Schema Utility INFORMIX-SQL Version 7.25.UC6R1
Copyright (C) Informix Software, Inc., 1984-1997
Software Serial Number CML#R364550
100 - ISAM error: duplicate value for a record with unique key.
I can't schema this table. Can't find 'myschema' either on the server to try a schema with that either.
I know what the indexes look like from other servers so I've dropped the unique index and rebuilt it as non-unique.
Did a search for the old unique value and it didn't come up with anything.
I'm thinking there is something corrupt in sysindexes, syscolumns, or systables. Has anyone seen this?
This table is huge and an unload, remove table, rebuild, and reload of data isn't an option.
Any ideas.
Tom K
$ dbschema -d $DBNAME -t invc_hdr
DBSCHEMA Schema Utility INFORMIX-SQL Version 7.25.UC6R1
Copyright (C) Informix Software, Inc., 1984-1997
Software Serial Number CML#R364550
100 - ISAM error: duplicate value for a record with unique key.
I can't schema this table. Can't find 'myschema' either on the server to try a schema with that either.
I know what the indexes look like from other servers so I've dropped the unique index and rebuilt it as non-unique.
Did a search for the old unique value and it didn't come up with anything.
I'm thinking there is something corrupt in sysindexes, syscolumns, or systables. Has anyone seen this?
This table is huge and an unload, remove table, rebuild, and reload of data isn't an option.
Any ideas.
Tom K