Helps track the amount of disk space used by Analytic Services databases by supplying accurate index and data file information.
LISTFILES fileType appName dbName
fileType | Type of file for which to display information.
Values:
|
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. |
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.
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 |