Object documentationMACHINEUTILIZATION Locate this document in the navigation structure

 

The system table SYSINFO.MACHINEUTILIZATION contains information about the utilization of the computer on which the database is installed.

Structure

MACHINEUTILIZATION

PHYSICALMEMORYUSABLE

FIXED(10)

Size of free physical memory (MB)

VIRTUALMEMORYUSABLE

FIXED(10)

Size of free virtual memory (MB)

PROCESSUSEDUSERTIME

FIXED(10)

Time the database kernel process has spent in user mode since the database was started (s)

PROCESSUSEDSYSTEMTIME

FIXED(10)

Time the database kernel process has spent in system mode since the database was started (s)

MACHINEUSEDUSERTIME

FIXED(10)

Time the computer has spent in user mode since the database was started (s)

MACHINEUSEDSYSTEMTIME

FIXED(10)

Time the computer has spent in system mode since the database was started (s)

MACHINEIDLETIME

FIXED(10)

Time the computer has spent in idle mode since the database was started (s)

MACHINEIOWAITTIME

FIXED(10)

Time the computer has waited for I/O since the database was started (s)

CPULOAD

CHAR(12)

CPU load on the computer