Global Deployment Guide > Deploying with Global Time Zone > Converting Historical Data to UTC >
Running the UTC Conversion Utility
Complete the following task to run the UTC conversion utility and convert your date-time data to UTC. See also About the UTC Conversion Utility and Preparing Your Data for Conversion to UTC. This task is a step in Process of Converting Historical Data to UTC. NOTE: Running the UTC conversion utility may take a long time, depending on how many records and how many columns are being converted.
To run the UTC conversion utility from the Database Server Configuration Wizard
- Launch the Database Server Configuration Wizard by using one of the following methods:
- On Microsoft Windows, launch the utility by selecting Start > Programs > Siebel Enterprise Server Configuration 7.x > Database Server configuration.
- On UNIX, first set these environment variables:
setenv LANGUAGE lang (where lang represents your display language, such as ENU)
setenv SIEBEL_ROOT SIEBEL_ROOT (where SIEBEL_ROOT is the name of your Siebel root directory)
Then type the following command to launch the utility:
dbsrvr_config.ksh
The Database Server Configuration Wizard appears.
NOTE: The values you enter into the Database Server Configuration Wizard are case-sensitive. You may not type spaces in parameter values; use underscores (_) instead.
- Enter the required parameters to run the UTC conversion utility.
See Table 9 for a list of dialog boxes, options, and required values.
The UTC conversion utility updates your existing data. For columns configured for UTC, the UTC conversion utility adjusts the historical date and time values to their UTC equivalent.
After successfully converting the UTC-enabled date-time fields, the UTC conversion utility sets the value for the Universal Time Coordinated system preference to TRUE.
The Database Server Configuration Wizard checks for errors, and writes any errors to a log file.
- Review the log file generated by the UTC conversion process, and resolve errors as necessary. See Reviewing the UTC Conversion Log Files.
NOTE: If the UTC conversion fails for any reason, you must review the log files and resolve any errors encountered. Then you need to manually rerun the UTC conversion utility, as described in Manually Launching the UTC Conversion Utility.
Table 9 shows parameters to use with the Database Server Configuration Wizard.
Table 9. Database Server Configuration Wizard
|
Enter or select the following... |
Siebel Enterprise Parameters: Siebel Gateway Name Server Address |
Siebel Gateway Name Server Address (This is typically the machine name.) Enterprise Server Address |
Installation and Configuration Parameters: Siebel Server Directory |
Siebel Server Directory (This is the SIEBSRVR_ROOT directory, for example, D:\sea7x\siebsrvr.) |
Installation and Configuration Parameters: Siebel Database Server Directory |
Database Server Directory (This is the DBSRVR_ROOT directory, for example, D:\sea7x\dbsrvr.) |
Database Server Options: Siebel Database Operation |
Run Database Utilities |
Database Utilities: Database Utility Selection |
Universal Time Code Conversion |
Installation and Configuration Parameters: Language Selection |
Base language of your Siebel application (This is the primary language of your prior environment.) |
Installation and Configuration Parameters: RDBMS Platform |
RDBMS Platform |
Installation and Configuration Parameters: ODBC Data Source Name |
ODBC data source (This was created automatically by the Siebel Server installation, using the format SiebSrvr_EnterpriseName.) |
Installation and Configuration Parameters: Database User Name |
Database User Name (User name of the Siebel administrator, for example, sadmin) Database Password |
Installation and Configuration Parameters: Table Owner |
Table Owner Name (Note for Microsoft SQL: this is the login for the owner of the database, not necessarily the default owner of the database in DBO.) Table Owner Password |
UTC Parameters: Repository Name |
Repository Name |
Configuration Parameter Review |
Review the parameters you have defined and then click Finish. |
|