Sets the the default number of threads that can be produced during parallel data export.
This setting does not apply to aggregate storage databases.
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. |
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.
For more information about the export utility, see the Database Administrator's Guide.
EXPORTTHREADS sample basic 4
export (MaxL)
PAREXPORT (ESSCMD)
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |