Cannot test connection -- DB2 connector stage

[skathaitrooney]

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:

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

Strange thing is when i pass any random value, lets say abc in the instance field, it gives me the error

Code: Select all

Cannot set the instance value to abc, the active db2 instance is already set to db2cb01 .

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.

[cppwiz]

http://www-01.ibm.com/support/docview.w ... wg21517142