Importing Table Definitions from a remote source/target

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
cosec
Premium Member
Premium Member
Posts: 230
Joined: Tue May 08, 2007 8:10 pm

Importing Table Definitions from a remote source/target

Post by cosec »

Hi,

First case:

I have been trying to import the table definitions of a source database and I am not able to connect to the database.
I use the " plug in meta - deta" option

I get an error saying "unable to connect to server - XXXX"

second case:
I am able to connect to tthe target but I get an error saying unable to retrieve table list..is it because there are no tables in the target as yet ?


It would be great if someone can give me some insight in to solving this issue
rafik2k
Participant
Posts: 182
Joined: Wed Nov 23, 2005 1:36 am
Location: Sydney

Post by rafik2k »

Same post in both Server and Parallel index?

check this viewtopic.php?t=109785

What database you are trying to connect?
cosec
Premium Member
Premium Member
Posts: 230
Joined: Tue May 08, 2007 8:10 pm

Post by cosec »

Trying to connect to a DB2 Source. The Target is also DB2
rafik2k wrote:Same post in both Server and Parallel index?

check this viewtopic.php?t=109785

What database you are trying to connect?
cosec
Premium Member
Premium Member
Posts: 230
Joined: Tue May 08, 2007 8:10 pm

Post by cosec »

hi Rafik thanks.

Its a db2 database. how do i create the dsn ?
rafik2k wrote:Same post in both Server and Parallel index?

check this viewtopic.php?t=109785

What database you are trying to connect?
rafik2k
Participant
Posts: 182
Joined: Wed Nov 23, 2005 1:36 am
Location: Sydney

Post by rafik2k »

Better involve DBA to create dsn for you.
You need to create dsn in server where DatStage resides.

For windows environment you can create system dsn using Data Sources(ODBC) under control panel.

Search web for more information.
cosec
Premium Member
Premium Member
Posts: 230
Joined: Tue May 08, 2007 8:10 pm

Post by cosec »

Thanks
rafik2k wrote:Better involve DBA to create dsn for you.
You need to create dsn in server where DatStage resides.

For windows environment you can create system dsn using Data Sources(ODBC) under control panel.

Search web for more information.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Check also that the DB2 instance has been started. You can also get "failed to connect" errors if it has not been started.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply