Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2013
    Posts
    19

    Smile Unanswered: manual redirect restore 2nd step

    hi guys

    if a tablespace is automatic storage then is it needed to exegute the 2nd step(SET TABLESPACE CONTAINER FOR TABLESPACE ID)

    this is manual restore not the scripted one

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    no - on pathlist option on restore should be used to redirect automatic storage
    RESTORE DATABASE - IBM DB2 9.7 for Linux, UNIX, and Windows
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Apr 2013
    Posts
    19
    hi

    on (pathlist) should we specify the path or just (on automatic storage)

    Quote Originally Posted by przytula_guy View Post
    no - on pathlist option on restore should be used to redirect automatic storage
    RESTORE DATABASE - IBM DB2 9.7 for Linux, UNIX, and Windows

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    according the doc
    One or more paths can be specified, each separated by a comma. Each path must have an absolute path name and it must exist locally.
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Aug 2008
    Posts
    147
    Have you tried the redirect generate script option of RESTORE DB?

    db2 restore db MYDB from /db2/backups taken at 20091126133630 redirect generate script inv_db.clp
    This creates a redirected restore script on the client called test_node0000.clp.
    Open the redirected restore script in a text editor to make any modifications that are required.
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  6. #6
    Join Date
    Apr 2013
    Posts
    19
    hi jack

    i did restore with script option
    But i want to do manual redirect restore

    Quote Originally Posted by JackVamvas View Post
    Have you tried the redirect generate script option of RESTORE DB?

    db2 restore db MYDB from /db2/backups taken at 20091126133630 redirect generate script inv_db.clp
    This creates a redirected restore script on the client called test_node0000.clp.
    Open the redirected restore script in a text editor to make any modifications that are required.

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by naveen kotla View Post
    hi jack

    i did restore with script option
    But i want to do manual redirect restore
    If all your tablespaces are automatic storage, you just need to redirect where the automatic storage and db path (if different) will be located.

    If you use the "generate script" option, just take the output script, see where the current automatic storage paths and database paths are specified in the restore (may be commented out with --), change them to new location if you want to, and uncomment them, and run the restore script.
    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
  •