Databases Reference
In-Depth Information
•
UPDATECALC
: This specifies if intelligent calc is turned on or off by default.
Syntax:
UPDATECALC TRUE | FALSE
Data import/export
In this section we will walk through the settings you can use to improve the
system's performance while loading data into your cube or while extracting
data from your cube.
•
DLSINGLETHREADPERSTAGE
: This setting tells Essbase to use Single Thread
or use the number of threads specified in the
DLTHREADSPREPARE
and
DLTHREADSWRITE
.
This can be set for an individual application or for the
entire analytic server.
Syntax:
DLSINGLETHREADPERSTAGE [APPNAME] [DBNAME] TRUE | FALSE
•
DLTHREADSPREPARE
: This setting tells Essbase how many threads to prepare
to use for a data load. This is a definite performance enhancer and it is
recommended you specify a number that is one less than the total number
of processors on your server.
Syntax:
DLTHREADSPREPARE n
•
DLTHREADSWRITE
: This setting is used with the
DLTHREADSPREPARE
setting
and specifies the number of threads to actually use during a data load. Again,
the number should be one less than the number of processors on your server.
Syntax:
DLTHREADSWRITE n
Code Sample:
DLSINGLETHREADPERSTAGE ESSCAR ESSCAR TRUE
DLTHREADSPREPARE 2
DLTHREADSWRITE 3
In the above example,
DLSINGLETHREADPERSTAGE
is set to
TRUE
, so this tells
the Essbase server to use a single thread for the Esscar application for data
loading and the
DLTHREADPREPARE
and
DLTHREADSWRITE
will not used.
DLSINGLETHREADPERSTAGE ESSCAR ESSCAR FALSE
DLTHREADSPREPARE 2
DLTHREADSWRITE 3
