Bookshelf Home | Contents | Index | PDF     

Siebel Universal Queuing Administration Guide > Installing and Running Siebel Universal Queuing > Preparing to Install Siebel Universal Queuing >

Database Configuration for Recovery Table

The Siebel Universal Queuing routing engine writes agent state and work-item state data to a table called DUStore. In the dual-server configuration, if the primary server fails for any reason, the backup server recovers the system state from the data in the DUStore table. In a single-server configuration, you can also recover the system state from this table.

NOTE:  In order to restart Siebel Universal Queuing in a clean configuration (with no pending work items, no agents logged in, no rules loaded, and so on), the recovery data must be deleted from the DUStore table by a database administrator.

A database table creation script is available on the installation CD for all database platforms that Siebel eBusiness Applications support. The DUStore database table must be created by the database administrator. You can create a new database or use an existing database, such as the Siebel database, to contain this table.

For instructions for creating the DUStore table, see Creating the DUStore Recovery Table.

For more information about database support, see the system requirements and supported platforms documentation for your Siebel applications.

The appropriate database client software for the database that you will use must be installed before you install the Siebel Universal Queuing routing engine. The installer detects which database drivers are installed and only displays the database options that are available on the server.

The installer requires information to connect to the database. The following tables show the required input for each supported database. The required input differs slightly for each database. The account name and password are required in each case.

Table 4 provides information for installing on Microsoft SQL Server.

Table 4. Microsoft SQL Server Database Information
Required Input
Notes

Server Name

The hostname where the SQL Server instance is running.

Database Name

The name of the Siebel database in that instance.

Account Name

A username to access the database.

Account Password

Password for the username.

Table 5 provides information for installing on IBM DB2.

Table 5. IBM DB2 Database Information
Required Input
Notes

Database Alias

The DB2 alias defined on the local machine that points to a specific database on the DB2 database server.

For UNIX systems, use the following form:

database_hostname.database_alias

where database_hostname refers to the DB2 database server machine name and database_alias refers to the DB2 database alias cataloged on the local UNIX machine.

Table Owner

The schema name containing the Siebel database in that database.

DB2 Home Directory
(UNIX systems only)

The directory on the local UNIX machine where the DB2 client software is installed—equivalent to $INSTHOME.

Account Name

A username to access the database.

Account Password

Password for that username.

Table 6 provides information for installing on Oracle.

Table 6. Oracle Database Information
Required Input
Notes

Table Owner

The owner or schema name containing the Siebel database.

Connection String

The Oracle connection string, as defined in the file tnsnames.ora.

Oracle Home Directory

The directory on the local machine where the Oracle client software is installed—equivalent to $ORACLE_HOME.

Account Name

A username to access the database.

Account Password

Password for that username.
    
Siebel Universal Queuing Administration Guide