Find DB2 Archive Log (Circular Logging) State from SAP

In Oracle database, users are familiar with the terms of archive logs. But in DB2 database, the terms is called as Circular Logging. In SAP system installed with the DB2 database, you can figure out the circular logging state from the transaction code DB02.

So, now you are in transaction code DB02, click on Configuration > Database (double click). On the right panel, switch to Logging tab. Look for Log Retain for Recovery Enabled.

DB02 - Configuration - Database

If the state is RECOVERY, it means that the DB02 archive log (circular logging) is enabled. Else, the state will be NO which means the archive log is disabled.

DB02 - Logging - Log Retain for Recovey Enabled

Alternatively, you can jump to Log File Management tab and look for LOGARCHMETH parameter. If OFF, means the archive log (circular logging) is disabled. Else, if it is enabled, it will state the directory of the logs.

DB02 - Log File Management - LOGARCHMETH

You May Also Like

Leave a Reply?