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/ 9  4105 
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.
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/
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).
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/
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
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
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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Filipe Lima |
last post by:
Hello,
I'd like an opinion on the following....
I have a mid sized application that is very critical,
meaning that it can't stop.
This app is built on VB6. It has only one layer. No Data,...
|
by: cat_dog_ass |
last post by:
I am used to programming in DOS mode via Borland C++. I would now like
to create programs for the Windows envirinment. Is it absoultely
necessary to use Visual C++ to do this? Are there other tools...
|
by: Dave |
last post by:
Hi
We need to migratedata for about 300 tables from MS SQL server database to
Linux DB2 V8.1.
Total size of all 300 tables is @ 3 GB.
We have converted tables DDL using IBM migration tool...
|
by: Raquel |
last post by:
We ran Migration toolkit to look into the possibility of migrating
from SYBASE to UDB.
The following statement in SYBASE:
INSERT INTO GEST_TP (
GES_D,
PC_N,
IPD
)
VALUES (
|
by: _link98 |
last post by:
Does IBM publish a complete list of features
(of Oracle) which the IBM migration toolkit
does *not* convert? The docs seem rather vague.
For example:
1. What support for the oracle...
|
by: rob |
last post by:
Dear All,
I have a very small test project to convert asp to asp.net using the
Microsoft/Artisan ASP to ASP.NET Migration Assistant...
|
by: dunleav1 |
last post by:
Is there a db2 tool or utility that will map Oracle structures and
data to DB2?
For instance, Microsoft has a tool called "Microsoft Sql Server
Migration Assistant for Oracle".
The tool basically...
|
by: Christian Welzel |
last post by:
Hi there,
i currently evaluating db2 express-c and therefor i wanted to migrate my
current database from mysql5 to the express-c... i didn't get it working
with mysqldump, and finally found the...
|
by: Tomasz J |
last post by:
Hello developers,
After migrating my web project application (using the old model) to .Net
Framework 3.5 and Ajax Control Toolkit release 20820 the Accordion control
no longer works correctly....
|
by: Rina0 |
last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
|
by: erikbower65 |
last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps:
1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal.
2. Connect to...
|
by: linyimin |
last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
|
by: kcodez |
last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
|
by: Taofi |
last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same
This are my field names
ID, Budgeted, Actual, Status and Differences
...
|
by: DJRhino1175 |
last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this -
If...
|
by: DJRhino |
last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer)
If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _
310030356 Or 310030359 Or 310030362 Or...
|
by: lllomh |
last post by:
How does React native implement an English player?
|
by: Mushico |
last post by:
How to calculate date of retirement from date of birth
| |
