IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

Monitor users’ database server processes to determine the number and type
of server processes accessing OnLine, and the status of each one.

From

DB-M

onitor, select the Status menu, User option.

The display provides an overview of database server process activity.

The first field,

PID

, is the user process identification number. The second

field,

User

, is the login ID of the user that created this database server process.

The third field,

Locks Held

, is the number of locks held by the transaction

that is owned by the specified server process.

The fourth and fifth fields are the number of disk reads and write calls made
since the process started.

The last field describes a set of user status flags. A complete description of all
possible user flags is provided on

.

If a server process displays an X flag in the

User Status

field, the process is

in a critical section. No checkpoints can occur until the server process exits
that section of code. Never kill a database server process that is in a critical
section. If you do, OnLine immediately initiates an abort.

From the command line, execute, tbstat -u to obtain user information that is
similar to that available from

DB-M

onitor. In addition, tbstat -u provides the

address of each listed user process, enabling you to track the user process that
is holding a specific latch. Refer to

 for a complete listing of the

 fields that refer to database server processes and their meanings.

The tbstat -u option also provides detailed transaction information in the
second section of the display. This information is relevant for administrators
who are working in a client/server environment using

IBM I

nformix

STAR

or

users who are working in an

IBM I

nformix

TP/XA

 distributed transaction-

processing environment. For detailed discussion of this transaction infor-
mation, refer to