Siebel Remote and Replication Manager Administration Guide > Implementing Siebel Replication Manager >

Extracting the Regional Database

Each Regional Database must be extracted on a Siebel Server of its parent node. The Regional Database synchronizes against the Siebel Server on which it is extracted. Database parallel extracts use multithreaded components to make these tasks faster than single-thread operations. Parallel dbxtract requires additional hardware, but can reduce the time to do this significantly.

This section describes the two types of dbxtract: single-thread and parallel. Before beginning either type of database extraction, you must synchronize the server components that are enabled. See Siebel System Administration Guide for details.

CAUTION:  You must specify at least one connected user for the Regional Node before extracting the regional database, or the extraction will fail. For information about specifying connected users for a Regional Node, see Registering a Regional Node.

To extract database for Regional server with single thread - GUI

1. From the application-level menu, choose Navigate > Site Map > Administration - Server Management > Jobs.
2. In the Jobs list, click New.
3. In the Component/Job field, select Database Extract.
4. In the Requested Server field, enter the name of the server on which you want the Database Extract job to run.

   NOTE:  After the job is completed, the read-only Execution Server field displays the name of the server that ran the job. For a Database Extract Job, this is the same as the Requested Server.

   Complete the rest of the fields in the record as appropriate.

5. In the Job Parameters list, which is located below the Jobs list and the Job Detail form, click New and add the necessary parameters as described in the following substeps:
   1. In the Name field, click the select button to display the Job Parameters dialog box.
   2. Select Client Name and click OK to return to the main window.
   3. In the Value field of the Client Name job parameter record, enter the name of the regional node.
   4. Click New to create another new job parameter record.
   5. In the Name field, click the select button to display the Job Parameters dialog box.
   6. Select Database Init Method and click OK to return to the main window.
   7. In the Value field of the Database Init Method job parameter record, replace the default value with DDL.
6. Add any other job parameters as appropriate.

   For a list of parameters you can specify, see Table 27.

7. In the Jobs list, with the Database Extract job selected, click Start.

   The Status field changes from Creating to Queued.

To extract database for Regional server with single thread - Srvrmgr command line

• From the Srvrmgr command line, enter the following command all on one line:

  start task for comp dbxtract server <server_name> with client=<regional node name>, initmethod=ddl

The parallel dbxtract server component (pdbxtract) is designed to improve performance when extracting large databases for one or more Regional Nodes. It is also possible to use pdbxtract when extracting Mobile Web Client databases, but pdbxtract may not improve performance significantly during Mobile Web Client extractions, so the practice is not recommended. You can run pdbxtract as a component request, from within a Siebel application, or you can run it as a task from a srvrmgr command line. The following two procedures describe these two methods of using pdbxtract.

NOTE:  If you plan to use pdbxtract for concurrent extraction of two or more Regional Node databases, be sure to specify all of the applicable Regional Nodes as clients in a single pdbxtract job or srvrmgr command. Due to the design of the pdbxtract component, this produces better performance than starting multiple pdbxtract component requests or tasks that attempt to run concurrently.

To parallel extract database for Regional server - GUI

1. From the application-level menu, choose Navigate > Site Map > Administration - Server Management > Jobs.

   NOTE:  Check the value of the parameter Maximum Number of WorkQ Threads from the Administration - Server Configuration > Components view. The Max Tasks field for the Parallel Database Extract component displays the maximum number of worker threads per work queue. This parameter determines the parallelism of the process. You may need to use the Columns Displayed command to view the Max Tasks field.

2. In the Jobs list, click New.
3. In the Component/Job field, select the Parallel Database Extract.
4. In the Requested Server field, enter the name of the server on which you want the Parallel Database Extract job to run.

   After the job is completed, the Execution Server field displays the name of the server that actually ran the job.

   Complete the rest of the fields as appropriate.

5. Perform the following steps to create Job Parameters records with the specified Names and Values:
   1. In the Job Parameters list, which is located below the Jobs list and the Job Detail form, click New.
   2. In the Name field, click the select button to display the Job Parameters dialog box.
   3. Select Client Name and click OK to return to the main window.
   4. In the Value field, enter the name of the regional node.

      To specify more than one regional node, create a text file and place the name of each regional node on its own line of the file. Then, when specifying a Value for the Client Name parameter, enter the path and file name, preceded by the at sign (@). For example, a Windows client might specify @D:\workdir\regnodes.txt as the Value for Client Name.

   5. In the Job Parameters list, click New.
   6. In the Name field, click the select button to display the Job Parameters dialog box.
   7. Select Database Init Method and click OK to return to the main window.
   8. In the Value field, enter DDL.
6. Add any other parameters for the job as appropriate.

   For a list of parameters you can specify, see Table 27.

7. In the Jobs list, with the Parallel Database Extract record selected, click Start.

   The Status field changes from Creating to Queued.

To parallel extract database for Regional server - Srvrmgr command line

• From the Srvrmgr command line, enter the following command, all on one line:

  start task for comp pdbxtract server <server_name> with client=<regional node name>, initmethod=ddl

  To specify more than one regional node, separate the regional node names with commas. For example, if RN1, RN2, and RN3 are the names of three regional nodes, the client portion of the command would be entered as follows:

  client=RN1,RN2,RN3

  For information on running a Database Extract, see Creating Mobile Web Client User Accounts and Privileges.

Table 27 lists component parameters you can specify for the Database Extract task.

The following example shows a sample portion of the parent node's server directory tree after you run Database Extract tasks for Regional Nodes named SIEBEL_EUROPE and SIEBEL_PACIFIC:

SIEBEL
   DOCKING
      SIEBEL_EUROPE
         INBOX
         OUTBOX
      SIEBEL_PACIFIC
         INBOX
         OUTBOX

After you initialize a Regional Database, the Regional Node's directory structure will include similar folders for any additional Regional Nodes (given a hierarchy of Regional Nodes) and for any mobile users.