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

    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
    Location
    UK
    Posts
    4,650

    Re: Moving a database

    Have a look at the following link

    http://www.tek-tips.com/faqs.cfm?spid=178&sfid=2767

    Cheers

    Sathyaram

  3. #3
    Join Date
    Oct 2003
    Posts
    2

    Thumbs up

    Have a look at the another link
    http://www-106.ibm.com/developerwork...0207kline.html
    - the formal link from IBM.DB2, this extends sathyaram_s's content.

    Sincerely
    nvtan
    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
  •