Display Database

View information about Essbase database-wide state, settings, and recent request history.

Syntax

Description of the illustration dispdb.gif

Use display database to display database information in the following ways:

Keywords

all: Display information for all databases on the system.
<dbs-name>: Display information about the specified database.
on application: Display information about all databases on the specified application.
request_history: Display information about recent requests for the database. Information about the last three requests is returned.

Output Columns

Column

Description

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.

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. Field values 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 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 are numeric, and translate as follows:

1               division
2               multiplication

note

Annotation accessible from the login dialog box

db_type

Database type. Values are numeric, and translate as follows:

0               Normal
1               Currency /* no longer supported

read_only_mode

Values are numeric, and translate as follows:

0               Not read only
1               Read only

db_status

Running status of the database. Values 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 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.

request_type field values are numeric, and translate as follows:


0               Data Load
1               Calculation
2               Outline Update
                Unknown

Example

display database;

Displays information about all databases on the system.

display database Sample.Basic;

Displays information about the Sample.Basic database.