Altering table spaces and dropping table spaces
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.
Getting ready
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.
How to do it…
To obtain useful information on table spaces and containers, you can use the following commands:
Connect to database:
[db2inst1...
