Re: dbexport core dumps
"scottishpoet" <dryburghj@yahoo.com> wrote in message
news:1169030922.181023.143920@a75g2000cwd.googlegroups.com...
>
> also does oncheck run clean? are there other indexes on the table thats
> just been unloaded other than the one that are in the create tabel
> statement? if so, can you drop these and remember to create them
> manually afterwards?
An oncheck -cD works fine.
oncheck -cI stops almost immediately:
<informix@f40>/ifx_dump2/ardenta> oncheck -cI hpldb
Validating indexes for hpldb:informix.systables...
Index tabname
Index tabid
<informix@f40>/ifx_dump2/ardenta>
If I do a dbschema of the database, then use that to create an empty
database and dbexport *that*, the dbexport completes fine, so it's clearly
data- (or maybe index-) related.
Neil,
If the oncheck -cD passes and as you mentioned below the index blows. I
would drop all indexes, perform your the export, import the data, then run
the index creates from the successful dbschema run. It would be an extra
step but atleast you get a good export.
Thanks
"Neil Truby"
<neil.truby@arden
ta.com> To
Sent by: informix-list@iiug.org
informix-list-bou cc
nces@iiug.org
Subject
Re: dbexport core dumps
01/17/2007 02:21
PM
"scottishpoet" <dryburghj@yahoo.com> wrote in message
news:1169030922.181023.143920@a75g2000cwd.googlegroups.com...
>
> also does oncheck run clean? are there other indexes on the table thats
> just been unloaded other than the one that are in the create tabel
> statement? if so, can you drop these and remember to create them
> manually afterwards?
An oncheck -cD works fine.
oncheck -cI stops almost immediately:
<informix@f40>/ifx_dump2/ardenta> oncheck -cI hpldb
Validating indexes for hpldb:informix.systables...
Index tabname
Index tabid
<informix@f40>/ifx_dump2/ardenta>
If I do a dbschema of the database, then use that to create an empty
database and dbexport *that*, the dbexport completes fine, so it's clearly
data- (or maybe index-) related.
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list