Configuring AR System JDBC log settings

As an administrator, you can enable Remedy AR System JDBC (ARJDBC) logging in Remedy Smart Reporting to track the ARJDBC related issues. By default, the ARJDBC logging is disabled because it generates huge data and can lead to performance issues.

To configure the ARJDBC log settings

1. Create a file and save it as ARJDBCLog.properties.

2. Edit the ARJDBCLog.properties file and specify path for the arjdbc_query.log and arjdbc_misc.log settings.
   The contents of the ARJDBCLog.properties file might look similar to the following:
   arjdbc_query.log=C:/JDBC_LOGS/query.log

   arjdbc_misc.log=C:/ JDBC_LOGS/info.log
3. Copy the file to the following locations:
   • The process folder that loaded the ARJDBC driver: <SR_Install_Dir>/appserver/bin
   • The folder pointed by the java.io.tmpdir environment variable. If the environment variable is not defined, copy the file to the <SR_Install_Dir>/appserver/temp directory.
4. Log in to Remedy Smart Reporting as an administrator.
5. Select Admin Console > Data Sources > AR System.
6. In the Custom Parameters section, at the end, add logging = true.
   For example, refreshCache=10;DateTimeFormat=MM/dd/yyyy hh:mm:ss a;DateFormat=yyyy-MM-dd;logging=true;
7. Restart the Tomcat server.