System Journal Files |
|
System journal files record the result of a transaction on a set of data. The journal file essentially is a record of all changes made to data in the database. The Names of System Journal Files lists the journal files currently used by the database. Up to eight journal files can be specified. If more than one journal file is listed, journal entries are entered into the first journal file until every journal file block is full, then journal entries are entered into the first blocks of the next journal file in the list. Journal entries are recorded in a sequential fashion until all journal files are full. After all journal files are full, journal blocks are overwritten starting with the first blocks of the first journal file listed. Upon creation of the database, JConfiguration Tool gives the journal file a default name that is the same as the database name with the file extension .jnl. The default directory path is the Database Directory path listed above. Users can also enter a new name if a different one is desired. This can be achieved by typing the new name into the text field. Users can select another disk for the journal file to improve data transfer efficiency. This can be achieved by typing the new full directory and file path into the text field. This setting corresponds to the DB_JnFil keyword in the dmconfig.ini file.
The Journal File Size (in pages) is set in the field under the Names of System Journal Files field. This setting corresponds to the DB_JnlSz keyword in the dmconfig.ini file.
Related topic: