Setting the database time zone

In FTM 3.0.0 and later, support is provided for specifying the time zone of timestamps that are contained in the database.

The following options are allowed:
UTC
All timestamps in the database are in Coordinated Universal Time.
Named time zones from the tz or Olson database
The previous time zone behavior of FTM is used, except that the timestamps in the Operations and Administration Console (OAC) are correctly interpreted to be in the viewing time zone. For more information, see Date and time search criteria and Setting user preferences. For the most recent list of accepted time zone names, see Time Zone Database.
Other or blank
The previous time zone behavior of FTM is used, without support for conversion in the OAC.

Use the instructions for the platform where the database is to be created.

Database on UNIX or the Windows operating system

For FTM 3.0.0, Fix Pack 4 and later, the following time zone-related changes must be done manually before the installation scripts are run:
  • Edit the 02a-TimestampFunctions.sql file and update the INSERT statement for the Category='CORE'/Key ='DB_TZ' and set the value to the time zone that is needed. The default value is UTC.
    Note: The correct version of the FTM_TIMESTAMP() function is created automatically.
For FTM 3.0.0 to FTM 3.0.0, Fix Pack 3, the following time zone-related changes must be done manually before the installation scripts are run:
  • Edit the 19-Config.sql file and update the INSERT statement for the Category='CORE'/Key ='DB_TZ' and set the value to the time zone that is needed. The default value is UTC.
  • Edit the 02a-TimestampFunctions.sql file and uncomment the indicated comment block to create the correct FTM_TIMESTAMP() function.

Database on z/OS®

For FTM 3.0.0, Fix Pack 4 and later, the database time zone value is set in one place; in the DB_TZ parameter in the @@2MACRO member. The default value is UTC. The installation scripts use this parameter to make the following changes automatically:
  • Insert a row for the DB_TZ key in the VALUE table. The value for this key is set to the specified parameter setting.
  • Create the correct version of the FTM_TIMESTAMP() function.
For FTM 3.0.0 to FTM 3.0.0, Fix Pack 3, the following time zone-related changes must be done manually before the installation scripts are run:
  • Edit the FTM18CFG member and update the INSERT statement for the Category='CORE'/Key ='DB_TZ' and set the value to the time zone that is needed. The default value is UTC.
  • Edit the FTMTS member and uncomment the indicated comment block to create the correct FTM_TIMESTAMP() function.

For more information about converting message timestamps to UTC, see ESQL time zone mapping functions.