DLTHREADSWRITE

Specifies how many threads Analytic Services may use during the stage of the data load process that writes blocks on the disk. Multiple threads, processing in parallel, may improve data load performance.

This setting does not apply to aggregate storage databases. When loading data to aggregate storage databases, Analytic Services uses a single thread.

Syntax

DLTHREADSWRITE [appname [dbname]] n

 appname Application name. Optional parameter for using the specified number of threads in one or all databases within the application. If you specify a value for appname and do not specify a value for dbname, the setting applies to all databases in the specified application. If you do not specify an application, you cannot specify a database and the setting applies to all applications and databases on the Analytic Server.
 dbname Database name. Optional parameter for applying the TRUE or FALSE setting to a specific database within the specified application. If you do not specify a value for dbname, the setting applies to all databases within the specified application. If appname is not specified, you cannot specify dbname.
 n  The number of threads the data load process may produce for writing data blocks to the disk. Specify an integer between 1 and 16. The default value is 1.
If   n > 16 or a negative number, the value is assumed to be 16.
Important: see Notes below.

Description

The DLTHREADSPREPARE, DLTHREADSWRITE, and DLSINGLETHREADPERSTAGE settings are related to parallel data load processing. Data load processing is divided up into stages that are performed by Analytic Services using separate processing threads for each stage. By default, a single thread is used for each stage. Taking advantage of the multithreading capabilities of the server machine, the separate single-thread stages can be performed in parallel.

To improve data load performance by maximizing use of processor resource for your situation, you can use these settings to enable additional multiple-thread processing within the preparation and write stages of data load processing.

You can specify DLTHREADSWRITE for individual databases, all databases within an application, or for all applications and databases on the server.

In order for Analytic Services to use the value specified for DLTHREADSWRITE, the configuration setting DLSINGLETHREADPERSTAGE must be set to FALSE.

For more information about parallel thread processing in data loads, see the "Optimizing Data Loads" chapter in the Database Administrator's Guide.

Notes

Example

DLSINGLETHREADPERSTAGE Sample Basic FALSE
DLTHREADSWRITE Sample Basic 3

Because DLSINGLETHREADPERSTAGE is set to FALSE for the Sample Basic application and database, Analytic Services uses 3 parallel threads during the write stage when loading data to Sample Basic.

See Also

DLTHREADSPREPARE
DLSINGLETHREADPERSTAGE

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com