To alter a dbspace, right-click a dbspace and choose Properties, Usage. If you have DBA privileges, you can change the size and/or mode of the dbspace.
To change the size, type a new size (in MB) in the Size text box. The size to which a dbspace can grow depends on the reserve size set when the database was created. Once set, the reserve size cannot be changed. For more information, see “Setting Database Page Size Values”.
To change the mode, choose a mode from the Mode submenu. Modes are:
Read Write — Default for new dbspaces, writes to the dbspace are allowed
Read Only — Transactions active at the time of the status change may write to the dbspace, but future ones cannot.
Relocate — Space will not be allocated from the dbspace and objects on the dbspace may be relocated. Relocating moves all data on main or local dbspaces with Relocate status to main dbspaces with Read Write status.
Open the DBspaces container.
Right-click IQ_SYSTEM_MAIN and choose Properties.
Click the Usage tab and select Relocate from the Mode submenu. Click OK.
Right-click the desired table or index and choose Relocate from the Mode submenu.
Relocating
a dbspace