IBM 000-8697 Manual do Utilizador descarregar pdf (Página 322)

100

101

3-66 IBM Informix OnLine Database Server Administrator’s Guide

Monitor Buffers

Use the tbstat -b, -X, and -B options to identify a speciﬁc 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 efﬁciency of the buffer pool,

refer to page 3-68 (buffer-pool activity).

tbstat -b

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

statistics:

■ General buffer statistics (total number, number modiﬁed)

■ Address of each user process currently holding a buffer

■ Page numbers for those pages in currently held buffers

■ Address of the ﬁrst 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 page 7-82 for further information about the tbstat -b output.

tbstat -X

Execute tbstat -X to obtain the same information as tbstat -b, along with the

complete listof all user processes thatare waiting forbuffers, not just the ﬁrst

waiting process.

Refer to page 7-101 for further information about the tbstat -X output.

1 2 ... 317 318 319 320 321 322 323 324 325 326 327 ... 701 702

Comentários a estes Manuais

Sem comentários

IBM 000-8697 Manual do Utilizador Página 322

Comentários a estes Manuais

Manuais e produtos relacionados com Software de bases de dados IBM 000-8697