unable to connect to DB2DS metadata

ketfos · Post by **ketfos** » Fri Sep 18, 2009 4:41 pm

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

chulett · Post by **chulett** » Fri Sep 18, 2009 5:44 pm

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?

ketfos · Post by **ketfos** » Fri Sep 25, 2009 7:02 pm

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

ray.wurlod · Post by **ray.wurlod** » Sat Sep 26, 2009 4:23 pm

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.

ketfos · Post by **ketfos** » Sun Sep 27, 2009 12:44 pm

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

ketfos · Post by **ketfos** » Sun Sep 27, 2009 12:55 pm

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

lstsaur · Post by **lstsaur** » Sun Sep 27, 2009 9:59 pm

Did you do the catalog tcp, catalog db, and bind at all?

ketfos · Post by **ketfos** » Sun Sep 27, 2009 11:51 pm

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

lstsaur · Post by **lstsaur** » Mon Sep 28, 2009 11:48 am

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.

ketfos · Post by **ketfos** » Mon Sep 28, 2009 12:00 pm

What is the command to bind?

Once again appreciate you help.

Ketfos

lstsaur · Post by **lstsaur** » Mon Sep 28, 2009 1:40 pm

Just do a DB2 bind packages on Google.