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

DB2 10 introduces a more management method for tablespaces that manage data storage based on temperature, but requires the database to enable automatic storage management. The specific storage path is in a directory, it takes two steps to convert a table space that is not automatically stored into an automatic storage management method, especially for databases that have been upgraded from a lower version.

Alter database employee add storage on '/data'
In this way, you can recover the tablespace that was originally managed using DMS or SMS. In fact, you need to perform a full backup and then specify redirect restore to restore the tablespace under the original instance:

Restore database csdw from '/db2_backup/db2deer/csdw' taken at 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 database csdw to end of logs and stop;

In this way, the management methods from the NON-automatic storage database to the autostomatic storage database and table space are basically completed. In fact, compared with the original bare devices, this method has the advantage that it supports AUTOMATIC space allocation, pay-as-you-go allocation makes disk space usage more reasonable and effectively avoids waste. In addition, 10.5 of storage groups are more convenient to manage, the BLU columnar STORAGE table only supports the table space managed by the automatic storage method.

DB2 database performance adjustment and optimization (1st and 2) PDF

DB2 database performance optimization

This article permanently updates the link address: