The Tivoli Netcool Support's Guide to the JDBC Gateway describes how to use the JDBC Gateway to store Netcool/OMNIbus event data in a relational database.
This guide describes the IBM Tivoli Netcool JDBC Gateway, which reads data from the Object Server and inserts it into a target database using the specified JDBC driver. It covers database considerations, gateway configuration files, performance monitoring, property settings, example installations, event data flow, static table updates, and common issues.
The document explains REPORTING and AUDIT schema types and modes, lists example JDBC driver names and URLs for DB2, Oracle, and Sybase, and includes configuration examples for Linux/Oracle and Solaris environments. It also addresses troubleshooting topics such as status updates, event re-awaken issues, custom table replication, password encryption, and DB2 tracing.
| DB2 JDBC driver name | com.ibm.db2.jcc.DB2Driver |
|---|---|
| DB2 JDBC driver jar | db2jcc.jar |
| Oracle JDBC driver name | oracle.jdbc.driver.OracleDriver |
| Sybase JDBC driver name | net.sourceforge.jtds.jdbc.Driver |
| Gateway schema types | REPORTING and AUDIT |
It reads data from the Object Server and inserts that data into the target database using the specified JDBC driver.
The JDBC drivers are provided by the database provider.
The two schema types are REPORTING and AUDIT.
They should be reported to the database vendor rather than IBM Tivoli Netcool support.