I have a strange problem; or perhaps it is a feature? I'm not sure, but it looks as a problem. This is the setup: An HP-UX server with several DB2 instances, all version 8.1. Users need to be able to switch between instances, which they do by setting DB2INSTANCE as well as the PATH and library path; but for some reason this doesn't seem to work quite as expected, especially for two instances, db2i81 and db2i81p. These are the symptoms:
set env for db2i81 and run:
$ db2 get dbm cfg | grep -i svce
TCP/IP Service name (SVCENAME) = db2i81
set env for db2i81p and run:
db2 get dbm cfg | grep -i svce
TCP/IP Service name (SVCENAME) = db2i81
- but if I first set the environment for db2i81p and then for db2i81, SVCENAME will come back as db2i81p. What is happening here?