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

MKT Tool : how to specify Remote DB2 database

P: n/a
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

Feb 5 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Feb 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.