IBM 000-8697 Manual Do Utilizador

IBM

5

Chapter

How to Improve Performance

In This Chapter . . . . . . . . . . . . . . . . . . . .

Disk Layout . . . . . . . . . . . . . . . . . . . . .

Optimize Blobspace Blobpage Size . . . . . . . . . . . . .

tbcheck -pB and tbcheck -pe Utility Commands

Blobpage Average Fullness . . . . . . . . . . . . . . .

Apply Effective Criteria . . . . . . . . . . . . . . . .

Eliminate User-Created Resource Bottlenecks. . . . . . . . . .

When Is Tuning Needed?. . . . . . . . . . . . . . . . .

% Cached Fields . . . . . . . . . . . . . . . . . .

ovtbls, ovlock, ovuser, and ovbuff Fields . . . . . . . . . .

Bufsize Pages/IO Fields . . . . . . . . . . . . . . . .

Shared-Memory Buffers . . . . . . . . . . . . . . . . .

When Is Tuning Necessary?

. . . . . . . . . . . . . .

How Is Tuning Done?

. . . . . . . . . . . . . . . .

Shared-Memory Resources . . . . . . . . . . . . . . . .

When Is Tuning Necessary?

. . . . . . . . . . . . . .

How Is Tuning Done?

. . . . . . . . . . . . . . . .

Log Buffer Size . . . . . . . . . . . . . . . . . . . .

Logging Status . . . . . . . . . . . . . . . . . . .

How Is Tuning Done?

. . . . . . . . . . . . . . . .

Page-Cleaner Parameters . . . . . . . . . . . . . . . . .

Efficient Page Cleaning . . . . . . . . . . . . . . . .

How Is Tuning Done?

. . . . . . . . . . . . . . . .