Page 1 of 1
Importing Table Defintions from a remote DB2 Server
Posted: Wed May 09, 2007 9:30 pm
by cosec
how do I import source and target table definitions from two different servers ?
Posted: Thu May 10, 2007 12:48 am
by ray.wurlod
The import dialogs ask for server name and other authentication information. Just do them one at a time, correctly pointing to the correct server.
You may have additional issues if the servers are, for example, running different versions, but you made no mention that this is the case, so I won't bother to answer unasked questions.
Posted: Thu May 10, 2007 1:04 am
by rafik2k
Create two dsn for the databases in those server.
Go to Import--->ODBC Table Definition
Enter your dsn name, user name and password.
You will get list of table for the database.
Then import what ever table you want.
Posted: Thu May 10, 2007 4:13 am
by cosec
What is the format to enter the name of the server if I use the plug in meta data server option ?
ray.wurlod wrote:The import dialogs ask for server name and other authentication information. Just do them one at a time, correctly pointing to the correct server.
You may have additional issues if the servers are ...
Posted: Thu May 10, 2007 5:06 am
by rafik2k
Do the following step if you want to use plug-in metadata definition:-
Select Plug-in
In your case(for db2) IBM DB2 UDB data acess
Enter Server Name as your db2 Database name, user name,password.
In next step select the table you want to export,select To Category-->then import.
Posted: Thu May 10, 2007 10:35 am
by diamondabhi
If its db2udb you can also use orchestrate schema definitions option to import metadata.