Problem Statement: Problem Statement

A BUFFERPOOL definition can NOT include aspects of both formats; either it’s expressed in legacy format or memory format.

• A BUFFERPOOL definition can NOT include aspects of both formats; either it’s expressed in legacy format or memory format.

• A BUFFERPOOL definition with mixed formats is rejected and the database server will not start.

• The charts on the next several slides describe each argument to the BUFFERPOOL parameter:

• both = works with legacy & memory format.
• legacy & memory are mutually exclusive.

BUFFERPOOL size=2k,extendable=1,buffers=1000,next_buffers=2000,max_extends=8

• BUFFERPOOL size=2k,extendable=1,buffers=1000,next_buffers=2000,max_extends=8

• Create a 2k pagesize buffer pool.
• The buffer pool is extendable up to 8 times.
• The 1st 3 extensions will be of 2000 buffers,
• Next 4 will be of 4000 buffers and
• The 8th extension will be of 8000 buffers.
•