NUMBLOCKSTOEXTEND
The NUMBLOCKSTOEXTEND configuration setting enables you to control extension of the data file in Essbase block storage (BSO) databases, to accommodate block updates that require additional disk space.
Syntax
NUMBLOCKSTOEXTEND [appname [dbname]] nThe product of n and the currently requested block size is the number of bytes by which the data file is extended.
The default value is 2,048.
Description
When the Essbase BSO kernel updates a block, it writes to a new disk location. The kernel searches free space to find a new disk location to use. If there is not enough free space to service the current request, the data file is extended.
Note:
Upon first upgrading to this release, there is an increase in the amount of disk space pre-allocated for page files unless you set NUMBLOCKSTOEXTEND to 1.
Example
NUMBLOCKSTOEXTEND Sample Basic 2240