Skip to main content

Software  >  Tivoli  >  Products  >  IBM Tivoli Risk Manager  >  

Use of the New DB2 JDBC Type 4 Drivers with Risk Manager
 Flash (Alert)
 
Abstract
Modifications to rmclasspath.conf and db_sender.conf allow the new DB2 v8 JDBC Universal Driver (Type 4) to function with Risk Manager.
 
Content
DB2 v8 introduces a new Type 4 JDBC Universal Driver. Type 4 drivers are pure Java and implement the network protocol for a specific data source. The client connects directly to the data source. This new IBM JDBC Universal Driver is based on an open distributed protocol, known as Distributed Relational Database Architecture (DRDA) and is compatible with all DB2 server platforms (UNIX, Windows, Linux, z/OS ™ ) with appropriate DRDA Application Server (AS) level support, and prerequisite stored procedures.
To use the new driver, you must add the driver package (db2jcc.jar) to the Java class path used by the Risk Manager agent. In addition, you must modify the Risk Manager DB Sender component configuration file to reference the new driver class (com.ibm.db2.jcc.DB2Driver) and port number.

Make the following changes to $RMADHOME/etc/rmclasspath.conf and $RMADHOME/etc/db_sender.conf to use the newer JDBC Type 4 driver with DB2 UDB v8:

rmclasspath.conf:
/usr/opt/db2_08_01/java/db2jcc.jar

db_sender.conf:
ArchiveDBPort: 60000
ArchiveDBDriver: com.ibm.db2.jcc.DB2Driver

NOTES:
  1. Path names to configuration files and driver files are shown with UNIX syntax. On Windows systems, the path names will be different. For example, the JDBC driver file is located in <DB2INSTDIR>\SQLLIB\java.
  2. JDBC driver class name is case sensitive.
  3. DB2 server port is configured at DB2 server. The default is 60000.
  4. If, after configuration and restart, a 'license not found' error is displayed in the msgHRM.log file, add appropriate Java license files to rmclasspath.conf. For AIX, add the following 2 lines:
      /usr/opt/db2_08_01/java/db2jcc_license_cisuz.jar
      /usr/opt/db2_08_01/java/db2jcc_license_cu.jar
    For other platforms, other license files may be required.

Benefits:
Usage of the JDBC Type 4 driver will eliminate an additional server port (6789) and the requirement to have the JDBC applet server (db2jd) running at all times.
 
 
Product Alias/Synonym
RM RMG
 
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Security
 Security Compliance and Vulnerability Management
 IBM Tivoli Risk Manager
 Operating system(s):
  All Platforms
 Software version:
  4.2
 Reference #:
  1228021
 IBM Group:
 Software Group
 Modified date:
 2008-12-08

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.