Bookshelf Home | Contents | Index | Search | PDF

Siebel Anywhere Administration Guide > Supplementary Information for Specific Upgrade Types > Performing Database Schema Updates >

Checking Regional Node Server Parameters Before a Database Schema Update

---

This section describes how to check Regional Node Server parameters before you distribute a database schema update kit to a Regional Node Server.

Before you distribute a database schema to a Regional Node Server, you must make sure that the server parameter Upgrade Component on the Regional Node Server is set to the correct value to match either Siebel Regional Server or any custom configuration you have made for your Regional Node Server. The simplest way to modify the parameter is to use the Server Parameters view, as described in the following procedure.

CAUTION:  Before installing a database schema upgrade kit on a Regional Node Server in a DB2 environment, you must drop all customized views and triggers in the regional database. Otherwise, the Siebel Upgrade Wizard will encounter errors when applying the changes in the logical schema to the physical schema.

To set Regional Node Server parameters before distributing a database schema update

On the Regional Node Server, from the application-level menu, select View > Site Map > Server Administration.
From the Show drop-down list, click Servers.

The Siebel Servers list appears.

From the Servers list, select the appropriate server, and click the Server Parameters tab.

The Server Parameters list appears.

In the Server Parameters list, select Upgrade Component in the Parameter field, and set Current Value to Siebel Regional Server or the name of your custom configuration.

The Value on Restart setting is automatically populated with the same value when you leave the Current Value field.

Still in the Server Parameters list, select Table Owner Password in the Parameter field, and make sure that Current Value and Value on Restart are not blank.
Still in the Server Parameters list, select Version Check in the Parameter field, and set Current Value and Value on Restart to True.

NOTE:  You can also check and modify the Upgrade Component, Table Owner Password, and Version Check parameters in Server Manager.

You can also check and modify Regional Node Server parameters using Server Manager, as described in the following two procedures.

To check server parameters using Server Manager

From the command-prompt, enter:

list param <UpgComponent, VersionCheck, TableOwnPass>

To modify server parameters using Server Manager

Enter:

change param param_alias=parameter_value

Where param_alias is UpgComponent, VersionCheck or TableOwnPass.

For information about other steps in the process of preparing a Regional Node Server for a database schema update, see Process of Preparing Regional Node Servers for Database Schema Changes.

For links to other steps in the process of updating a database schema, see Process of Updating a Siebel Database Schema.

Bookshelf Home | Contents | Index | Search | PDF