Troubleshooting
Problem
If the DB2 Connector stage was created originally with a particular DB2 instance name (eg. TestA) and then one goes back into the DB2 Connector to change the DB2 Instance name to a different Instance name (eg. TestB), and test the connection, the following error will occur: The connection failed. An error occurred setting the active DB2 instance to value: TestB. The active DB2 instance is already set to value: TestA.
Resolving The Problem
Follow these steps to resolve the issue:
- Ensure that DB2INSTANCE is set correctly in the dsenv file (located under the DSEngine directory)
- Restart Datastage/ASBAgents to pick up this new value
- In the DB2 Connector stage, leave the Instance field blank (i.e., let it default to the DB2INSTANCE that is in the dsenv file). However, if the test connection fails, insert the corrected value for the DB2INSTANCE to match what is in the dsenv file
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"}],"Version":"8.7;8.5;8.1;8.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21517142