Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Database file status (_Filelist)
 
Database file status (_Filelist)
The _Filelist VST displays the filename, file size, and the size of every database file and extent.1
Field name
Data type
Description
_FileList-BlkSize
INTEGER
Block size of the file
_FileList-Extend
INTEGER
Amount of most recent extend in blocks
_FileList-LogicalSz
INTEGER
Logical file size, in blocks
_FileList-Name
CHARACTER
Name of the file
_FileList-Openmode
CHARACTER
Displays the mode in which the file is opened
_FileList-Size
INTEGER
Size of the file
1 Activity and status of ABL temp-tables is available in this virtual system table. The statistics gathered allow you to monitor the operation and performance of deployed client temp-tables. Specify the range of temp-tables to track with the -ttbasetable and -tttablerangesize startup parameters. Specify temp table indexes with -ttbaseindex and -ttindexrangesize startup parameters. For more information monitoring and debugging temp tables with VSTs, see OpenEdge Development: Debugging and Troubleshooting.