IBM 000-8697 User Manual

IBM Informix OnLine Database Server Administrator’s Guide

Use the tbstat -b, -X, and -B options to identify a specific user process that is
holding a resource that might be needed by another user process.

The tbstat -p option can help you assess performance as measured by the
percentage of cached reads and writes.

For monitoring information that describes the efficiency of the buffer pool,
refer to

 (buffer-pool activity).

From the command line, execute tbstat -b to obtain the following buffer
statistics:

■

General buffer statistics (total number, number modified)

■

Address of each user process currently holding a buffer

■

Page numbers for those pages in currently held buffers

■

Address of the first user process waiting for each buffer

You can compare the addresses of the user processes to the addresses that
appear in the tbstat -u display to obtain the process ID number.

Refer to

 for further information about the tbstat -b output.

Execute tbstat -X to obtain the same information as tbstat -b, along with the
complete list of all user processes that are waiting for buffers, not just the first
waiting process.

Refer to

 for further information about the tbstat -X output.