IBM Datastage / db2 connection Issue
Posted: Tue Jul 21, 2020 7:34 am
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
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