LISTFILES

Helps track the amount of disk space used by Analytic Services databases by supplying accurate index and data file information.

Syntax

LISTFILES fileType appName dbName

fileType Type of file for which to display information. Values:
  1. Index files.
  2. Data files.
  3. 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.

Description

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

Example

LISTFILES;

Returns:

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

Index File Count:      1

File 1:
   File Name:          C:\HYPERION\ESSBASE\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\ESSBASE\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)

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com