View information about current database-wide settings.
display database;
Displays information about all databases on the system.
display database Sample.Basic;
Displays information about the Sample.Basic database.
Use display database to display database information in the following ways:
Key Phrase | Explanation |
---|---|
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. |
db_type field values are numeric, and translate as follows:
0 Normal 1 Currency
currency conversion field values are numeric, and translate as follows:
1 division 2 multiplication
compression field values are numeric, and translate as follows:
1 Run-length encoding 2 Bitmap 3 ZLIB
db_status field values are numeric, and translate as follows:
0 Not Loaded 1 Loading 2 Loaded 3 Unloading
data_status field values are numeric, and translate as follows:
0 No Data 1 Data Loaded without Calculation 2 Data is Calculated
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
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |