IBM 000-8697 Manual de usuario descargar pdf (Pagina 324)

100

101

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

Monitor Buffer-Pool Activity

Monitor buffer-pool activity to determine the general availability of buffers

and to isolate the activity that is triggering buffer-pool ﬂushing. (Refer also

to page 3-66 for general buffer statistics.)

Thetbstat -p outputcontainsthefollowing two statisticsthatdescribebuffer

availability:

Refer to page 7-92 for further information about the tbstat -p output.

tbstat -F

From the command line, execute tbstat -F to obtain a count of the writes

performed by write type. Refer to page 2-75 for a deﬁnition of each of the

following write types:

■ Foreground write

■ LRU write

■ Idle write

■ Chunk write

In addition, tbstat -F lists the following page-cleaner information:

■ Page-cleaner number and shared-memory address

■ Current state of the page cleaner

Details about the function and activities of the page-cleaner daemon

processes are described on page 2-34. Refer to page 7-87 for further infor-

mation about the tbstat -F output.

ovbuff lists the number of timesthat OnLine attempted to exceed the

maximum number of shared buffers,

BUFFERS. (The ovbuff

ﬁeld appears in the third row of output, fourth position.)

bufwaits lists the number of times processes waited for a buffer (any

buffer). (The bufwaits ﬁeld appears in the fourth row of

output, ﬁrst position.)

1 2 ... 319 320 321 322 323 324 325 326 327 328 329 ... 701 702

Comentarios a estos manuales

Sin comentarios

IBM 000-8697 Manual de usuario Pagina 324

Comentarios a estos manuales

Relacionado con productos y manuales para Software de base de IBM 000-8697