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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.