SET LOCKBLOCK

The SET LOCKBLOCK command specifies the maximum number of blocks that Hyperion Essbase can get addressability to concurrently when calculating a sparse member formula.

Syntax

SET LOCKBLOCK HIGH | DEFAULT | LOW;

HIGH, DEFAULT, and LOW Levels defining the number of blocks that Hyperion Essbase can get addressability to concurrently.

Description

SET LOCKBLOCK specifies the maximum number of blocks that Hyperion Essbase can get addressability to concurrently when calculating a block.

You can choose one of three levels. The number of blocks that can Hyperion Essbase can get addressability to at each level is defined using the CALCLOCKBLOCK setting in the ESSBASE.CFG file.

When a block is calculated, Hyperion Essbase locks (gets addressability to) the block along with the blocks containing its children. Hyperion Essbase calculates the block and then releases it along with the blocks containing its children.

By default Hyperion Essbase allows up to 100 blocks to be locked (addressable) concurrently when calculating a block. This is sufficient for most database calculations.

However, you may want to set a number higher than 100 if you are consolidating very large numbers of children in a formula calculation. This setting ensures that Hyperion Essbase can get addressability to all the required blocks when calculating a data block and that performance will not be impaired.

Notes

For more information on data blocks, see the Database Administrator's Guide.

Example

If the ESSBASE.CFG file contains the following settings:

CALCLOCKBLOCKHIGH           500
CALCLOCKBLOCKDEFAULT        200
CALCLOCKBLOCKLOW            50

then:

SET LOCKBLOCK HIGH;

means that Hyperion Essbase can get addressability to up to 500 data blocks when calculating one block.

SET LOCKBLOCK DEFAULT;

means that Hyperion Essbase can get addressability to up to 200 data blocks when calculating one block.

SET LOCKBLOCK LOW;

means that Hyperion Essbase can get addressability to up to 50 data blocks when calculating one block.

See Also

CALCLOCKBLOCK (ESSBASE.CFG file)