Specifies the maximum amount of memory that Analytic Services can allocate to the triggers feature.
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. |
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.
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.
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 |