Справочник Пользователя для IBM 000-8697

IBM Informix OnLine Database Server Administrator’s Guide

The third portion of the -p display tracks the number of times a resource was
requested when 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, the

ovtbls

 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
maximum number of locks (specified as

LOCKS

in the configu-

ration file).

ovuser

is the number of times that a user attempted to exceed the
maximum number 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

is the 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

is the 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.