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.