Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    14

    Unanswered: db2 redirect restore

    Hi all,
    After i am restoring the database from one system backup into another , i typed the list tablespaces, those are in Restore Pending + Storage May be Defined. How to rectify this problem.

  2. #2
    Join Date
    Jan 2010
    Posts
    207
    Do you have any SQL Error Code?

    I think your tablespaces have to be restored!

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Can you post the script you are using?
    looks like you are not using automatic storage.

    so, the script should look similar to this ..

    restore db sample redirect
    set tablespace containers for 1 using (file 'xxx' 100mb)
    restore db sample continue
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Dec 2010
    Posts
    123
    Quote Originally Posted by nagaraju.bandaru View Post
    Hi all,
    After i am restoring the database from one system backup into another , i typed the list tablespaces, those are in Restore Pending + Storage May be Defined. How to rectify this problem.
    The following link can help you out

    DB2 Basics: Cloning DB2 Databases Using Redirected Restore

Posting Permissions

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