Re: **HELP**HELP**tbunload!!!!

Roshanak N. Cyrus (rnc4236@is.nyu.edu) wrote: : USING INFORMIX 5.0 On-line : I'm trying to do a "tbunload -t /dev/rmt/0m prism" prism is the database : name. And I get: : Memory Allocation (COREDUMP) : I did a "tbcheck -pe prism" and found: : Disk usage for Chunk 9 Start Length : ------------------------------------------- --------- --------- : prism:informix.t_mem 575672 20000 : FREE 595672 18728 : OTHER RESERVED Pages 0 2 : ERROR: Extents overlap : CHUNK FREE LIST PAGE 2 1 : TBLSPACE TBLSPACE 3 8063 : prism:informix.systables 8066 8 : Could the overlaping extent be the case of this error? Any ideas? I guess it *could*, but I don't think you have overlapping extents, I think you have a duff version of tbcheck. If you look at the offsets and lengths of the extents you show us, you can see that they do *not* overlap, they are merely printed in non-sorted order. If this is also true of the extents that you don't show us, then that is not your problem. There was a version of tbcheck that used to do this, but my memory thought it was 4.0, not 5.0, but it's such a long time ago now, I can't be sure. -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.