Importing Table Defintions from a remote DB2 Server

cosec · Post by **cosec** » Wed May 09, 2007 9:30 pm

how do I import source and target table definitions from two different servers ?

ray.wurlod · Post by **ray.wurlod** » Thu May 10, 2007 12:48 am

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.

rafik2k · Post by **rafik2k** » Thu May 10, 2007 1:04 am

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.

cosec · Post by **cosec** » Thu May 10, 2007 4:13 am

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

rafik2k · Post by **rafik2k** » Thu May 10, 2007 5:06 am

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.

diamondabhi · Post by **diamondabhi** » Thu May 10, 2007 10:35 am

If its db2udb you can also use orchestrate schema definitions option to import metadata.