Upgrade Guide for UNIX > Postupgrade Tasks > Postupgrade Tasks for Global Deployments >

Setting Up Your Environment to Support Global Time Zone

Global deployments typically span multiple geographies and have users working in several different time zones. The global time zone feature converts and stores date and time data using the Universal Time Coordinated (UTC) standard, which is equivalent to Greenwich Mean Time, but without daylight savings time. This feature allows you to track dates and times in a common format across time zones.

CAUTION:  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.

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

Perform one of the following procedures, as appropriate to your upgrade path:

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 any 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 below (see Global Deployment Guide for complete instructions).

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, before upgrading to Release 7.5, you previously upgraded to Release 7.x and you already ran the UTC conversion utility, perform the following steps to upgrade the delta columns (those that were not UTC-enabled in 7.x but are UTC-enabled in 7.5).

CAUTION:  Back up your database before you run the UTC delta conversion procedure.

To upgrade 7.x data for columns that have changed to UTC-enabled in 7.5

  1. Open the master_utc.ucf file from DBSRVR_ROOT/DATABASE_PLATFORM/master_utc.ucf, and edit the File Name parameter by replacing driver_utc.ucf with driver_utc_delta.ucf.
  2. Launch the Database Server Configuration Utility from the command prompt by typing:

    dbsrvr_config.ksh

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

  3. When you reach the Database Server Options screen, select Run Database Utilities.
  4. At the Database Utility Selection screen, select UTC Upgrader.
  5. Continue until you are prompted to run the Siebel Upgrade Wizard (srvrupgwiz), then click OK.

For more information about UTC, see Global Deployment Guide.


 Upgrade Guide for UNIX
 Published: 20 October 2003