How to convert non-automatic storage to automatic storage space management in DB2

DB2 10 introduces a more manageable way of managing the tablespace based on the temperature management data, but requires the database to enable automatic storage management, where the storage path is in a directory, and it takes two steps to convert a non-automatically stored tablespace into an automated storage management method, especially one that is upgraded from a lower version.

ALTER DATABASE EMPLOYEE ADD STORAGE on '/data '

This is possible, but for a table space that was originally managed using DMS or SMS, it is necessary to do a full backup first, then specify redirect restore to recover from the original instance:

RESTORE DATABASE csdw from '/db2_backup/db2deer/csdw ' taken to 20140522232227 into Csdw REDIRECT; SET tablespace CONTAINERS for 2 USING AUTOMATIC STORAGE;.. SET tablespace CONTAINERS for 94 USING AUTOMATIC STORAGE; RESTORE DATABASE Csdw CONTINUE; Rollforward Databasedatabase_nameto END of LOGS and STOP;

This basically completed from the non AUTOMATIC STORAGE database to autostomatic STORAGE database and table space management way, in fact, compared to the original bare device, this way has a benefit is to support automatic allocation of space, on demand, The use of disk space is more reasonable, effectively avoid waste, another 10.5 storage group way to manage more convenient, Blu's Columnstore table is only supported automatic storage way to manage the table space.

This article is from the "Marvelyu's Notes" blog, so be sure to keep this source http://marvelyu.blog.51cto.com/471030/1416457