Sets the default number of threads that can be produced during parallel data export.
The EXPORTTHREADS configuration setting is used only when executing the PAREXPORT ESSCMD command without specifying the -threads option.
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 sets the default for the number of export threads that can be used to export data. The default is 1.
Block storage databases: The number of threads is an integer, between 1 and 1024, inclusive. The number of available block-address ranges limits the number of export threads. Essbase divides the number of actual data blocks by the specified number of export threads. If there are fewer actual data blocks than the specified number of export threads, the number of export threads that are created is based on the number of actual data blocks. This approach results in a more even distribution of data blocks between export threads.
Note: | In specifying the number of export files, it is important to consider the number of available CPU cores and I/O bandwidth on the computer on which Essbase Server runs. Specifying too large a number can result in poor performance. |
Aggregate storage databases: The number of threads is an integer, between 1 and 8, inclusive. This number should generally be equal to the number of processors on the machine that you wish to commit to doing parallel export. However, for parallel export on a very small aggregate storage database with a small number of data blocks, it is possible that only a single file will be created (in effect, performing serial export), even though parallel export to multiple files is requested. In this case, the export file name will be the first file name given as input.
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 Oracle Essbase Database Administrator's Guide.
EXPORTTHREADS sample basic 4
Export Data (MaxL)
PAREXPORT (ESSCMD)