Siebel Network Test

This test checks whether the database server is accessible from the Siebel server, and if so, indicates how quickly the database responds to Siebel requests.

Target of the test : A Siebel Application Server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for each Siebel server being monitored.

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed.

Host

The host for which the test is to be configured.

Port

The port number at which the specified host listens to. By default, this is 1199.

InstallDirectory

Provide the full path to the install directory of the Siebel server.

SibelDataSource

One of the key pre-requisites for a Siebel installation is to create an ODBC Data source exclusively for Siebel Enterprise. The name of this data source needs to be provided here. To know how to locate the data source name, refer to Identifying the DataSourceName and TableOwnerName.

TableOwnerName

Specify the name of the owner of any valid table on the Siebel repository. To know how to find the name of a table owner, follow the procedure detailed in Identifying the DataSourceName and TableOwnerName.

UserName

This test executes a command on the Siebel server to extract the statistics of interest; this command requires administrator privileges to execute. Therefore, enter the name of the Siebel administrator.

Password

Specify the administrator password.

Confirm Password

Confirm the Siebel Agent Password by retyping it here.

Node

Specify the host name of the system on which the data source has been installed; typically, this will be the Siebel server's hostname.  

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Availability

Indicates whether/not a healthy network connection is available between the Siebel server and its database server.

Percent

Ideally, this value should be 100%. A zero value reported for this measure indicates that the database server is not accessible from the Siebel server. This could be owing to a faulty network connection, or a non-availability of the database server itself.

Response time

Indicates the time taken by the database server to respond to the Siebel requests.

Secs

An increase in response time can be due to many reasons such as sudden increase in the number of tasks waiting to be processed, lack of memory, high CPU utilization, buffer pools not properly sized etc.

Identifying the DataSourceName and TableOwnerName

To view a list of data sources to choose from, do the following:

  1. On the ODBC host, follow the menu sequence Start -> Programs -> Administrative Tools -> Data Sources (ODBC).
  2. In the ODBC Data Source Administrator dialog box that appears, click on the System DSN tab.
  3. Figure 1 then appears listing the ODBC data sources currently configured. Find the Siebel data source in the list, and provide its name against the DataSourceName parameter. In the example illustrated by Figure 1 below, SiebSrvr_siebel is the name of the Siebel data source.

ds2-final

Figure 1 : The Data source name

Siebel Enterprise can use an MS SQL server/ Oracle/ DB2 UDB server as its backend. If Siebel Enterprise uses an MS SQL server backend, then follow the steps given below to determine the owner of the Siebel database; the table owner is the same as the database owner:

  1. Open the SQL Enterprise Manager of the MS SQL server installation using the menu sequence, Programs -> Microsoft SQL Server -> Enterprise Manager.
  2. Expand the Databases node in the tree-structure in the left pane of the SQL Enterprise Manager, and select the Siebel database from within; right-click on the database, and select the Properties option (see Figure 2).

    to2-final

    Figure 2 : Selecting the Siebel database Properties

  3. In the Properties dialog box that appears, you will find a name against the Owner field. This name should be specified as the TableOwnerName (see Figure 3).

    to3-final

    Figure 3 : The General tab displaying the database Owner