Data Transfer from NT to Sun

sks · #1 (**permalink**) 01-31-04, 15:46

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!

Marcus_A · #2 (**permalink**) 01-31-04, 15:55

A DB2 database backup from Windows cannot be restored to any other DB2 platform.

sks · #3 (**permalink**) 01-31-04, 15:59

Quote:

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!???

Marcus_A · #4 (**permalink**) 01-31-04, 16:02

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).

dollar489 · #5 (**permalink**) 01-31-04, 16:18

db2move OR export --> import/load in ixf format.

dollar

Quote:

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).