Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003

    Unanswered: Moving a database

    Is there a way to extract the data from a DB2 database and load it into another instance on another platform?

    The three UNIX platforms we currently support are IBM AIX, HP-UX, and SUN Solaris. I have been reviewing the Data Movement Utilities Guide and Reference for version 8 but don't seem to find what I am looking for. It appears that the export utility was designed for unloading individual tables. From what I have read the db2move utility is the closest thing I have found but it only backs up the user tables and does not include any functions or triggers we may be using. I understand that sometimes a backup of the database can be transferred to another platform if that platform utilizes the same memory page size such as HP-UX and Sun Solaris. However I need to be able to move data between all three platforms.

    I am attempting to put an image of the database on a CD that can be loaded into a fresh instance across all three platforms. In other words something similar to the Oracle exp utility. Does anyone have any suggestions that may accommodate my situation? Maybe another utility I have yet to come across? Any assistance you could provide would be greatly appreciated.

  2. #2
    Join Date
    Aug 2001

    Re: Moving a database

    Have a look at the following link



  3. #3
    Join Date
    Oct 2003

    Thumbs up

    Have a look at the another link
    - the formal link from IBM.DB2, this extends sathyaram_s's content.

    Last edited by nvtan; 12-31-03 at 03:36.

Posting Permissions

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