Log types in the DB2 database (1)

If you are new to the DB2 database, you need to know the log types in the DB2 database. The following describes the log types in the DB2 database for your reference, hope to help you.

1. Log Type

1.1 Activity log active log)

This function is similar to ORACLE's online redo log. This log contains information about transaction units that have not been committed or rolled back, and information about transactions that have been committed but not written to database files.

There are two details:

L The number of Master logs is determined by the parameter LOGPRIMARY, Which is pre-allocated.

L when the master log is insufficient, a maximum of LOGSECOND slave logs can be temporarily allocated.

1.2. ARCHIVED LOG)

Exists in archive mode.

1.1.1. ONLINE ARCHIVED LOG)

They are log files that are no longer needed by common database activities in the active database log directory "online.

1.1.2. OFFLINE archiving LOG (offline archived log)

These are log files that have been moved from the database log directory to offline storage locations such as backup servers) and unnecessary for common database activities.
The difference between the two lies in that online archiving logs exist in the active log directory, but offline logs are not.

1.2. Log Mode

1.2.1. Cyclic log Mode

A number of pre-allocated master logs are used cyclically. If not, you can temporarily apply for several slave logs.