Documentation forDatabase Performance Analyzer

Configure DPA to use a different time zone

By default, DPA uses the time zone of the DPA server. You can use a system setting to specify a different time zone for DPA.

See the following sections:

Behavior to be aware of

Before you change the time zone, be aware of the following expected behaviors:

  • DPA data that was previously collected is not updated by this change.

  • If the time zone DPA uses is rolled forward, you will see a gap between data that was previously collected and data collected after the change.

  • If the time zone DPA uses is rolled back, monitoring will stop until the current time is later than the timestamp of the previously collected data. Monitoring logs may include errors such as the following:

    Detected future monitoring data. This can occur when the clock is set to an earlier time. Monitoring cannot continue until the future date [nnnn].]. Will attempt to retry every [60] seconds...

Specify the time zone DPA uses

To use a different time zone than the DPA server, specify the time zone in the system.properties file.

  1. Open the following file in a text editor:

    installDir/iwc/tomcat/ignite_config/idc/system.properties

  2. Add the following line, where myTimeZone is the specified time zone:

    user.timezone=myTimeZone

    For example, to use the US/Pacific time zone, enter:

    user.timezone=US/Pacific

    See Time zone format below.

  3. Save the file.

  4. Restart the DPA service.

Time zone format

Specify time zones in the format used by the Internet Assigned Numbers Authority (IANA), also know as TZ or TZDB. Some examples include:

  • Africa/Cairo
  • America/Los_Angeles
  • Asia/Dubai
  • Asia/Hong_Kong
  • Asia/Singapore
  • Australia/Sydney
  • Europe/London
  • Europe/Madrid
  • Europe/Vienna
  • US/Mountain
  • US/Central
  • US/Eastern

Verify the change

You can verify that the time zone change from the DPA interface or from the logs.

If DPA does not recognize the time zone you specified (for example, because of a typo), DPA uses the default time zone of the DPA server.

From the DPA interface

  1. Log in to DPA as a user with administrative privileges.

  2. From the DPA menu in the upper-right corner, click Options.

  3. Under Administration > Configuration, click Advanced Options.

  4. On the System Options tab, select both of the Option Filters:

    • Non-Default Values
    • Support Options
  5. Locate the TIMEZONE_ID option, and verify that the Current Value column contains the value that you specified.

From the logs

  1. Open the following log file in a text editor:

    installDir/iwc/tomcat/logs/system.log

  2. Locate the user.timezone line and verify that it contains the value that you specified.