Click here for aggregate storage version
Change the state of the Analytic Server. Start and stop applications, delete application log files, manipulate system-wide variables, manage password and login activity, disconnect users, kill processes, back up the security file, and shut down the server. Permission required: supervisor.
A session is a single user connection to Analytic Server. The session can be identified by keywords and names indicating context, or by a unique session ID number.
A request is a query sent to Analytic Server by a user or by another process; for example, starting an application, or restructuring a database outline. Only one request at a time can be processed in each session.
If a session is processing a request at the time that an administrator attempts to terminate the session, the administrator must either terminate the request first, or use the force kewyord available with alter system to terminate the session and the current request.
alter system unload application Sample;
Stops the Sample application, if it is currently running.
alter system logout session by user Fiona;
Disconnects Fiona from any applications or databases to which she is connected.
Note: To log out a user, log out the sessions owned by that user.
alter system set password_reset_days 10;
Specifies that all users will be prompted after 10 days to change their passwords. The day count for any user is reset when the user changes the password or is edited or re-activated by a supervisor.
Use alter system to change the following system-wide settings:
Key Phrase | Explanation |
---|---|
load application | Start an application, or start all applications on the Analytic Server. |
unload application | Stop an application, or stop all applications on the Analytic Server. |
set session_idle_limit | Set the interval of time permitted for a session to be inactive before Analytic Server logs off the user. The minimum limit that you can set is five minutes (or 300 seconds). When the session idle limit is set to none, all users can stay logged on until the Analytic Server is shut down. The default limit is 60 minutes. |
set session_idle_poll |
Set the time interval for inactivity checking and security-backup refreshing. The time interval specified in the session idle poll tells
Analytic Services both of the following:
|
set invalid_login_limit | Set the number of unsuccessful login attempts allowed by any user before the user account becomes disabled. When you change this setting, the counter resets to 0. When the invalid login limit is set to none, there is no limit. By default, there is no limit. |
set inactive_user_days | Set the number of days a user account may remain inactive before being disabled by the system. The counter resets when the user logs in, is edited, or is activated by a supervisor. When the inactive days limit is set to none, user accounts remain enabled even if they are not used. By default, there is no limit. |
set password_reset_days | Set the number of days users may retain passwords. After the allotted number of days, users are prompted at login to change their passwords. The counter resets for a user when the user changes the password, is edited, or is activated by a supervisor. When the password reset days limit is set to none, there is no built-in limit for password retention. By default, there is no limit. |
set variable | Change the value of an existing subsitution variable on the system. The value must not exceed 256 bytes. It may contain any character except a leading ampersand (&). |
clear logfile | Clear accumulated entries from the Analytic Server log located in the Essbase directory. New log entries are created to record subsequent activity. |
delete export_directory |
Delete directories created for linked-reporting objects exported from a database to a directory created in ARBORPATH\app . Use this grammar after the exported LROs have already been migrated into a database using import lro, and the directories containing the exported LRO information are no longer needed.
Note: this process only works for directories created in To view a list of names of exported linked-reporting-objects directories in |
add variable | Create a system-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 system. |
logout session all | Terminate all user sessions currently running on the Analytic Server. |
logout session...force | Terminate a session (or sessions) even if it is currently processing a request. The request is allowed to proceed to a safe point, and then the transaction is rolled back. |
logout session <session-id> | Terminate a session by its unique session ID number. To find out the session ID number, use display session. |
logout session by user | Terminate all current sessions by a particular user, either across the entire Analytic Server, or limited to a specific application or database. |
logout session by user on application | Terminate all current sessions by a particular user across a specific application. |
logout session by user on database | Terminate all current sessions by a particular user across a specific database. |
logout session on application | Terminate all current user sessions across a specific application. |
logout session on database | Terminate all current user sessions across a specific database. |
shutdown | Shut down the Analytic Server. |
kill request all | Terminate all current requests on the Analytic Server. |
kill request <session-id> | Terminate the current request indicated by the session ID. You can obtain session IDs using display session. |
kill request by user | Terminate all current requests by the specified user on the Analytic Server. |
kill request on application | Terminate all current requests on the specified application. |
kill request on database | Terminate all current requests on the specified database. |
stop mining session | Terminate the current data-mining session that was initiated on the server using execute mining task. The session ID of the data-mining session can be determined using display mining session. |
sync security_backup | Check whether the security backup file is the same as the security file, and if not, synchronize the security backup file to the current state of Analytic Services security. The effect is to refresh the backup file with any additions, changes, or deletions related to applications, databases, users, groups, filters, permissions, subsitution variables, locked objects, or system settings.
If |
enable unicode | Set the Analytic Server to allow the creation of Unicode-mode applications and the migration of non-Unicode-mode applications to Unicode-mode applications. |
disable unicode | Prevent the Analytic Server from allowing the creation of Unicode-mode applications or the migration of non-Unicode-mode applications to Unicode-mode applications. |
compact security file | Defragment the security file. Fragmentation can gradually develop when objects such as users, groups, applications or databases are removed or changed. Please note that this operation slows down agent activity until the operation is completed, which could take a few minutes. |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |