Click here for non-aggregate storage version
Change application-wide settings. Permission required: Application designer.
alter application ASOSamp set cache_size 64MB;
Sets the maximum size of the aggregate storage cache to 64 MB.
alter application ASOSamp disable commands;
Prevents all users from making requests to the application scope. Use this statement before performing application-wide update and maintenance operations.
alter application ASOSamp comment 'Aggregate storage application';
Attaches a descriptive comment to the ASOSamp application.
You can change the following application-wide settings using alter application.
Key Phrase | Explanation |
---|---|
set minimum permission | Grant all users a minimum level of permission to all databases in the application. Users with higher permissions than this minimum are not affected. |
set variable | Assign a string value to an existing substitution-variable name. If the variable does not exist, first create it using add variable. Substitution variables may be referenced by calculations in the application. |
set cache_size |
Set the maximum size to which the aggregate storage cache may grow.
The aggregate storage cache grows dynamically until it reaches this limit.
This setting takes effect after you restart the application. To check the currently set
limit, use the following MaxL statement:query application APP-NAME get cache_size ;
|
load database | Start (by loading into memory) an idle database. The statement will fail if you do not have at least read privilege for the database. |
unload database | Stop (by unloading from memory) an active database. The statement will fail if you do not have at least read privilege for the database. |
enable startup | Permit all users to load (start) the application. This only applies to users who have at least read privilege for the application. Startup is enabled by default. |
disable startup | Prevent all users from loading (starting) the application. Startup is enabled by default. |
enable autostartup | Start the application automatically when Analytic Server starts. By default, autostartup is disabled. |
disable autostatup | Do not start the application automatically when Analytic Server starts. By default, autostartup is disabled. |
enable commands | Allow all users with sufficient permissions to make requests to databases in the application. Use to reverse the effect of disable commands. The disable commands setting remains in effect only for the duration of your session. By default, commands are enabled. |
disable commands | Prevent all requests to databases in the application, including non-data-specific requests, such as viewing database information or changing database settings. All users are affected, including other supervisors. Supervisors are affected by this setting
as a safety mechanism to prevent accidental updates to databases during maintenance operations.
This setting remains in effect only for the duration of your session. The setting takes effect immediately, and affects users who are currently logged in, as well as users who log in later during your session. Caution: If performing maintenance operations that require disabling commands, you must make those maintenance operations within the same session and the same script as the one in which commands were disabled. By default, commands are enabled. |
enable updates | Allow all users with sufficient permissions to make requests to databases in the application. Use to reverse the effect of disable updates. Disabling updates remains in effect only for the duration of your session. By default, updates are enabled. |
disable updates | Prevent all users from making requests to databases in the application.
Use before performing update and maintenance operations. The disable updates setting remains in effect only for the duration of your session. Caution: If performing maintenance operations that require updates to be disabled, you must make those maintenance operations within the same session and the same script as the one in which updates were disabled. By default, updates are enabled. |
enable connects | Allow all users with sufficient permissions to make connections to databases in the application. Use to reverse the effect of disable connects. By default, connections are enabled. |
disable connects | Prevent any user with a permission lower than Application designer from making connections to the databases that require the databases to be started. This includes starting the databases or performing the ESSCMD SELECT command on the databases. Database connections remain disabled for all databases in the application, until the application setting is re-enabled by the administrator.
By default, connections are enabled. |
enable security | When security is disabled, Analytic Services ignores all security settings in the application and treats all users as Application Designers. By default, security is enabled. |
disable security | When security is disabled, Analytic Services ignores all security settings in the application and treats all users as Application Designers. By default, security is enabled. |
comment | Enter an application description (optional). The description can contain up to 80 characters. |
clear logfile | Delete the application log located in the application directory. A new log is created for entries recording subsequent application activity. |
add variable | Create an application-level substitution variable by name, and optionally assign a string value for the variable to represent. You can assign or change the value later using set variable. A substitution variable acts as a global placeholder for information that changes regularly. Substitution variables may be referenced by calculations and report scripts. |
drop variable | Remove a substitution variable and its corresponding value from the application. |
rename to | Rename the application. When you rename an application, the application and the application directory (ARBORPATH\App\application_name ) are renamed. |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |