DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Jinaanoo
Participant



Joined: 21 Jul 2020
Posts: 1

Points: 15

Post Posted: Tue Jul 21, 2020 7:34 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Unix
Additional info: database db2 10.x , databases catalog used to connect to dat
Hi,

I would to ask you If you can help to fix an issue on IBM Infosphere Datastage 11.3

With DB2 Connector Stage we catch the follwing error:


The connection failed.
SQLConnect reported: SQLSTATE = 08004: Native Error Code = -30061:Msg = [IBM][CLI Driver] SQL30061N The database alias or database name "dbname " was not found at the remote node.


[img]


1- the database was catalogued in the Datastage server and I can connect to the remote database which located in other server

2- I have tested the connexion to this database directly using IBM data studio successfully

3- Connection test via DB2 Connector failed as I mentionned above

4- I have tested to connect to other catalogued database without any issue. This is typically a db2 issue If I am not wrong

Did you have any idea or could you route me to support to be helped?

Thanks in advance,

Best regards

_________________
workload or overload
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1294

Points: 8506

Post Posted: Tue Jul 21, 2020 11:19 am Reply with quote    Back to top    

Welcome to DSXchange Jinaanoo, just to be clear, nobody here is your official support team. We HELP however we can.

You should reach out to your local DataStage admin team.
You should reach out to your local DB2 DBA team.
You should reach out to your IBM support if the first two do not work out. Typically that task would be for your DataStage admins to coordinate.

That being said, here is what I would do (Note: I'm a DataStage admin).

I would start by trying your connectivity test from the Unix command line. Use the installed db2 client and try that connection (from unix DataStage host).
I see that you are using a SERVER job, please make sure of that since a Parallel job "might" have been dispatched to a different host if your APT file told it to.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours