DB2 10.5 for Linux, UNIX, and Windows

Rebalancing during RESTORE of automatic storage database

Database with automatic storage have the containers residing on the automatic storage paths redefined during a restore operation.

The conditions for redefinition of automatic storage paths are as follows:
  1. Restore of existing database
    1. When there are no changes in the file system configurations or free space, and there are no automatic storage path changes for the database since the backup, the containers remain the same as they were when the backup was taken.
    2. When there are changes to the free space or file system configuration, DB2® redistributes the containers and data across the automatic storage paths.
    3. When there are changes to the automatic storage paths defined for the database since the backup image was taken, DB2 uses the additional paths that are currently defined to the database even though they were not in the backup image. To prevent DB2 from using the additional paths, dropping the database before the restore prevent DB2 from using any new paths not in the backup image.
  2. Restore of a new or previously dropped database
    1. The data is redistributed across the storage paths that were defined in the backup image.