Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Posts
    13

    Smile Unanswered: DB2 clone or restore

    I'm interested in building a test DB2 database from the production database in its entirety. What would be the easiest way of approaching this?

    Clone? Restore?

    Samples please.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Backup the production database, then do a redirected restore.

    Andy

  3. #3
    Join Date
    Jul 2010
    Posts
    13

    Redirected retsore

    Thank you!

    I'm not a DBA, but every place I've worked, they build their test system via a production DB2 backup. Currently, our DBA builds all 700+ one at a time. This process takes a full day and a half with numerous issues.

    Do you happen to have quick example of a redirected restore?

    Thanks again!

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    There are examples in the online manual.

    Andy

Posting Permissions

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