7-94 IBM Informix OnLine Database Server Administrator’s Guide
Option Descriptions
Thethird portion of the -p display tracks the number of times a resource was
requestedwhen none was available. For example, if the value of TBLSPACES
is set to 200 in your configuration file and a user process attempted to open
the 201st table, theovtbls field would be incremented by 1.
The last portion of the -p display contains miscellaneous information, as
follows:
ovtbls is the number of times that OnLine attempted to exceed the
maximum number of available tblspaces (specified as
TBLSPACES in the configuration file).
ovlock is the number of times that OnLine attempted to exceed the
maximumnumber of locks (specified as LOCKS in the configu-
ration file).
ovuser is the number of times that a user attempted to exceed the
maximumnumber of users (specified as USERS in the configu-
ration file).
ovbuff is the number of times that OnLine attempted to exceed the
maximum number of shared-memory buffers (specified as
BUFFERS in the configuration file).
usercpu isthe total user CPU time used by all user processes, expressed
in seconds.
syscpu is the total system CPU time used by all user processes,
expressed in seconds.
numckpts is the number of checkpoints since the boot time.
flushes isthe number of times that the buffer pool has been flushed to
the disk.
bufwaits increments each time a user process must wait for a buffer.
lokwaits increments each time a user process must wait for a lock.
lockreqs increments each time a lock is requested.
deadlks increments each time a potential deadlock is detected and
prevented.