Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    24

    Unanswered: Creating a new database with the existing database with same structure

    Hi DBA Guru's,

    Iam using DB2 V8.1 fixpack 4 and solaris. Alloted space for the database is 100% full for the existing database and now i have to create a new database with the same structure in different place on the same box.Can anybody tell me the exact process so that i can create a new database with the same structure and data.

    Thanks in advance
    Nandra

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    restore

    take an offline backup
    restore database with redirect as parameter
    change all container paths
    restore continue
    see information center and restore command for all parameters
    this should help
    Best Regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Sep 2004
    Posts
    24
    Quote Originally Posted by przytula
    take an offline backup
    restore database with redirect as parameter
    change all container paths
    restore continue
    see information center and restore command for all parameters
    this should help
    Best Regards, Guy Przytula
    Thanks very much.........

Posting Permissions

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