PREINIT (Pre-Format Index and Data Areas) › When to Use PREINIT index area › Controlling the Index Block Size

Controlling the Index Block Size

The block size of each database Index Area (IXX) and index partition area (Inn) is determined during IXX (or Inn) initialization. When you initialize an index area, you can override the default index block size by using the optional BLKSIZE= keyword. BLKSIZE= can be used to specify an index block size of from 4096 bytes through 8192 bytes. The BLKSIZE= value remains in effect until the next initialization of the index area. Pick an optimal size for your device type, in a manner similar to how the data area block size is selected.

Note: An OPEN error occurs if an attempt is made to open a database that has an index block size larger than the index buffer size. For more information about the ixxbfrsize parameter of the SYSPOOL MUF startup option, see CA Datacom/DB Database and System Administration Guide.