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.
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. |
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:
- On the ODBC host, follow the menu sequence Start -> Programs -> Administrative Tools -> Data Sources (ODBC).
- In the ODBC Data Source Administrator dialog box that appears, click on the System DSN tab.
- 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.
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:
- Open the SQL Enterprise Manager of the MS SQL server installation using the menu sequence, Programs -> Microsoft SQL Server -> Enterprise Manager.
-
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).
-
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).