Command Reference

PRUNE HISTORY/LOGFILE

Used to delete entries from the recovery history file, or to delete log files from the active log file path.

Authorization

One of the following:

• sysadm

• sysctrl

• sysmaint

• dbadm

Required Connection

Database

Command Syntax

>>-PRUNE----+-HISTORY--timestamp----+--------------------+-+---><
            |                       '-WITH FORCE OPTION--' |
            '-LOGFILE PRIOR TO--log-file-name--------------'
 

Command Parameters

HISTORY timestamp

Identifies a range of entries in the recovery history file that will be deleted. A complete time stamp (in the form yyyymmddhhnnss), or an initial prefix (minimum yyyy) can be specified. All entries with time stamps equal to or less than the time stamp provided are deleted from the recovery history file.

WITH FORCE OPTION

Specifies that the entries will be pruned according to the time stamp specified, even if some entries from the most recent restore set are deleted from the file.

LOGFILE PRIOR TO log-file-name

Specifies a string for a log file name, for example S0000100.LOG. The name identifies the log file that is to be deleted.

Examples

To remove the entries for all restores, loads, table space backups, and full database backups taken before and including December 1, 1994 from the recovery history file, enter:

   db2 prune history 199412

Usage Notes

Pruning backup entries from the history file causes related file backups on DB2 Data Links Manager servers to be deleted.

[ DB2 List of Books | Search the DB2 Books ]