Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Question Unanswered: Copy of DB from Windows to AIX

    Hi all,

    I have a database running on the Windows version of DB2 UDB 8.1. I'd like to transfer it all to an AIX 5.3 server running also DB2 UDB 8.1. I already tried backup/restore but it doesn't work, saying it's not possible to restore a DB on a different platform than where it was backed up.

    What's the method to do such a thing? Is there a way to dump the DB structure and content of all the tables and reload it on the other system? I checked EXPORT and LOAD but it seems it's only for 1 or several linked tables.

    Many thanks,
    Gilles

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You'll need to use db2move utility. It's described in the command reference. Also search this discussion - I remember there were links to additional documentation.

Posting Permissions

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