How to start VisiNaming with DB2 backend?

Problem:

• Product Name: Visibroker
• Product Version: 5.2 and above
• Product Component: Naming Service
• Platform/OS Version: All
• JDK/Compiler Version: JDK 1.3.x and above

This article teach you how to configure VisiNaming to use DB2 as the backend.

Resolution:

In order to use DB2 for the VisiNaming backend, you need to configure the "vbroker.naming.jdbcDriver" property. For DB2.6.x use the value "com.ibm.db2.jdbc.app.DB2Driver". For DB2.7.x and later, use the value "com.ibm.db2.jcc.DB2Drive".

The new driver, com.ibm.db2.jcc.DB2Drive, is the Universal JDBC driver that allows type 2 and type 4 connections.

For example:
#VisiNaming properties
vbroker.naming.backingStoreType=JDBC
vbroker.naming.poolSize=5
vbroker.naming.jdbcDriver=com.ibm.db2.jcc.DB2Driver
vbroker.naming.loginName=...
vbroker.naming.loginPwd=...

#Type 4 connectivity
vbroker.naming.url=jdbc:db2://<host>:<port>/<database_name>

OR

#Type 2 connectivity
vbroker.naming.url=jdbc:db2:<database_name>

To use Type 2 connection, you must first register the database by its alias using the Client Configuration Assistant. After the database has been registered, you do not have to specify <host> and <port> for the vbroker.naming.url property.
 
Note that you may need to manually set the database listener port in the Control Center in order to use Type 4 connection.