By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,636 Members | 1,941 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,636 IT Pros & Developers. It's quick & easy.

DB2-DB2 migration toolkit

P: n/a
At work, some people have found IBM's Migration Toolkit (MTK) to be a
nice tool for copying data from one table (in another DBMS product) to
DB2.

Now, they want to do the same thing from one DB2 database to another DB2
database. - But MTK (surprisingly) doesn't seem to support DB2-DB2 copies.

These are non-regular, ad-hoc tasks, performed by users without
administrative rights (and generally somewhat annoyed by command line
operations).

Which tool should I suggest instead of MTK?

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Apr 24 '07 #1
Share this Question
Share on Google+
9 Replies


P: n/a
Ian
Troels Arvin wrote:
Now, they want to do the same thing from one DB2 database to another DB2
database. - But MTK (surprisingly) doesn't seem to support DB2-DB2 copies.

Which tool should I suggest instead of MTK?
Use the EXPORT and LOAD (or IMPORT) utilities.
Apr 24 '07 #2

P: n/a
On Tue, 24 Apr 2007 09:33:21 -0700, Ian wrote:
>Now, they want to do the same thing from one DB2 database to another
DB2 database. - But MTK (surprisingly) doesn't seem to support DB2-DB2
copies.

Which tool should I suggest instead of MTK?

Use the EXPORT and LOAD (or IMPORT) utilities.
The nice thing about MTK is that there are no files involved: You set up
two database connections, and "pump" data from one to the other. That's
the kind of functionality that I'm looking for, but with DB2->DB2.

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Apr 24 '07 #3

P: n/a
Ian
Troels Arvin wrote:
>
The nice thing about MTK is that there are no files involved: You set up
two database connections, and "pump" data from one to the other. That's
the kind of functionality that I'm looking for, but with DB2->DB2.
If you're using DB2 9, db2move has a new option to do just this (see the
'-co' option).


Apr 24 '07 #4

P: n/a
On Tue, 24 Apr 2007 11:02:02 -0700, Ian wrote:
>The nice thing about MTK is that there are no files involved: You set
up two database connections, and "pump" data from one to the other.
That's the kind of functionality that I'm looking for, but with
DB2->DB2.
If you're using DB2 9, db2move has a new option to do just this (see the
'-co' option).
The users _really_ like MTK's GUI (and some of them aren't that happy
about the command line). And we're not using DB2 v. 9 yet.

So: I'm still very open for suggestions.

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Apr 24 '07 #5

P: n/a
Troels Arvin wrote:
On Tue, 24 Apr 2007 11:02:02 -0700, Ian wrote:
>>The nice thing about MTK is that there are no files involved: You set
up two database connections, and "pump" data from one to the other.
That's the kind of functionality that I'm looking for, but with
DB2->DB2.
If you're using DB2 9, db2move has a new option to do just this (see the
'-co' option).

The users _really_ like MTK's GUI (and some of them aren't that happy
about the command line). And we're not using DB2 v. 9 yet.

So: I'm still very open for suggestions.
Have you send your suggestion to mt*@us.ibm.com?
>
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Apr 24 '07 #6

P: n/a
On Tue, 24 Apr 2007 21:02:39 +0200, Knut Stolze wrote:
Have you send your suggestion to mt*@us.ibm.com?
Good idea. I just sent the suggestion to
news://news.software.ibm.com/ibm.software.db2.udb
with a "migrate-team" subject prefix, as described at http://
www-306.ibm.com/software/data/db2/migration/mtk/

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Apr 24 '07 #7

P: n/a
Ian wrote:
Troels Arvin wrote:
>>
The nice thing about MTK is that there are no files involved: You set
up two database connections, and "pump" data from one to the other.
That's the kind of functionality that I'm looking for, but with DB2->DB2.

If you're using DB2 9, db2move has a new option to do just this (see the
'-co' option).
Also in DB2 9 you can perform LOAD from a remote database.
In DB2 V8.2 you can create a nickname (using federated) and do "LOAD
from cursor"

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 24 '07 #8

P: n/a
On Apr 24, 5:53 am, Troels Arvin <tro...@arvin.dkwrote:
At work, some people have found IBM's Migration Toolkit (MTK) to be a
nice tool for copying data from one table (in another DBMS product) toDB2.

Now, they want to do the same thing from oneDB2database to anotherDB2
database. - ButMTK(surprisingly) doesn't seem to supportDB2-DB2copies.

These are non-regular, ad-hoc tasks, performed by users without
administrative rights (and generally somewhat annoyed by command line
operations).

Which tool should I suggest instead ofMTK?

--
Regards,
Troels Arvin <tro...@arvin.dk>http://troels.arvin.dk/
The IBM Migration Toolkit is a tool to migrate from Sybase, Microsoft
SQL Server or Oracle databases to DB2 or Informix. Migration from DB2
to DB2 is an issue not addressed by the Migration Toolkit. Therefore,
the Migration Toolkit team cannot provide you assistance with the
situation you are facing. I suggest you consider the following options
to get proper help:

Look at this redbook which discusses moving data across the DB2
family: http://www.redbooks.ibm.com/abstracts/sg246905.html
Look at this redbook that highlights differences between DB2 systems :
http://www-106.ibm.com/developerwork...206sqlref.html
Find help on the DB2 support website at http://www.ibm.com/db2/udb/support.html
Contact your IBM representative and ask for support.

Apr 24 '07 #9

P: n/a
Troels Arvin wrote:
On Tue, 24 Apr 2007 21:02:39 +0200, Knut Stolze wrote:
>Have you send your suggestion to mt*@us.ibm.com?

Good idea. I just sent the suggestion to
news://news.software.ibm.com/ibm.software.db2.udb
That's just another newsgroup. I would recommend that you send an email.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Apr 25 '07 #10

This discussion thread is closed

Replies have been disabled for this discussion.