Setting the database time zone

The following options are allowed:

UTC

All timestamps in the database are in Coordinated Universal Time.

Named timezones from the tz, or Olson, database

This option indicates that 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

This option indicates that the previous time zone behavior of FTM is used, without support for conversion in the OAC.

For FTM 3.0.0, Fix Pack 4 or 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 VALUE table row for the DB_TZ key with the value 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.