
IBM DB2 9.7 Advanced Administration Cookbook

Altering a table space allows you to modify storage characteristics of a table space in the following ways:
Container management
Size management
Physical characteristics
Performance characteristics
Automatic storage table spaces have different sets of requirements and possibilities than manual storage table spaces. Please refer to the documentation for more details.
When dropping a table space, evaluate the impact on underlying objects and, ideally, arrange to be able to recover with a table space backup or with import/load utilities.
When altering a table space, obtain as much information as possible to evaluate the space or performance impact, if possible. This could be the filesystem sizes, the current space allocation for containers, or anything related to the characteristics you want to change.
To obtain useful information on table spaces and containers, you can use the following commands:
Connect to database:
[db2inst1...
Change the font size
Change margin width
Change background colour