You can change the logging levels of the
XML ODBC driver.
About this task
To activate the log file for the ODBC driver

- In the registry, go to My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM Rational® Insight XML ODBC Driver.
- 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

- Open the odbcinst.ini file with your text editor.
- 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

- In the registry, go to My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM Rational Insight XML ODBC Driver.
- 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

- Open the odbcinst.ini file with your text editor.
- 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
- 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.
- Open the log4j.properties file with a text editor.
- 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.