Starts the parallel data-export process.
PAREXPORT [-threads n] [-in input_filename] | [output_filename] amount formatOption
-threads n | Overrides the default number of export threads set in the
EXPORTTHREADS setting in the essbase.cfg file. The maximum
value is 8. If n is greater than 8, Analytic Services assumes the value to
be 8.
|
||||||
-in input_filename | Specifies the name of an input file that contains a list of
export file names. The number of files listed in the input file must match
the number of export threads. Parallel export gracefully errors out if there
is a mismatch.
|
||||||
output_filename | Specifies the root for the file names created to contain the
export data. For each thread, a number is appended to the specified output_filename. For example, if outfile_filename is outfile and two threads are specified, the resulting file names are outfile1 and outfile2 . If the data for a thread exceeds 2 GB, that
export data is divided into multiple files with a second number appended to the file names. See Note for details.
|
||||||
amount | Specifies the number representing the data to export.
|
||||||
formatOption | Specifies the format of the data.
|
This command enables users to perform the data export process in parallel. With this command, users can override the default number of export threads specified in the EXPORTTHREADS setting, and they can provide a list of export file names. During the export process, multiple threads can retrieve data and write to their corresponding export files concurrently.
Parallel export creates multiple export files based on the number of export threads specified. The database is divided as evenly as possible among the number of parallel export threads.
The export process does not begin until all users are logged out of the database. After the export process begins, the database is in read-only mode. Users can read the data but they cannot change it. After the export process is finished, Analytic Services returns the database to read-write mode and users can make changes to the data.
Note: If the data for an export thread exceeds 2 GB, that data
is separated into multiple files. Each file is less than 2 GB. The
first file name retains the original name; Analytic Services appends _1
,
_2
, and so on, as needed, to the additional files.
PAREXPORT -threads 4 -in e:\data\input.txt 1 1;
Note: | e:\data\input.txt is a text file that contains
four file names on separate lines;that is, |
e:\data\export1.txt |
In this example, all data in the database is divided among four export threads to create four export files. The data is exported in columnar format.
If the data intended for a file is greater than 2 but less than 4 GB,
Analytic Services creates two files. For example,
for the data apportioned to e:\data\export2.txt
, Analytic Services would create
e:\data\export2.txt
and e:\data\export2_1.txt.
EXPORT
EXPORTTHREADS configuration setting
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |