Activating the logs for the Rational Insight XML ODBC driver

You can change the logging levels of the XML ODBC driver.
About this task

To activate the log file for the ODBC driver

Windows
  1. In the registry, go to My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM Rational® Insight XML ODBC Driver.
  2. Add a new item with name Debug and specify the value to be the path of the log file, for example C:/ri_odbc.log
Linux
  1. Open the odbcinst.ini file with your text editor.
  2. Add a new property to IBM® Rational Insight XML ODBC Driver.
    Debug = $ri_odbc_log_file  
    where $ri_odbc_log_file is the path of the log file, for example /opt/logs/ri_odbc.log

To activate the JDBC log

Windows
  1. In the registry, go to My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM Rational Insight XML ODBC Driver.
  2. Add a new item with name jdbclogpath and specify the value to be path of the folder for the JDBC driver log, for example C:/logs.

    The JDBC driver log will be stored in C:/logs/ri_jdbc.log

Linux
  1. Open the odbcinst.ini file with your text editor.
  2. Add a new property to IBM Rational Insight XML ODBC Driver.
     jdbclogpath = $ri_jdbc_log_dir
    where $ri_jdbc_log_dir is the directory where you want to store ri_jdbc.log, for example /opt/logs

To change log level of JDBC driver log

  1. Go to the JDBC log directory and see if the log4j.properties file exists. If the file does not exist, run the job, SQL query, or report that triggered the error message. The log4j.properties file will be created.
  2. Open the log4j.properties file with a text editor.
  3. To activate debug logging, delete # from log4j.category.com.ibm.rational=DEBUG, VEGA.LOG and prefix # to log4j.category.com.ibm.rational=INFO, VEGA.LOG.

Feedback