ODBC and JDBC parameters

The ODBC and JDBC drivers are used to provide data in relational form to the extract, transform, and load framework of IBM® Rational® Insight for returning the result sets for ETL jobs and live reports. See this topic for a list of ODBC parameters and their explanations.

Parameters for ODBC driver

The parameters for the ODBC driver are under HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Rational XML ODBC Driver registry item.

Name of the parameter Explanation for the parameter Default value of the parameter
LibPath Path of JDBC driver library files.  
MaxActiveStatements Maximum number of active statements (SQL queries) allowed in the system.

When queries more than the specified number are received at the driver, the query request will be queued and the calling thread will be blocked, until there are other statements finish execution or until the waiting timeout.

20
QueuingTimeout Maximum waiting time (in milliseconds) for which a query request is put in the waiting queue. 300000 (5 mins)
DefaultPageSize Page size when fetching data from the source.

This value is passed to the JDBC driver and used for the queries where the page size is not explicitly specified through the "with pagesize=xxx" SQL command in the query.

1000
jdbclogpath Path of JDBC log files.

The path contains the entire directory path including the name of the log file with .txt or .log as suffix. If the value of this parameter is empty, the default values are taken.

  • Windows® systems: My Documents
  • Linux® systems: /user/home/
Debug Enable the log of ODBC driver.

The value contains the entire directory path, including the name of the log file with .log as suffix, for example, C:/ri_odbc.log. Logging information is written to the file if the driver has read and write permissions to the file.

Nothing is specified.

Feedback