Sets the HIGH, DEFAULT, and LOW values for the calculation script SET LOCKBLOCK command, which specifies the maximum number of blocks that Essbase can fix (get addressability to) when calculating one block.
This setting does not apply to aggregate storage databases.
CALCLOCKBLOCKHIGH | CALCLOCKBLOCKDEFAULT | CALCLOCKBLOCKLOW n
Where HIGH, DEFAULT, and LOW are levels:
HIGH—Maximum number of blocks that a user can choose to fix concurrently when one data block is calculated. Maximum: half the number of blocks that fit into the data cache.
DEFAULT—Default number of blocks that can be fixed concurrently.
LOW—Minimum number of blocks that a user can choose to fix concurrently.
n—Integer value for each level, representing the total number of blocks that can be locked concurrently.
CALCLOCKBLOCK specifies the number of blocks that can be fixed at each level of the SET LOCKBLOCK HIGH | DEFAULT | LOW calculation script command.
When a block is calculated, Essbase fixes (gets addressability to) the block along with the blocks containing its children. Essbase calculates the block and then releases it along with the blocks containing its children. By default, Essbase allows up to 100 blocks to be fixed 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 ensures that Essbase can fix all the required blocks when calculating a data block and that performance will not be impaired.
For more information on data blocks, see the Oracle Essbase Database Administrator's Guide.
The maximum you can specify for CALCLOCKBLOCK is half the number of blocks that fit into the data cache. If you specify a number great than this, Essbase defaults to a number equal to half the number of blocks that fit into the data cache.
You can calculate the number of blocks that fit into the data cache by dividing the data cache size (in bytes) by the block size (in bytes). Values for the data cache size and the block size are available in Administration Services.
If the essbase.cfg file contains the following settings:
CALCLOCKBLOCKHIGH 500 CALCLOCKBLOCKDEFAULT 200 CALCLOCKBLOCKLOW 50
Then you can use the following SET LOCKBLOCK setting commands in a calculation script:
SET LOCKBLOCK HIGH;
Essbase can fix up to 500 data blocks when calculating one block.
SET LOCKBLOCK DEFAULT;
Essbase can fix up to 200 data blocks when calculating one block.
SET LOCKBLOCK LOW;
Essbase can fix up to 50 data blocks when calculating one block.
Note: | In essbase.cfg, a parameter is not followed by a semicolon; in a calculation script, a parameter must be followed by a semicolon. |
SET LOCKBLOCK (calculation script command)