EXPORTTHREADS

Sets the the default number of threads that can be produced during parallel data export.

This setting does not apply to aggregate storage databases.

Syntax

EXPORTTHREADS appname dbname n

appname This is the name of the application. You can also use xxxxx as a wildcard to indicate all application names.
dbname This is the name of the database. You can also use xxxxx as a wildcard to indicate all database names.
n This integer, between 1 and 8, inclusive, sets the default for the number of export threads that can be used to export data. This number should generally be equal to the number of processors on your machine that you wish to commit to doing parallel export. The default is 1.

Description

This setting enables the user to specify the number of threads that can be used to export data. The export process is then executed in parallel, and multiple threads can retrieve data and write to their corresponding export files concurrently. If EXPORTTHREADS is not specified, or is not followed by its arguments, then the default value of 1 is used.

Notes

For more information about the export utility, see the Database Administrator's Guide.

Example

EXPORTTHREADS sample basic 4

See Also

export (MaxL)
PAREXPORT (ESSCMD)

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