IBM 000-8697 User Manual

Operating OnLine

Monitor the OnLine profile to analyze performance over time. The Profile
screen maintains cumulative statistics. Use the tbstat -z option whenever you
wish to reset all statistics to 0.

From

DB-M

onitor, select the Status menu, Profile option.

The screen display contains 28 separate statistics, as well as the current
OnLine operating mode, the boot time, and the current time.

The field labels on the

DB-M

onitor profile screen are less cryptic and arranged

in a slightly different order than the fields that display if you execute
tbstat -p

. However, all

DB-M

onitor statistics are included in the tbstat -p

output. Refer to

 for a detailed explanation of every field that

displays with this option.

From the command line, execute, tbstat -p to display 33 separate statistics on
OnLine activity. The tbstat -p output contains several fields that are not
included in the

DB-M

onitor display, including

ovbuff

, which is the number

of times that OnLine exceeded the maximum number of shared-memory
buffers. The

ovbuff

 field is useful in performance tuning. The complete

display is defined on

.

Execute tbstat -P to obtain the same statistics as are available with tbstat -p,
plus

BIGreads

, the number of big-buffer reads.

Refer to

 for further information about the function of big buffers.