Enabling and disabling remote diagnostic logging for the JDBC proxy

To facilitate troubleshooting, IBM® Rational® Test Control Panel administrators can view, download, and share detailed log events information for the JDBC proxy. The capability to display this information in Rational® Test Control Panel requires enabling remote diagnostic logging for the proxy.

About this task

Rational® Test Control Panel can display a diagnostic log that is a centralized view of log events of Rational® Integration Tester proxies.

By default, remote diagnostic logging to Rational® Test Control Panel is not enabled in the Rational® Integration Tester Agent or in the proxies supplied with IBM® Rational® Test Control Panel.

To enable or disable remote diagnostic logging to Rational® Test Control Panel for the JDBC proxy, you must modify the startup parameters of the application that you want to record or virtualize.

Procedure

  1. Edit the startup parameters as shown in the following table.
    Note: In the table, stand-alone Java™ applications and Apache Tomcat are two examples of application server software that is supported by the Rational® Integration Tester JDBC proxy. The following application server software is also supported by the JDBC proxy:
    • IBM® WebSphere® Application Server
    • Oracle WebLogic Server
    • Software AG webMethods Integration Server
    • TIBCO BusinessWorks
    For more information about modifying the startup parameters of any of those application servers, refer to the relevant documentation.
    Table 1. Parameters for enabling and disabling remote diagnostic logging for the JDBC proxy to Rational® Test Control Panel
    To: For stand-alone Java™ applications, do the following: For Apache Tomcat, do the following:

    Enable remote diagnostic logging at debug level to Rational® Test Control Panel

    Note: Available levels are error, warning, info, debug, and trace. The Java.Util.Logging (JUL) appender defaults to "level:debug" if level is not set, so all events are passed to Java.Util and filtered there by the separate configuration.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=level:DEBUG -Dgreenhat.logappender.jul.JUL

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=level:DEBUG -Dgreenhat.logappender.jul.JUL

    Enable remote diagnostic logging at debug level to Rational® Test Control Panel and specify the URL for the network log appender.

    Note: Available levels are error, warning, info, debug, and trace. Instead of entering a specific URL, you can enter url:auto.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver-Dgreenhat.logappender.net.NET=url:http://IP address or hostname:port_number/RTCP,level:DEBUG -Dgreenhat.logappender.jul.JUL

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=url:http://IP address or host name:port_number/RTCP,level:DEBUG -Dgreenhat.logappender.jul.JUL

    Enable remote diagnostic logging at debug level and internal logging to Rational® Test Control Panel.

    Note: Available levels are error, warning, info, debug, and trace.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=level:DEBUG -Dgreenhat.logappender.jul.JUL -Dgreenhat.loginternal=appender

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=level:DEBUG -Dgreenhat.logappender.jul.JUL -Dgreenhat.loginternal=appender

    Enable remote diagnostic logging at error or warning level to Rational® Test Control Panel

    Note: Default remote log level is warning.
    Note: The Java.Util.Logging (JUL) appender is not present, so there will be no local file logging.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET

    Enable console logging at debug level and use detailed layout.

    Note: If Java™ logging is not enabled, you might want to enable console logging. Console logging layout can be detailed, standard, or compact.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.console.CONSOLE=layout:detailed,level:DEBUG

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.console.CONSOLE=layout:detailed,level:DEBUG

    Enable console logging at debug level, use detailed layout, and log internal framework events.

    Note: Internal events will be sent to the console to help diagnose issues within the logging framework.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.console.CONSOLE=layout:detailed,level:DEBUG -Dgreenhat.loginternal=console

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.console.CONSOLE=layout:detailed,level:DEBUG -Dgreenhat.loginternal=console

    Disable all logging.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.none

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.none
  2. Save your changes.
  3. Restart the application or application server as required.