Re: Unload to TAPE?

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. } 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!!!!! } ------------------------------------------------------------------------- } Cheryl Kendricks } Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov } DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 } Database Administrator - DOL Job Corps San Marcos, Texas } ------------------------------------------------------------------------ } } On 12 Jun 1996, June Tong wrote: } } > Gary Hale (hgary@eg570.egclassic.com) wrote: } > } > : I need to unload a table to tape, this table is over a 1gig and I am } > : unable at this time to create any more records (rows) in it? error } > : 271! I would like to unload this data to tape and rebuild it. I am } > : using 5.1 Informix SE on aix 3.2.5, how do I unload to tape? } > } > Have you tried } > UNLOAD TO '/dev/rmt0' SELECT * FROM tabname } > ^^^^^^^^^ or other tape device } > } > However, I don't think unloading the data and rebuilding the table will get } > rid of this -271 error. The table will be just as big after you rebuild it as } > it was before. } June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.