Display System

Syntax

Description of the illustration dispsys.gif

DBS-NAME

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

Keywords

display system

Display current connections and system-wide settings.

configuration field values are numeric, and translate as follows:

1  Non-Unicode mode
2  Unicode mode

display system version

Display the server software version number.

display system ports in use

Display information about ports currently in use on the system.

display system ports overview

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 license_info

Display information about the license settings implemented on the system.

display system security mode

The type of security in use: native or OPSS mode.

security_mode field values are numeric, and translate as follows:

1  Native Essbase security (no longer supported)
2  OPSS security

display system configuration agent

Display current Essbase Agent configuration properties.

Permission required: Administrator.

display system configuration network

Display current Essbase configuration properties applicable to the network.

Permission required: Administrator.

display system configuration errors

Display Essbase configuration properties that contain errors: an error is any line entry that is not a comment and results in nothing being set.

Permission required: Administrator.

display system configuration on database DBS-NAME

Display Essbase configuration properties applicable to the named database.

Permission required: Administrator.

message_level

Display the values that are set for the system message level.

Sample output:


component           message_level 
+-------------------+-------------------+ 
system              info

Example

display system;

Displays current password and session management settings.

display system configuration agent;

Displays current Essbase configuration properties applicable to the Essbase Agent.

Sample Outputs for Display System Configuration


MAXL> set column_width 40;

MAXL> display system configuration agent;
 KEYWORDS                         SETTINGS
+-------------------------------+----------------
 AGENTTHREADS                    50
 MAXLOGINS                       100000
 PORTUSAGELOGINTERVAL            600
 
 OK/INFO - 1241044 - Records returned: [3].
MAXL> display system configuration network;

 KEYWORDS                                SETTINGS
+---------------------------------------+---------------------------------------
 NETDELAY                                1500
 NETRETRYCOUNT                           2000

 OK/INFO - 1241044 - Records returned: [2].

MAXL> display system configuration on database democfg.basic;

 KEYWORDS                                SETTINGS
+---------------------------------------+---------------------------------------
 CALCCACHE                               TRUE
 CALCCACHEDEFAULT                        1250000
 CALCCACHEHIGH                           1750000
 CALCCACHELOW                            40000
 DLSINGLETHREADPERSTAGE                  FALSE
 DLTHREADSPREPARE                        4
 DLTHREADSWRITE                          4
 DYNCALCCACHEMAXSIZE                     DB[41943040], SV[41943040]
 SSPROCROWLIMIT                          250000

 OK/INFO - 1241044 - Records returned: [9].