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

Examples

Defining an Archive Journal File

The following CREATE ARCHIVE JOURNAL statement defines the archive journal file SYSJRNL:

create archive journal idmsdmcl.sysjrnl
   block size 19068 characters
   assign to sysjrnl;

Changing the Block Size

The following ALTER ARCHIVE JOURNAL statement changes the block size of the archive journal file SYSJRNL to 32,670 characters:

alter archive journal idmsdmcl.sysjrnl
   block size 32670 characters;

Dropping an Archive Journal File

The following DROP ARCHIVE JOURNAL statement deletes the definition of the archive journal file SYSJRNL from the dictionary:

drop archive journal idmsdmcl.sysjrnl;