Extracting Regional Databases in Parallel by Using the Administrative Interface

You can extract regional databases in parallel by using the administrative interface.

To extract regional databases in parallel by using the administrative interface

1. Make sure advanced parameters are visible.

   For more information, see Making Advanced Server Parameters Visible.

2. Adjust the shared pool size.

   For more information, see Adjusting the Shared Pool Size for Parallel Database Extract.

3. Locate the record for the Parallel Database Extract server component.

   For more information, see Locating the Record for a Server Component.

4. Use Columns Displayed to expose the Max Tasks field of the Components list.

5. Click the Parameters tab, click Advanced, and then query the Parameter field for the following value:

   Maximum Number of Work Queue Threads

   The Max Tasks field for the Parallel Database Extract server component displays the maximum number of worker threads for each work queue. The Maximum Number of Work Queue Threads parameter determines the degree of parallelism.

6. Complete the procedure for using the administrative interface that is described in Extracting the Regional Database by Using the Single Thread Option, with the following modifications:

   • In the Component/Job field, choose Parallel Database Extract.

   • To specify more than one regional node, you can create a text file and then enter the name of each regional node on a single line in this file. When you specify the Value for the Client Name parameter, you enter the path and file name, preceded by the at sign (@). For example, a Windows client might specify the following value as the Value for the Client Name:

     @D:\workdir\regnodes.txt