Databases Reference
In-Depth Information
Working at the System level with MaxL
The database administrator is sometimes required to clear the Essbase log, unload
all the application from the memory, or kill a process which is running. All of these
statements can also be performed by the
system
MaxL statement. The
system
MaxL
statement has only two actions to
alter
or
display
information.
Alter system properties
Using the
alter system
MaxL statement, you will be able to load and unload
an application on the server, clear the Essbase log file, set invalid login limit, set
password reset days, enable/disable Unicode, log out all or a specific user session.
These changes are all updated at the analytic server level.
Let's see some of the
alter system
statements in use.
Syntax:
alter system load application all | <App-Name>;
alter system unload application all | <App-Name>;
alter system clear logfile;
alter system logout session all | <Session-id> | by user <User-name>
| on application <App-Name> | on database <Db-Name>;
alter system enable unicode;
alter system disable unicode;
Code Sample:
alter system load application 'ESSCAR';
alter system logout session by user 'SARMA';
Display system properties
The
display system
MaxL statement displays the information about
the Essbase server.
Syntax:
display system version | ports_in_use | expost_directory
| license_info;
Code Sample:
display system all;
display system ports_in_use;
