DB2 Version 9.7 for Linux, UNIX, and Windows

Configuring database logging options

Use database logging configuration parameters to specify data logging options for your database, such as the type of logging to use, the size of the log files, and the location where log files should be stored.

About this task

You can configure database logging options using the UPDATE DATABASE CONFIGURATION command on the command line processor (CLP), through the Configure Database Logging wizard GUI in the Control Center, or by calling the db2CfgSet API.

Before you begin

To configure database logging options, you must have SYSADM, SYSCTRL, or SYSMAINT authority.

Procedure