Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Location
    Bangalore, India
    Posts
    35

    Unanswered: Restore Partitions in Parallel

    hi,

    We are on DB2 V9.1

    We took offline backup of a database which has 8 data partitions and 1 catalog partition. The backup of catalog partition was taken first and data partitions were backed up together/in-parallel after the catalog partition. The data partitions have the same backup timestamp.

    Is it possible to restore all the data partitions in parallel after restore of catalog partition is complete?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I am not sure about 9.1, but on 9.7 I issue this command after restoring to the catalog node:

    db2_all "db2 restore database sample from /stage/db2inst1/backup/SAMPLE taken at 20091012201205 without prompting"

    Then:

    db2 "rollforward db sample to 2009-10-12-20.12.10.000000 on all dbpartitionnums and stop"

    This assumes that the backup path is /stage/db2inst1/backup/SAMPLE and it exists on all physical servers (in case you have more than one). If you are storing the backups under a "NODEnnnn" directory, then there is another thread about how to wild card that in the restore command.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2009
    Posts
    114
    Quote Originally Posted by divakargoel View Post
    Is it possible to restore all the data partitions in parallel after restore of catalog partition is complete?
    Yes ________

Posting Permissions

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