Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    84

    Unanswered: Backup and restore the whold DB

    Dear All,

    After backup the whole DB2 database, can I restore it
    in another machine? We have this "Database image does
    not match" error message".

    Can this be done? If yes, is there anything I need to set?

    Thanks.

  2. #2
    Join Date
    Oct 2002
    Location
    chennai
    Posts
    30

    Re: Backup and restore the whold DB

    Hi,

    yes that can be done. Use the restore command:

    restore database <backup db alias> user <username> using <passwd> from < dir of backup> taken at <timestamp> into <newdbalias>

    For further information on restore command check "Data Recovery and High Availability Guide and Reference"

    Here´s the link for the DB2 UDB Manuals at the IBM site:
    http://www-3.ibm.com/cgi-bin/db2www...ubs.d2w/en_main

    If any help needed mail me to k_sekhar_rao@rediffmail.com



    Originally posted by qxz
    Dear All,

    After backup the whole DB2 database, can I restore it
    in another machine? We have this "Database image does
    not match" error message".

    Can this be done? If yes, is there anything I need to set?

    Thanks.
    Thanks,
    sekhar rao k

Posting Permissions

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