Instance choice in JDBC url connection

[Stefano Gibellini]

Hello all,

I'm using DB2 UDB 7.2 on a Linux server and I've installed the DB2
client on my Windows 2000 machine. I've defined on my client two
instances, one for test databases and one for production databases
and I've cataloged the same database (of course with the same name)
in both instances (these instances and databases have correspondents
on the server). I'm using for my Java tests the application driver
"COM.ibm.db2.jdbc.app.DB2Driver" (JDBC version 2.0) and all goes
well. My problem is I would like defining in the connection url the
instance where is located the database, avoiding the modification
of the environment variable DB2INSTANCE. Is there some property I
can specify in the url that defines the instance to use?

Thanks in advance for any reply.
Stefano Gibellini

[Marcin 'frodo2000' Molak]

Hi Stefano,

Maybe you should use port number in jdbc url. Then you could specify
TCP/IP port for each instance service, for example:

- jdbc:db2://server:50000/dbname:params for first instance
- jdbc:db2://server:50001/dbname:params for second one

Marcin