Specifying the time zone associated with events

If the ObjectServer is running in a time zone that differs from either the Oracle database or any clients that view the data, the ObjectServer UTC values can be converted to an Oracle date/time value which contains the associated time zone of the local host that the gateway is running on.

You do this by setting the Oracle.SendTimezoneData property to TRUE. The ObjectServer UTC values are then converted to Oracle TIMESTAMP WITH TIME ZONE data type columns in the Oracle schema, replacing the DATE data type columns. The Oracle dates are then supplemented with the local host's time zone value. The time zone value is stored in either the ORACLE_GW_TZ environment variable or the operating system's TZ environment variable.

Note: The Oracle schema must contain the TIMESTAMP WITH TIME ZONE data types and not the DATE data types. The TIMESTAMP WITH TIME ZONE data type is not compatible with Netcool/Reporter.