Syntax

DBS-NAME

Keywords

You can display Essbase Server information in the following ways using MaxL display system.

display system

Display current connections and Essbase Server-wide settings.

Example:

display system;

In the display output, the configuration field values are numeric, and translate as follows:

1  Non-Unicode mode
2  Unicode mode

display system version

Display the Essbase Server software version number.

Example:

display system version;

display system ports in use

Display information about ports currently in use on the Essbase Server.

Example:

display system ports in use;

display system ports overview

Display the number of ports that are available and in use on the Essbase Server.

Example:

display system ports overview;

display system export_directory

Display names of directories created for linked-reporting objects exported from a database to a directory created in the application directory.

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 application 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 the application directory. MaxL creates the directory with a prefix of appname-dbsname-. For example, display system export_directory would list the following directories existing under the application directory:

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

Example:

display system export_directory;

display system license_info

Display information about the license settings implemented on the Essbase Server.

Example:

display system license_info;

display system security mode

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

Example:

display system security mode;

In the output for this statement, 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.

Example:

display system configuration agent;

display system configuration network

Display current Essbase Server configuration properties applicable to the network.

Permission required: Administrator.

Example:

display system configuration network;

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.

Example:

display system configuration errors;

display system configuration on database DBS-NAME

Display Essbase configuration properties applicable to the named database.

Permission required: Administrator.

Example:

display system configuration on database Sample.Basic;

display system message_level

Display the values that are set for the Essbase Server message level.

Example:

display system message_level;

The output lists the following information:

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

Sample Outputs for MaxL 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].