Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Input/output activity (_ActIOFile)
 
Input/output activity (_ActIOFile)
The _ActIOFile VST displays information about input/output activity, including the number of reads, writes, and extends for each file.1
Field name
Data type
Description
_IOFile-BufReads
INT64
Number of buffered read operations performed on the file
_IOFile-BufWrites
INT64
Number of buffered write operations performed on the file
_IOFile-Extends
INT64
Number of extend operations performed on the file
_IOFile-FileName
CHARACTER
Name of the file upon which operations are performed
_IOFile-Reads
INT64
Number of read operations performed on the file
_IOFile-Trans
INT64
Number of transactions committed
_IOFile-UbufReads
INT64
Number of unbuffered read operations performed on the file
_IOFile-UbufWrites
INT64
Number of unbuffered write operations performed on the file
_IOFile-UpTime
INTEGER
Number of seconds the database was up
_IOFile-Writes
INT64
Number of write operations performed on 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.