Command Reference

PRUNE HISTORY

Deletes entries from the recovery history file.

Authorization

One of the following:

sysadm

sysctrl

sysmaint

dbadm

Required Connection

Database

Command Syntax

>>-PRUNE HISTORY--timestamp---+--------------------+----------->< +-WITH FORCE OPTION--+

Command Parameters

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.

Example

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

[ DB2 List of Books | Search the DB2 Books ]