Home page  
Help >
DDL MODE CBUFF Statement
Version 7.11
DDL MODE CBUFF Statement MODE CBUFF

MODE CBUFF [buffer-size number]

In the normal mode of operation there is a standard buffer pool that data, structure, and collection I/O all share. When data bases get over a half million records you can improve throughput by assigning a separate buffer pool for collections. MODE CBUFF accomplishes that.

The first argument is collection buffer size and the number supplied must be one of the following: 4096
8192
16384
32768

only one of the above four numbers are valid for size. The bigger the better.

The second number is the number of buffers desired. As a guidline we can tell you that every time we have used this we always say:

MODE CBUFF 32768 20

This mode statement must be put into a CONFIG file as buffer pools are configured at invocation time.

Copyright © 2019 , WhamTech, Inc.  All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. Names may be trademarks of their respective owners.