TRIGMAXMEMSIZE

Specifies the maximum amount of memory that Analytic Services can allocate to the triggers feature.

Syntax

TRIGMAXMEMSIZE [application [database]] memsize

application Optional. Sets the available memory cache for all databases in the specified application.
database Optional. Sets the available memory cache for the specified database. If you specify a database, you must specify the application that contains it.
memsize Available memory cache size (in bytes). Default: 4096 bytes. Minimum: 4096 bytes. Maximum: 8388608 bytes (8MB). Setting memsize to zero (0), or a negative value, disables all triggers.

Description

TRIGMAXMEMSIZE specifies the maximum amount of memory available to the Analytic Services triggers feature. The triggers feature lets you efficiently monitor data changes in a database. If data breaks the rules that you have specified, Analytic Services logs the information in a file or sends an email alert.

For more information about triggers, see the Database Administrator's Guide. For information about MaxL triggers statements, see the Technical Reference.

Notes

Example

TRIGMAXMEMSIZE 12288 

sets the maximum memory cache for the triggers feature to to 12288 bytes (12K). The setting applies to all appliations and databases on the Analytic Server.

See Also

create trigger (MaxL statement)
display trigger (MaxL statement)
alter trigger (MaxL statement)
drop trigger (MaxL statement)

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com