NUMBLOCKSTOEXTEND

Determines the number of bytes by which data files in block storage databases are extended to accommodate block updates that require additional disk space.

Syntax

NUMBLOCKSTOEXTEND [appname [dbname]] n

The 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 2048.

Description

When Essbase block storage kernel updates a block, it writes to a new disk location. Block storage 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:

After setting NUMBLOCKSTOEXTEND to a value higher than the default value, there is an increase in the amount of disk space pre-allocated for page files.

Example

NUMBLOCKSTOEXTEND Sample Basic 5120