same database name on 2 instances in same server, which db to connect ?

[d***@gmail.com]

SERVER KONGKN2

- contains 2 instances, DB2 and DB2TEST
- kong6 database is created both in DB2 and DB2TEST


If i issue the following command :

1)

catalog tcpip node node1 remote kongkn2 server 50000


2)
Catalog database kong6 as remotedb at node node1


3)

Connect to remotedb user db2admin using password




How does DB2 know which instance it need to connect to for database kong6 assume
only TCPIP port 50000 is used on server KONGKN2 ?



please advice

thanks.

[Mark A]

Post by d***@gmail.com
How does DB2 know which instance it need to connect to for database kong6 assume
only TCPIP port 50000 is used on server KONGKN2 ?

Each instance must have its own port number. This is defined in the dbm
configuration. (db2 get dbm cfg). The dbm config may have a service name
instead of a port number, but this is mapped to a port number in the
services file.

[d***@gmail.com]

Hi Mark, thanks for the reply.

Here is what i get from the DBM CFG :

TCP/IP Service name (SVCENAME) = db2c_DB2

I am using DB2 v8.1 for windows xp professional.

May i know where is the "SERVICES" file located on windows ? i belief that the services file have the entry for port number refer by "db2c_DB2". Correct me if i am wrong.

Any help will be appreciated.

Thanks in advance.

[d***@gmail.com]

Hi Mark, please ignore this. I have found it. There is another forumer has pointed it out.

Thanks a lot.

It is in C:\WINDOWS\system32\drivers\etc.