Page 1 of 1
unable to connect to DB2DS metadata
Posted: Fri Sep 18, 2009 4:41 pm
by ketfos
Hi,
I am trying to connect to database on Db2 Unix
Go to IMPORT --> TABLE DEFINITIONS --> PLUG IN META DEFINITIONS --> SELECT DSDB@ plugin --->ok
In the import DbDb2 meta data Repository window, I select Serer name, and enter user id and password. After I click ok, I get the error message
"Unable to obtain list of available DB2 servers"
I would appreciate any help to resovle the error message.
Thanks
Ketfos
Posted: Fri Sep 18, 2009 5:44 pm
by chulett
Tell us, have you been able to do this in the past and it no longer works or is this your first try? Can you use the DB2 stages in jobs without issue?
Posted: Fri Sep 25, 2009 7:02 pm
by ketfos
This is is the first time we are using UDB
I can select the DB2API stage from the palete and add to the job.
ketfos
Posted: Sat Sep 26, 2009 4:23 pm
by ray.wurlod
Try typing in the name of the DB2 server. It may be that the drop-down list contains only those server names that you have already used.
Posted: Sun Sep 27, 2009 12:44 pm
by ketfos
Hi,
The Db2 database name is db2pcp.
It is on the Unix server uldpcp.
When I do the following
Go to IMPORT --> TABLE DEFINITIONS --> PLUG IN META DEFINITIONS --> SELECT DSDB@ plugin --->ok
In the import DbDb2 meta data Repository window,
There is a dropdown list box , should I enter the name of the Unix server or db2 database name.
Can you please let me know?
Thanks
Ketfos
Posted: Sun Sep 27, 2009 12:55 pm
by ketfos
Hi Ray,
I manually entered the name of the DB2 Database name in the Server name field, followed by user name and password the Db2 database.
It still gives the same error message after I click Next Button
Unable to obtain list of available DB2 servers"
Thanks
ketfos
Posted: Sun Sep 27, 2009 9:59 pm
by lstsaur
Did you do the catalog tcp, catalog db, and bind at all?
Posted: Sun Sep 27, 2009 11:51 pm
by ketfos
Hi,
I can connect to the database through my Unix server on which datastage is installed.
The problem comes when I try to connect through datastage.
The dba cataloged the database.
What is command for catalog tcp and bind?
Thanks
ketfos
Posted: Mon Sep 28, 2009 11:48 am
by lstsaur
Something like the following:
catalog tcpip node gateway1 remote 10.1.123.45 server 50000
catalog db urdb at node gateway1 authentication server
Then, you also need to bind your package.
Posted: Mon Sep 28, 2009 12:00 pm
by ketfos
What is the command to bind?
Once again appreciate you help.
Ketfos
Posted: Mon Sep 28, 2009 1:40 pm
by lstsaur
Just do a DB2 bind packages on Google.