Space Requirements for Journal Files
Journal files are created in the database’s journal directory. This is a single directory.
The archiver moves log file records for journaled tables affected by committed transactions to the database’s journal file during periodic sweeps through the log file. The journal files are never directly connected to user sessions--they are written only by the archiver.
The following conditions cause a new journal file to be started:
• Once the journal file reaches a certain size (currently about 8 MB) a new journal file is started.
• Each checkpoint starts a new journal file upon its successful completion, because the journal files contain records of changes made after a specific checkpoint was taken.
You can delete old, unneeded journal files using Director (use the Alter Database dialog) or VDBA (see Setting Checkpoints in online help).
To accomplish this task at the command line, use the ckpdb system command. For more information, see the Command Reference Guide.