Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for Applications >

Setting Up Your Environment to Support Global Time Zone

Upgrades: All upgrades.

Environments: All environments.

This topic is part of an upgrade process. See How to Perform the Upgrade.

If you previously upgraded to Release 7.x and you enabled your environment for global time zone, you do not need to repeat the procedure. Instead, you need to upgrade data from columns that were not UTC-enabled in Release 7.x that are UTC-enabled in the current release.

Global deployments typically span multiple time zones. The global time zone feature converts and stores date and time data using the Universal Time Coordinated (UTC) standard. This feature enables you to track dates and times in a common format across multiple time zones.

Although enabling your environment for global time zone is optional in Release 7.x, it is strongly recommended that you operate your production environment with global time zone enabled.

See Upgrading UTC Delta Columns for information about upgrading 7.x data for columns that were not UTC-enabled in Release 7.x that changed to UTC-enabled in the current release.

Enabling Global Time Zone

To enable global time zone support, after your upgrade is complete, you need to set the global time zone parameter (Universal Time Coordinated system preference) to TRUE through Siebel Tools. The UTC system preference is not enabled after an upgrade to Release 7.x. To enable the global time zone feature, you must run the UTC conversion utility. The high-level steps you need to perform are outlined in the following procedure (see Global Deployment Guide).

To enable global time zone support after an upgrade

1. Stop Siebel Servers.
2. Set UTC system preference to FALSE before you convert your historical data.
3. Prepare your data for conversion to global time zone, as instructed in Global Deployment Guide.
4. Convert your historical data, using the UTC conversion utility, to make all existing date/time values consistent with global time zone logic. Perform this step as instructed in Global Deployment Guide.
5. After you have confirmed that your UTC conversion was successful, turn on global time zone by setting the UTC system preference to TRUE. To reset this parameter through Server Manager, navigate to Application Administration > System Preferences.
6. Bring up Siebel Servers and Web Server.

Upgrading UTC Delta Columns

If you enabled UTC time zone support in a previous upgrade, perform the following steps to upgrade the delta columns (those that are newly UTC-enabled in the current release).

For more information about UTC, see Global Deployment Guide.

To upgrade delta columns to UTC

1. Verify that you have a current backup of your database.
2. Open the master_utc.ucf. It is located in the following directory in the Siebel Database Server installation:
   • Windows: DBSRVR_ROOT\DATABASE_PLATFORM\master_utc.ucf
   • UNIX: DBSRVR_ROOT/DATABASE_PLATFORM/master_utc.ucf
3. Edit the File Name parameter by replacing driver_utc.ucf with driver_utc_delta.ucf.
4. Launch the appropriate Database Server Configuration utility:
   • UNIX: dbsrvr_config.ksh
   • Windows: Start > Programs > Siebel Enterprise Servers > Configure DB Server

     You can also start the wizard under Windows by typing ssincfgw -l language_code -v Y at a Command prompt. The language_code is the three-letter language code, in all capitals, for the language in which you want the GUI to display—for example ENU for English.

     If you are prompted to select an .scm file, select dbsrvr.scm.

5. When you reach the Database Server Options prompt, select Run Database Utilities.
6. At the Database Utility Selection prompt, select Universal Time Code Conversion.
7. Continue until you are prompted to run the Siebel Upgrade Wizard, then click OK.