Re: Online 4.0 tbcheck error
}
} We are using Informix Online 4.0 on a HP 9000/822 with HP-UX A.B7.08 C.
} When running tbcheck -cc befreg we get the following error:
}
} Validating database befreg
}
} Validating systables for database befreg
} ERROR: informix.befolkningsreg nextsize 8 != partition.nxtsize 16
} TBLSpace name befolkningsreg
} Owner informix
} TBLSpace number 1000041
} Tabid 113
} Row size 155
} Number of columns 16
} Number of indexes 10
} Number of rows 715067
} Date created 07/06/1992
} TBLSpace version number 34
} TBLSpace type T
} Locking level P
} Number of pages used 59603
} First extent size 16
} Next extent size 16
} Flags 0
} Site
} Database name
}
Personally, i'd try rebuilding the table. If you have enough room in
your partition, and time, i'd turn logging off on the database,
exclusively lock the table, then copy from the old table to a new table
(select * from oldtable insert into newtable). Set the extents on the
new table when creating it. If you do not have room in the partition,
or cannot turn off logging on the database, or get errors using the
first method, unload the table to disk, and use dbload to create the
new table, with the error parameter set (so if you get errors it wont
barf and stop).
--
Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona
-----------------------------------------------------------------
Dyslexsics, Untie! | Visualize Whirled Peas