Rebalancing automatic storage when restoring a database

During a RESTORE operation, a database image that is configured for automatic storage rebalances the containers of automatic storage table spaces across the defined storage paths. The rebalancing is determined by the extent of post-backup changes to the file system, available free space, and the automatic storage paths.

Rebalancing automatic storage when restoring an existing database

When running a RESTORE operation against an existing database backup:
  • If 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.
  • If there are changes to the free space or file system configuration, Db2® rebalances across the automatic storage paths.
  • If changes to the automatic storage paths defined for a database are made after the backup image is taken, Db2 uses the additional paths defined for the database, even though they are not in the backup image.
    Note: Dropping the database before running the RESTORE operation prevents Db2 from using any new paths that are not defined in the backup image.

Rebalancing automatic storage when restoring a previously dropped database

When running a RESTORE operation against a backup image of a previously dropped database, the data is redistributed across the storage paths that are defined in the backup image.