Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Database input/output (_UserIO)
 
Database input/output (_UserIO)
The _UserIO VST displays information about the database input/output operations, including user number and name and the number of accesses, reads, and writes.1
Field name
Data type
Description
_UserIO-AiRead
INT64
Number of AI read operations performed by the process
_UserIO-AiWrite
INT64
Number of AI write operations performed by the process
_UserIO-BiRead
INT64
Number of BI read operations performed by the process
_UserIO-BiRecRead
INT64
Number of BI notes read
_UserIO-BiRecWrite
INT64
Number of BI notes written
_UserIO-BiWrite
INT64
Number of BI write operations performed by the process
_UserIO-DbAccess
INT64
Number of database access operations performed by the process
_UserIO-DbRead
INT64
Number of database read operations performed by the process
_UserIO-DbWrite
INT64
Number of database write operations performed by the process
_UserIO-Name
CHARACTER
User name of the process
_UserIO-TenantId
INTEGER
Tenant ID of the user
_UserIO-Usr
INTEGER
User number of the process
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.