You cannot use ALTER TABLESPACE to change some attributes of your table
space. For example, you must use other methods to change SEGSIZE or the
number of partitions or to convert it to a large table space. The following topics
describe these methods:
There are different ways in which u can increase the space.
traditionla way of:
Remeber the all the tables in the tablespace should also be dropped and recreated
Or the simpler way of using RE-ORG
Changing the space allocation for user-managed data sets
If the table space is supported by user-managed data sets, use this procedure to
change the space allocation:
1. Run the REORG TABLESPACE utility, and specify the UNLOAD PAUSE
2. Make the table space unavailable with the STOP DATABASE command and the
SPACENAM option after the utility completes the unload and stops.
3. Delete and redefine the data sets.
4. Resubmit the utility job with the RESTART(PHASE) parameter specified on the
The job now uses the new data sets when reloading.
Use of the REORG utility to extend data sets causes the newly acquired free space
to be distributed throughout the table space rather than to be clustered at the end.