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

Examples

Defining a Journal Buffer

The following CREATE JOURNAL BUFFER statement defines the journal buffer JRNL_BUFF with 3 pages:

create journal buffer idmsdmcl.jrnl_buff
   page size 2932 characters
   buffer pages 3;

Modifying the Page Size of a Journal Buffer

The following ALTER BUFFER statement changes the page size of journal buffer JRNL_BUFF to 4,352 characters:

alter journal buffer idmsdmcl.jrnl_buff
   page size 4352 characters;

Dropping a Journal Buffer

The following DROP JOURNAL BUFFER statement deletes the definition of journal buffer JRNL_BUFF from the dictionary:

drop journal buffer idmsdmcl.jrnl_buff;