Display Database
Use MaxL display database to view information about Essbase database-wide state, settings, and recent request history.
Keywords
Use the MaxL display database statement to display database information in the following ways:
- display database [all]
-
Display information for all databases on the system.
Example:
display database; - display database DBS-NAME
-
Display information about the specified database (cube).
Example:
display database Sample.Basic; - display database on application
-
Display information about all databases on the specified application.
Example:
display database on application Sample; - display database … request_history
-
Include in the database display information about recent requests for the database. Information about the last three requests is returned.
Example:
display database on application ASOSamp request_history;
Output Columns Returned for MaxL Display Database
- application
-
Name of the application.
- database
-
Name of the database.
- comment
-
Text of the database comment, if present.
- startup
-
Whether the database is set to start when a user attempts retrievals against it.
- autostartup
-
Whether the database is set to start when the application starts.
- minimum permission
-
Minimum permission setting for the database.
Not applicable in EPM Shared Services security mode.
- aggregate_missing
-
Whether Essbase aggregates missing values during database calculations.
- two_pass_calc
-
Whether Two-Pass calculation is enabled.
- create_blocks
-
Whether create blocks on equations is enabled.
- data_cache_size
-
The size setting of the data cache for holding uncompressed data blocks.
- file_cache_size
-
The size setting of the file cache.
- index_cache_size
-
The size setting of the index cache, a buffer in memory that holds index pages.
- index_page_size
-
The size setting for the index page, a subdivision of an index file that contains index entries that point to data blocks. This setting is not changeable.
- cache_pinning
-
Whether cache memory locking is enabled (no longer supported).
- compression
-
Compression type. Values returned for compression are numeric, and translate as follows:
1 Run-length encoding 2 Bitmap 3 (no longer supported) - retrieve_buffer_size
-
The size of the retrieval buffer, used to process and optimize retrievals from grid clients.
- retrieve_sort_buffer_size
-
The size of the retrieval sort buffer, used to hold data to be sorted during retrievals.
- io_access_mode
-
The current I/O access mode. Only buffered I/O is supported.
- pending_io_access_mode
-
Values returned for pending_io_access_mode are numeric, and translate as follows:
0 Invalid / Error 1 Buffered 2 Direct /* no longer supported - no_wait
-
Whether Essbase is set to wait to acquire a lock on data blocks that are locked by another transaction.
- committed_mode
-
Whether Essbase is set to enable transactions to hold read/write locks on all data blocks involved with a transaction until the transaction completes and commits.
- pre_image_access
-
Whether Essbase is set to allow users read-only access to data blocks that are locked for the duration of another concurrent transaction.
- lock_timeout
-
The maximum number of minutes that data blocks can be locked by users.
- commit_blocks
-
The number of data blocks updated before Essbase performs a commit (The default is 3000).
- commit_rows
-
The number of rows of a data file processed during a data load before Essbase performs a commit (The default is 0).
- currency_database
-
Name of a linked currency database, if one exists.
- currency_member
-
The member to use as a default value in currency conversions.
- currency_conversion
-
The method of currency conversion.
Values returned for currency_conversion are numeric, and translate as follows:
1 division 2 multiplication - note
-
Annotation accessible from the login dialog box.
- db_type
-
Database type. Values returned for db_type are numeric, and translate as follows:
0 Normal 1 Currency - read_only_mode
-
Values returned for read_only_mode are numeric, and translate as follows:
0 Not read only 1 Read only - db_status
-
Running status of the database. Values returned for db_status are numeric, and translate as follows:
0 Not Loaded 1 Loading 2 Loaded 3 Unloading - elapsed_time
-
How long the database has been running, in hours:minutes:seconds.
- users_connected
-
Number of connected users.
- blocks_locked
-
How many data blocks are locked.
- number_dimensions
-
Number of dimensions.
- number_disk_volume
-
Number of disk volumes.
- data_status
-
Values returned for data_status are numeric, and translate as follows:
0 No Data 1 Data Loaded without Calculation 2 Data is Calculated - current_data_cache
-
Current size of the data cache.
- current_file_cache
-
Current size of the file cache.
- current_index_cache
-
Current size of the index cache.
- current_index_page
-
Current size of the index page.
- currency_country_dim
-
For currency databases, the country dimension.
- currency_time_dim
-
For currency databases, the time dimension.
- currency_category_dim
-
For currency databases, the accounts dimension where currency categories are defined.
- currency_type_dim
-
For currency databases, the currency type dimension, which contains members that identify various currency scenarios.
- request_type_n / request_user_n / request_start_n / request_end_n
-
If you use the request_history keyword, information about the last three requests is returned under columns request_type_n, request_user_n, request_start_n, and request_end_n, where n is 1, 2, and 3. The request_user fields return the names of the users who made the requests. The request_start and request_end fields return the date and time of the requests.
Values returned for request_type are numeric, and translate as follows:
0 Data Load 1 Calculation 2 Outline Update Unknown