Troubleshooting
Problem
Design-time functionality, such as importing metadata and viewing data, can only be executed against a single DB2 instance.
Symptom
Using more than one DB2 instance from any design client and attempting to exercise design-time functionality gives the following error message:
"An error occurred setting the active DB2 instance to value: <NewInstance>. The active DB2 instance is already set to value: <CurrentInstance>."
This message also appears if the design-time functionality is used with a valid instance after having attempted to use design-time functionality with an invalid or non-existent instance.
Cause
After a DB2 client process makes a connection to a DB2 instance, all operations by that DB2 client process use the same DB2 instance.
Environment
All
Resolving The Problem
To use design-time functionality with a different DB2 instance, you need to perform either of the following actions:
- Restart the ASBAgent service on Microsoft® Windows or the daemon on Unix.
- Enable CAS multiple instance support .
To enable the CAS multiple instance support, you need to perform the following steps:
1) Stop the ASBAgent and also ensure that the ASBAgent process is shut down.
2) Add the following lines to ASBNode/conf/cas.properties. The port number range depends on your
machine environment. Specify the "free" socket port.
multipleprocess.enable=1
multipleprocess.port.range.min=30000
multipleprocess.port.range.max=30010
3) Restart the ASBAgent service.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21615922