Query Archive_File

The MaxL query archive_file statement helps you retrieve information about the Essbase database backup archive file.

Minimum permission required: Read.

The database must be running.

Syntax

Description of the illustration query_archive_file.gif

FILE-NAME

You can query archive file information using keywords.

Keywords

get overview

Retrieve the following overview information:

• Application name

• Database name

• Time when the archive was performed

list disk volume

Retrieve a list of disk volume names.

On Windows, Essbase adds the default ARBORPATH drive (for example, the C: drive) as a disk volume, even if the database that you backed up does not store data on that disk volume.

Example

query archive_file /archives/samplebasic.arc get overview;

Retrieves overview information about the samplebasic.arc backup archive file.

query archive_file /archives/samplebasic.arc list disk volume;

Retrieves disk volume information about the samplebasic.arc backup archive file.