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
-
ketfos
- Participant
- Posts: 562
- Joined: Mon May 03, 2004 8:58 pm
- Location: san francisco
-
Contact:
Post
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
ketfos
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
ketfos
- Participant
- Posts: 562
- Joined: Mon May 03, 2004 8:58 pm
- Location: san francisco
-
Contact:
Post
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
ketfos
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
ketfos
- Participant
- Posts: 562
- Joined: Mon May 03, 2004 8:58 pm
- Location: san francisco
-
Contact:
Post
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
ketfos
-
ketfos
- Participant
- Posts: 562
- Joined: Mon May 03, 2004 8:58 pm
- Location: san francisco
-
Contact:
Post
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
ketfos
-
lstsaur
- Participant
- Posts: 1139
- Joined: Thu Oct 21, 2004 9:59 pm
Post
by lstsaur »
Did you do the catalog tcp, catalog db, and bind at all?
-
ketfos
- Participant
- Posts: 562
- Joined: Mon May 03, 2004 8:58 pm
- Location: san francisco
-
Contact:
Post
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
ketfos
-
lstsaur
- Participant
- Posts: 1139
- Joined: Thu Oct 21, 2004 9:59 pm
Post
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.
-
ketfos
- Participant
- Posts: 562
- Joined: Mon May 03, 2004 8:58 pm
- Location: san francisco
-
Contact:
Post
by ketfos »
What is the command to bind?
Once again appreciate you help.
Ketfos
ketfos
-
lstsaur
- Participant
- Posts: 1139
- Joined: Thu Oct 21, 2004 9:59 pm
Post
by lstsaur »
Just do a DB2 bind packages on Google.