Re: Unload to TAPE?

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. }