Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005

    Unanswered: Automatic Storage

    DB2 v8.2 FixPack 15

    The system in question does not use the Automatic Storage System. I understand that the Automatic Storage System must be specified during initial database creation.

    Can I drop the database, recreate it with Automatic Storage System enabled, then restore a backup in to it?

    Or, will the restored database still be without the Automatic Storage System in place?

  2. #2
    Join Date
    Aug 2002
    Im pretty sure you are limited here to using db2look/db2move to get the data out of the one without auto storage into a db with auto storage

    it doesnt mention your exact scenario in documentation but its pretty explicit that once a database has been created the automatic storage setting cannot be changed in any way.

    Restoring the way you mention would just overlay this type of attribute for the database because the restore basically erases the new database you created and replaces it with the one from the backup image.

    There are redirect scenarios for changing the auto storage but no scenarios on the redirected restore for adding auto storage to a db that previously did not have it.

  3. #3
    Join Date
    May 2003
    I believe that the restored database will have the same characteristics with regard to automatic storage as the backup. If the backup has automatic storage, you can specify the automatic storage paths on the restore, but you cannot do a normal redirected restore where you specify where each tablespace goes.
    Last edited by Marcus_A; 08-12-08 at 15:29.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts