Re: Unload to TAPE?

Not to mention that tbunload/onunload won't help you get space back. These utilities merely do page copies (which is why they are so fast), but all space and any corruption will remain. You CAN get space back by using the regular unload/load or dbload utilities or by altering a table index to cluster. In article <4ppen3$989@cssun.mathcs.emory.edu>, June Tong <junet@informix.com> wrote: >The fact that it returns error -271 indicates that there is no deleted space >in the table (or it would be re-used). In any case, the poster is using SE, >and there is no tbunload. > > >} Cheryl Kendricks wrote: >} TBUNLOAD will get some of your deleted space back, But on 5.03 engine >} I use is catiously "Do UPD STATS on TABLE, get row count from TBCHECK pT >} (LOCKS TABLE in exclusive mode) before and after TBUNLOAD" >} Hope this helps!!!!! Regards, Cathy -------------------------------------------------------------------------------- Cathy Kipp E-mail: ckipp@verinet.com Fort Collins, Colorado, USA