Entering content frame

Background documentation Backup and Recovery: Logging Parameters (DB2 UDB for UNIX and Windows) Locate the document in its SAP Library structure

You can access information on logging parameters by calling transaction ST04 and choosing Backup and Recovery ® Logging Parameters in the navigation frame of the DBA Cockpit. The Logging Parameters screen appears.

This screen provides information on the logging parameters configured, such as size of log files, log retain status or user exit status. Furthermore, you can check the space available of the file systems where your database logs ( log_dir ) and the archived database logs ( log_archive ) are stored.

Caution

In a production system, log retain and user exit must be switched on.

If this is not the case, you risk losing data and the ability to roll forward your database if serious database problems occur.

Full log files are moved automatically from log_dir to log_archive by program db2uext2 . Program db2uext2 is automatically called by the DB2 database manager. The directory name of log_archive is defined within file init<SID>.db6 , which is located in the global directory by the variable DB2DB6_ARCHIVE_PATH .

Leaving content frame