Display System

View information about current system-wide settings.

Syntax

Examples

display system;

Displays current password and session management settings.

Descriptions

You can display server-wide information in the following ways using display system.

Key Phrase Explanation
display system Display current connections and system-wide settings.
display system version Display the server software version number.
display system ports Display the number of ports that are available and in use on the system.
display system export_directory Display names of directories created for linked-reporting objects exported from a database to a directory created in $ARBORPATH\app.

If you used export lro and gave a full path to a directory for export files, those directories are not listed. Only export directories created in the ARBORPATH\App directory using the following export lro method are listed:

export database DBS-NAME lro to <server or local> directory DBS-EXPORT-DIR;

where DBS-EXPORT-DIR is a suffix (for example, dir1) for the name of a directory created by MaxL in $ARBORPATH\App. MaxL creates the directory with a prefix of appname-dbsname-. For example, display system export_directory would list the following directories existing under $ARBORPATH\App:
sample-basic-dir1
sample-basic-dir2

but it would not list export directories created elsewhere by providing a full directory path when using the export lro statement, such as:
c:\MyExports\MyExportDir

display system security file fragmentation_percent Display the percentage of security file fragmentation. 0% means the security file is not fragmented, and higher percentages indicate the degree of fragmentation.

Fragmentation can gradually develop when objects such as users, groups, applications or databases are removed or changed. To prevent fragmentation, the security file is compacted each time the Agent shuts down.

You can also defragment the security file without stopping the Agent. For more information, see

  • The essbase.cfg setting SECURITYFILECOMPACTIONPERCENT.

  • The MaxL statement alter system compact security file;

  • The Agent command COMPACT (for documentation of Agent commands, see the Database Administrator's Guide).

Output Columns

configuration field values are numeric, and translate as follows:

1		Non-Unicode mode
2		Unicode mode

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