Reorganize the 'informix'.TBLSpace to allow for fr

Posted in 2016

Topics: Storage & Space Management, Platform-Specific Issues

LARRY — Tue, 19 Jul 2016 21:01:37 — source: IIUG Forums & Mailing Lists

Solaris 10 IDS 11.50.FC8 We have been reorganizing and cleaning up one of our databases, and we have been able to delete several chunks that were no longer needed. Chunks in which the 'informix'.TBLSpace resides have been freed up as well, however the data is spread out and prohibits the deletion of the extra chunks. Is there an easy way to reorganize the 'informix'.TBLSpace to compact the space and allow the deletion of the extra chunks? Larry

↪ replying to LARRY

Art Kagel — Wed, 20 Jul 2016 02:46:07 — source: IIUG Forums & Mailing Lists

Only by moving the tables to another dbspace an dropping the original. Art On Jul 19, 2016 17:01, "LARRY SORENSEN" <LSORENSEN25@msn.com> wrote: > Solaris 10 > > IDS 11.50.FC8 > > We have been reorganizing and cleaning up one of our databases, and we have > been able to delete several chunks that were no longer needed. > > Chunks in which the 'informix'.TBLSpace resides have been freed up as well, > however the data is spread out and prohibits the deletion of the extra > chunks. > Is there an easy way to reorganize the 'informix'.TBLSpace to compact the > space and allow the deletion of the extra chunks? > > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113c6c76e387b4053808335f