Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Question Unanswered: Copy database to another Box.

    I want to move/copy a database from one computer to the other computer by using backup dump file.
    In CC, there is a wizard for create database from backup. But it won't do when backup dump is taken in other computer. (some security setting in DB2?)
    What is the best way to accomplish this task?
    DB2move? Or brake theis DB2 security?
    I have log retain and archive on this database to be moved.

    I am testing this task in order to prepare for the total hardware crash.
    Please let me know which methods you use!!

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Copy database to another Box.

    This issue has been discussed umpteen times in the forum .. So, please search the forum ... The latest discussion on the topic is in

    http://www.dbforums.com/t959119.html

    Also, you have failed to mention the version of db2 and which OS it is on ... Please read 'Must Read Before Posting' Thread

    Cheers
    Sathyaram



    Originally posted by didi
    I want to move/copy a database from one computer to the other computer by using backup dump file.
    In CC, there is a wizard for create database from backup. But it won't do when backup dump is taken in other computer. (some security setting in DB2?)
    What is the best way to accomplish this task?
    DB2move? Or brake theis DB2 security?
    I have log retain and archive on this database to be moved.

    I am testing this task in order to prepare for the total hardware crash.
    Please let me know which methods you use!!
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Oct 2003
    Posts
    8

    Re: Copy database to another Box.

    If its DB2 UDB,

    you can three ways

    one from control center create DB from Backup

    2nd redirect restore process
    for more details refere below link
    ftp://ftp.software.ibm.com/ps/produc...r/db2hae80.pdf



    3rd db2relocatedb command ( db2 udb 7.2 fix pack 4 on wards)
    refere command reference manuaval


    library url

    http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

    Let me know if any questions


    Raju Ennam

Posting Permissions

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