Personal tools
You are here: Home → DB2 → DB2 UDB v9 → DB2 9.7 → How to convert table spaces to use automatic storage on DB2 9.7
Navigation
Log in


Forgot your password?
 
Document Actions

How to convert table spaces to use automatic storage on DB2 9.7

ALTER TABLESPACE <TBSNAME> MANAGED BY AUTOMATIC STORAGE

Enabling automatic storage for database managed table space TBS1

 

db2 "ALTER TABLESPACE TBS1 MANAGED BY AUTOMATIC STORAGE"

 

An ALTER DATABASE statement removed the paths /db2/filesystem1 and /db2/filesystem2 from the currently connected database. The table space named TBS1 was the only table space using the removed paths. Rebalance this table space. The ALTER TABLESPACE statement below must be performed.

 

db2 "ALTER TABLESPACE TBS1 REBALANCE"

 

 

If you do not specify the REBALANCE option now and issue the ALTER TABLESPACE statement later with the REDUCE option, your automatic storage containers will be removed. To recover from this problem, issue the ALTER TABLESPACE statement, specifying the REBALANCE option.
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls