Cannot test connection -- DB2 connector stage
Posted: Tue Aug 18, 2015 5:25 am
Hi Everyone,
I am facing a weird issue with DB2 conenctor stage.
I have just specified the Database, username and password fields and left the instance as blank. When i try to test connection or view data i get an error message:
Strange thing is when i pass any random value, lets say abc in the instance field, it gives me the error
Note db2cb01 is the hostname for this database.
Also, i am able to connect to the database from command line and the db2instance variable is also set to a proper value in the dsenv file.
The jobs are running successfully, only problem is that while test connection i am facing this issue.
I am facing a weird issue with DB2 conenctor stage.
I have just specified the Database, username and password fields and left the instance as blank. When i try to test connection or view data i get an error message:
Code: Select all
An error occured while getting the db2 instance.Verify that a valid db2 instance is specified in the instance property. The method sqlegins returned reason code 0, sqlcode -1390
Code: Select all
Cannot set the instance value to abc, the active db2 instance is already set to db2cb01 .
Also, i am able to connect to the database from command line and the db2instance variable is also set to a proper value in the dsenv file.
The jobs are running successfully, only problem is that while test connection i am facing this issue.