LISTFILES

Helps track disk space used by Essbase databases by supplying accurate index and data file information.

Syntax

LISTFILES fileType appName dbName

Parameter	Description
fileType	Type of file for which to display information. Values: Index files. Data files. Index and data files. This is the default.
appname	Name of the application for which information is requested. Required only if no application is selected.
dbname	Name of the database for which information is requested. Required only if no database is selected.

Notes

The LISTFILES command provides index and data file names, counts, sizes, and totals, and indicates whether each file is presently opened by Essbase. The file size information provided by LISTFILES is accurate, whereas the information provided by the Windows operating system for index and data files on NTFS volumes may not be accurate.

Example

LISTFILES;

Returns:

----- Index File Information -----

Index File Count:      1

File 1:
   File Name:          C:\Hyperion\products\Essbase\EssbaseServer\app\Sample\Basic\ess00001.ind
   File Type:          INDEX
   File Number:        1 of 1
   File Size:          8,024 KB (8,216,576 bytes)
   File Opened:        Y

Index File Size Total: 8,024 KB (8,216,576 bytes)

----- Data File  Information -----

Data  File Count:      1

File 1:
   File Name:          C:\Hyperion\products\Essbase\EssbaseServer\app\Sample\Basic\ess00001.pag
   File Type:          DATA
   File Number:        1 of 1
   File Size:          8,008 KB (8,200,192 bytes)
   File Opened:        Y

Data File Size  Total: 8,008 KB (8,200,192 bytes)

File Size Grand Total: 16,032 KB (16,416,768 bytes)