Adding JDBC drivers of DB2 to Spectrum

Spectrum Server
Db2 JDBC
For using the DB2 database as a database, we need to add the JDBC connection in Management Studio.

In Management studio, move to resource section, then click on JDBC drivers.

Management Studio--->Resources---->JDBC Drivers.

For creating any JDBC drivers, we need 3 things mentioned below:-
1) Driver JAR file to be present on Spectrum server.
2) JDBC driver class name.
3) Connection String Template.
 
In JAVA, we can define 4 type of JDBC drivers:-
Type 1: JDBC-ODBC Bridge Driver
Type 2: JDBC-Native API
Type 3: JDBC-Net pure Java
Type 4: 100% pure Java.
 
We are using Type 4 drivers.
 
 
DBC driver class name for type 4 driver:-
com.ibm.db2.jcc.DB2Driver
 
Connection String Template for type 4 driver:-
jdbc:db2://${Host name}:${Port number}/${database name}:user=${username};password=${password};
 
Driver JAR file path for type 4 driver:-
C:\Program Files\IBM\SQLLIB\java\db2jcc4.jar.

User-added image
 
 
 
Now move to connections and add a new connection.
Provide the credentials as shown below:-

User-added image

Click to 'Test' to verify the connection.



 
 
UPDATED:  March 5, 2020