Extracting the Server Database

This process is a step in Process of Extracting the Server Database.

Database extraction uses the server database template that the Siebel Server creates when you run the Generate New Database server component. This template provides an up to date database schema to a new or existing remote client. It is strongly recommended that you distribute all database schema modifications to all remote clients.

The Database Extract server component (alias DbXtract) does the following work:

Identifies visible instances for all members of a list of nodes.
Identifies the commonly visible instances and extracts the records only one time for all these nodes.
Extracts instances that reside outside of the common set for each node.

This configuration helps to reduce the time that Siebel Remote requires to extract a large number of users. The Optimal Mode parameter enables this process. If the Optimal Mode parameter is TRUE, then other parameters can affect the time that Siebel Remote requires to complete the extraction. Example parameters include Nodes Per Group and Extract All Repository Files.

Caution: If the Siebel Gateway uses LDAP authentication, then, when you run a job for Database Extract, you must explicitly specify valid database credentials to connect to the Siebel database. Otherwise, the component task fails, with this message:

Unable to
        connect to Database

. For example, you might run the job by entering a command like this on the srvrmgr command line:

start task for comp dbxtract with
          username=user_name, password=pwd

Related Books

Siebel Performance Tuning Guide

To extract the server database

Make sure you complete all required work.

Caution: Do all required work before you extract the server database.

For more information, see Requirements for Extracting the Server Database.
Log in to the Siebel Server with administrator privileges.

For more information, see Logging in to the Siebel Database as an Administrator.
If the local database contains unsynchronized transactions, then you must attempt to synchronize those transactions before you proceed.
Before running DbXtract for the first time, review whether you must stop the Transaction Processor component (TxnProc) before proceeding.

For more information, see Requirements for Extracting the Server Database.
Navigate to the Administration - Server Management screen, and then the Jobs view.
In the Jobs list, click New.
In the Component/Job field, choose Database Extract from the picklist.
In the Requested Server field, enter the name of the Siebel Server where Siebel Remote runs the Database Extract job.

After the job finishes, the read-only Execution Server field displays the name of the Siebel Server that ran the job. For a Database Extract job, this server is the same as the Requested Server.
Locate the Job Parameters list.

Click New in the Job Parameters list that you located in Step 8, and then add a parameter using values from the following table.

Parameter Name	Description
Client Name	Enter the remote client name.

For more information, see Extracting a Database for Multiple Users.

Optional. To use DAT format for the server database extract file, click New, and then add a parameter using values from the following table.

Parameter Name	Value
Data File Type	DAT

Optional. To specify a password for the database administrator on the remote client, click New, and then add a parameter using values from the following table.

Parameter Name	Value
Client DBA Password	Use the same value that you use with Generate New Database.

With the Database Extract record still chosen, click Start in the Jobs list.

Siebel Remote extracts the server database for the remote client. This step might require a few minutes to finish.

If you receive an error that is similar to the following, then see Rerunning a Database Extract to Avoid a Concurrency Error:
```
Target node is currently in use by another server process
```
If performance degrades during the extract, then take corrective action.

For more information, see Monitoring Performance of a Server Database Extract.

Related Topics

Related Books

To extract the server database