Managing the log

You can control and monitor log activity by using several Db2 commands and a utility.

Quiescing activity before offloading
You can use the MODE(QUIESCE) option of the ARCHIVE LOG command to ensure that activity has stopped before the log is archived.
Archiving the log
If you are a properly authorized operator, you can archive the current Db2 active log data sets when necessary by issuing the ARCHIVE LOG command. Using the ARCHIVE LOG command can help with diagnosis by enabling you to quickly offload the active log to the archive log, where you can use DSN1LOGP to further analyze the problem.
Adding an active log data set to the active log inventory with the SET LOG command
You can use the SET LOG command to add a new active log data set to the active log inventory without stopping and starting Db2.
Deleting an active log data set from the BSDS with the -SET LOG command
You can use the SET LOG REMOVELOG command to delete an existing active log data set from the BSDS without stopping and starting Db2.
Dynamically changing the checkpoint frequency
You can use the LOGLOAD option, the CHKTIME option, or a combination of both of these options of the SET LOG command to dynamically change the checkpoint frequency without recycling Db2.
Setting limits for archive log tape units
Use the Db2 SET ARCHIVE command to set the upper limit for the number of, and the deallocation time of, tape units for the archive log.
Monitoring the system checkpoint
Db2 schedules a system checkpoint every time it switches active log data sets, regardless of the currently defined checkpoint frequency.
Displaying log information
You can use the DISPLAY LOG command to display the current checkpoint frequency. You can obtain additional information about log data sets and checkpoints from the print log map utility (DSNJU004).

Parent topic: Managing the log and the bootstrap data set