DB2-DB2 migration toolkit

[Troels Arvin]

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 <troels@arvin.d k>

http://troels.arvin.dk/

[Ian]

Re: DB2-DB2 migration toolkit

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.

[Troels Arvin]

Re: DB2-DB2 migration toolkit

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 <troels@arvin.d k>

http://troels.arvin.dk/

[Ian]

Re: DB2-DB2 migration toolkit

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

[Troels Arvin]

Re: DB2-DB2 migration toolkit

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 <troels@arvin.d k>

http://troels.arvin.dk/

[Knut Stolze]

Re: DB2-DB2 migration toolkit

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 mtk@us.ibm.com?

>

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

[Troels Arvin]

Re: DB2-DB2 migration toolkit

On Tue, 24 Apr 2007 21:02:39 +0200, Knut Stolze wrote:

Have you send your suggestion to mtk@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 <troels@arvin.d k>

http://troels.arvin.dk/

[Serge Rielau]

Re: DB2-DB2 migration toolkit

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

[mtkwatch@gmail.com]

Re: DB2-DB2 migration toolkit

On Apr 24, 5:53 am, Troels Arvin <tro...@arvin.d kwrote:

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(surprisi ngly) 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.d k>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/developerworks/db2/library/techarticle/0206sqlref/0206sqlref.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.

[Knut Stolze]

Re: DB2-DB2 migration toolkit

Troels Arvin wrote:

On Tue, 24 Apr 2007 21:02:39 +0200, Knut Stolze wrote:

>Have you send your suggestion to mtk@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