Use a database automatically stored in DB2 for redirection and restoration (1)

This article will explain how to use DB2®For more information about how to restore a database with the automatic storage function of V9, see auto storage for your reference.

IBM DB2 V9 introduces automatic storage management. The automatic storage function helps you simplify the Storage Management of tablespaces and create new tablespaces that use the automatic storage function, the container and space allocation are completely determined by the DB2 database manager. This article focuses on using DB2®V9 automatic storage function of the database how to restore non-incremental redirection.

Introduction

The database may be unavailable due to software or hardware faults, and may encounter various faults that require different recovery measures, such as storage problems, power outages, application faults, or misoperations. This article focuses on the use of DB2®The automatic storage function of V9 does not allow redirection and restoration of Incremental Backup databases. Because the restoration of databases using the automatic storage function is very different from that in the past, customers are prone to various problems in actual use, therefore, this article will elaborate on the automatic storage function in detail.

The Automatic Storage Feature was initially introduced in DB2 V8.2.2. DB2 V9 extends this feature and uses the automatic storage feature to help you simplify the Storage Management of tablespaces, the container and space allocation of the newly created tablespace that uses the automatic storage function are completely determined by the DB2 database manager.

Automatic Storage Management

Automatic Memory automatically increases the database size across disks and file systems. Therefore, you no longer need to manage memory containers while maintaining the performance and flexibility of the memory managed by the database. In DB2 V9.1, automatic storage support has been added for multi-partition databases. If you are using an Enterprise Server with DPF (Data Partitioning Feature, database Partitioning function), you can use a multi-partition database that supports the automatic storage function. When creating a database in DB2 V9, the automatic storage function is enabled by default to simplify the Storage Management of tablespaces, the database that uses the automatic storage function has one or more associated storage paths. When creating a tablespace, you do not need to specify the storage path or other features. For databases that use the automatic storage function, you can use automatic storage management for their tablespace, or do not use automatic storage management. For databases that do not use the automatic storage function, the tablespace cannot use automatic storage management.

Automatic Storage simplifies storage management, allowing you to specify the storage path used by the database manager to store tablespace data and allocate space for various purposes. In addition, DB2 manages the container and space allocation of these tablespaces when creating and filling tablespaces. If you do not need automatic storage, you must run the create database Command and set the automatic storage option to NO, or use the sqlecrea API and set the SQLEDBDESCEXT parameter to SQL _AUTOMATIC_STORAGE_NO to CREATE a DATABASE.