Siebel Anywhere Administration Guide > Performing Additional Siebel Anywhere Tasks > Process of Updating the Siebel Database Schema >

Checking Siebel Regional Node Server Parameters Before a Siebel Database Schema Update

This topic describes how to check Siebel Regional Node Server parameters before you distribute a Siebel Database Schema upgrade kit to a Regional Node Server.

This task is a step in Process of Updating the Siebel Database Schema.

Before you distribute a Siebel 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 Siebel Database Schema upgrade kit on a Regional Node Server in an IBM DB2 environment, you must drop all customized views and triggers in the regional database. Otherwise, the Upgrade Wizard will encounter errors when applying the changes in the logical schema to the physical schema.

Setting Siebel Regional Node Server Parameters Before Distributing a Siebel Database Schema Update

The following procedure describes how to set Siebel Regional Node Server parameters before you distribute a Siebel database schema update.

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

1. On the Regional Node Server, Navigate to the Administration - Server Configuration screen, then the Servers view.

   The Siebel Servers list appears.

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

   The Server Parameters list and the Additional Parameter Information form appear.

3. In the Server Parameters list, select Upgrade Component in the Parameter field, and set 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 Value field.

4. Still in the Server Parameters list, select Table Owner Password in the Parameter field, and make sure that Value and Value on Restart are not blank.
5. Still in the Server Parameters list, select Version Check in the Parameter field, and set 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.

Checking Server Parameters Using the Server Manager Command Line

The following procedure describes how to check server parameters using the Siebel Server Manager command line.

To check server parameters using the Server Manager command line

• From the command-prompt, enter:

  list param <UpgComponent, VersionCheck, TableOwnPass>

Modifying Server Parameters Using the Server Manager Command Line

The following procedure describes how to modify server parameters using the Siebel Server Manager command line.

To modify server parameters using the Server Manager command line

• Enter:

  change param param_alias=parameter_value

  where param_alias is UpgComponent, VersionCheck, or TableOwnPass.

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