DBexport -9810 error

Hi All, I've never experienced issues with dbexport before, but this is a doozie! Informix 11.50.FC9 SunOS Solaris 10 The dbexport is kicking back a "-9810 - Smart-large-object error." but with no secondary error message. I believe this error has to do with possible corruption due to onloading the database with the BTS blade registered. Yes, we NOW know that is a BIG No-No. We are hoping that we don't have to rebuild the db from scratch --> it is about 32GB. Another strange part of the issue is the table schema right before dbexport crashed: =================== { TABLE "informix".btsfse_storage row size = 2136 number of columns = 1 index size = 0 } create table "informix".btsfse_storage ( sto_row "informix".bts_fsestoragerow ) extent size 16 next size 16 lock mode page; execute procedure bts_CreateStorage ( "bts_index", 11 ); revoke all on "informix".btsfse_storage from "public" as "informix"; -9810 - Smart-large-object error. =================== An "Execute Procedure" as part of a schema? I verified this by running a dbschema of that table -- yep, the execute is indeed in the schema. Could the underlying db schema be corrupted? Thanks, Mike Hoffman

Hi, did you execute an oncheck -cS ? Is there anything in online.log ? Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "MICHAEL HOFFMAN" <mrh@panix.com> An: ids@iiug.org Gesendet: Freitag, 14. November 2014 05:23:10 Betreff: DBexport -9810 error [34165] Hi All, I've never experienced issues with dbexport before, but this is a doozie! Informix 11.50.FC9 SunOS Solaris 10 The dbexport is kicking back a "-9810 - Smart-large-object error." but with no secondary error message. I believe this error has to do with possible corruption due to onloading the database with the BTS blade registered. Yes, we NOW know that is a BIG No-No. We are hoping that we don't have to rebuild the db from scratch --> it is about 32GB. Another strange part of the issue is the table schema right before dbexport crashed: =================== { TABLE "informix".btsfse_storage row size = 2136 number of columns = 1 index size = 0 } create table "informix".btsfse_storage ( sto_row "informix".bts_fsestoragerow ) extent size 16 next size 16 lock mode page; execute procedure bts_CreateStorage ( "bts_index", 11 ); revoke all on "informix".btsfse_storage from "public" as "informix"; -9810 - Smart-large-object error. =================== An "Execute Procedure" as part of a schema? I verified this by running a dbschema of that table -- yep, the execute is indeed in the schema. Could the underlying db schema be corrupted? Thanks, Mike Hoffman ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

oncheck -cS and oncheck -cs both return without error.The online.log is clean during the onchecks and during the dbexport. No errors, no Asserts Violations.