Physical Database DDL Statements › BUFFER Statements › Entity Currency › Examples

Examples

Defining the Default Buffer

The CREATE BUFFER statement below defines a buffer for DMCL IDMSDMCL. The buffer can be used in both local mode and under the central version.

create buffer idmsdmcl.index_buffer
   page size 4276
   local mode buffer pages 15
   central version mode buffer
      initial pages 100
      maximum pages 500;

Modifying the Page Count for Use Under the Central Version

The following ALTER BUFFER statement modifies both the initial page count and the maximum page count of the INDEX_BUFFER buffer:

alter buffer idmsdmcl.index_buffer
   central version mode buffer
      initial pages 150
      maximum pages 300;

Dropping a Database Buffer

The following DROP BUFFER statement deletes the definition of the INDEX_BUFFER buffer from the dictionary:

drop buffer idmsdmcl.index_buffer;