Display Database

View information about current database-wide settings.

Syntax

Examples

display database;

Displays information about all databases on the system.

display database Sample.Basic;

Displays information about the Sample.Basic database.

Descriptions

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.

Output Columns

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