MKT Tool : how to specify Remote DB2 database

[rjha94]

Hi folks
I am pretty new to DB2. I am trying to use MKT tool to copy one
oracle [ schema + data ] to a target DB2 database. I import the
oracle DDL sql scripts and everything goes fine till the final tab
(deploy).

Here, I am running the MKT tool on a windows machine and my DB2 is a
remote database running on linux box.

question 1) I see the remote option on deploy tab but where do a
specify the remote machine IP and other connection info? How would the
MKT tool know how to connect to a remote DB2 database otherwise?

question2) in my oracle DDL sql we just have table/object names ( and
not schema.object everywhere). Do i have to create the same schema in
DB2 database also? would it not take the default schema name?

Thanks

- Rajeev

[Serge Rielau]

rjha94 wrote:

Hi folks
I am pretty new to DB2. I am trying to use MKT tool to copy one
oracle [ schema + data ] to a target DB2 database. I import the
oracle DDL sql scripts and everything goes fine till the final tab
(deploy).

Here, I am running the MKT tool on a windows machine and my DB2 is a
remote database running on linux box.

question 1) I see the remote option on deploy tab but where do a
specify the remote machine IP and other connection info? How would the
MKT tool know how to connect to a remote DB2 database otherwise?

question2) in my oracle DDL sql we just have table/object names ( and
not schema.object everywhere). Do i have to create the same schema in
DB2 database also? would it not take the default schema name?

I'm not sure if you'll have much luck with MTK questions in this group.
Have you sent a note to mt*@us.ibm.com?
Also I imagine that the gang in the DB2 Express C forum will be more
likely to know this stuff (and that forum is moderated).
http://www.ibm.com/developerworks/fo...rum=805&cat=19

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab