Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Posts
    19

    Unanswered: Data Transfer from NT to Sun

    I have a DB2 UDB 8.1 installed on the Windows 2000 Server and I have a DB2 UDB 7.2 installed on Sun Solaris. Instead of doing db2move export, is there any way I can just move data from one table to another using some kind of utility tool or something?

    Please advice ASAP, need to move 26GB of data over ASAP!

    Thx!

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    A DB2 database backup from Windows cannot be restored to any other DB2 platform.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2003
    Posts
    19
    Originally posted by Marcus_A
    A DB2 database backup from Windows cannot be restored to any other DB2 platform.
    Marcus I don't want to do a backup from Restore. But isn't there some kind of tools like PL SQL Developer for Oracle that would allow you to move data from one database on W2000 to Sun Solaris?

    There has to be some kind of utility tool out there!???

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Other than db2move I am not aware of any other tools that come with DB2. If you can set up a federated database environment, you could possilby do an insert select from one database to the other. But the DB2 load utility is much faster if you use unrecoverable load (then take a backup after that).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Sep 2002
    Posts
    456
    db2move OR export --> import/load in ixf format.

    dollar

    Originally posted by Marcus_A
    Other than db2move I am not aware of any other tools that come with DB2. If you can set up a federated database environment, you could possilby do an insert select from one database to the other. But the DB2 load utility is much faster if you use unrecoverable load (then take a backup after that).

  6. #6
    Join Date
    Sep 2003
    Posts
    19
    Thanks Guys! Have you ever tried using DB2MTK?

  7. #7
    Join Date
    Sep 2002
    Posts
    456
    which one? There are a number of them offered by IBM.

    dollar

    Originally posted by sks
    Thanks Guys! Have you ever tried using DB2MTK?

Posting Permissions

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