Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Input/output type activity (_ActIOType)
 
Input/output type activity (_ActIOType)
The _ActIOType VST displays information about types of input/output activity, such as database reads and writes, before-image and after-image reads, total reads, before-image and after-image writes, committed transactions, and database up time.1
Field name
Data type
Description
_IOType-AiRds
INT64
Number of AI read operations
_IOType-AiWrts
INT64
Number of AI write operations
_IOType-BiRds
INT64
Number of BI read operations
_IOType-BiWrts
INT64
Number of BI write operations
_IOType-DataReads
INT64
Number of reads of data blocks
_IOType-DataWrts
INT64
Number of writes to data blocks
_IOType-IdxRds
INT64
Number of reads of index blocks
_IOType-IdxWrts
INT64
Number of writes to index blocks
_IOType-Trans
INT64
Number of transactions committed
_IOType-UpTime
INTEGER
Number of seconds the database was up

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.