From: The Boss on 27 Oct 2009 17:54 Sivaswami Jeganathan wrote: > C:\Documents and Settings\Administrator>db2 prune history 20091024 > DB20000I The PRUNE command completed successfully. > > C:\Documents and Settings\Administrator>db2 list history backup all > for mydb > > List History File for mydb > > Number of matching file entries = 1 > > > Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup > ID > -- --- ------------------ ---- --- ------------ ------------ > -------------- > B D 20091024212753001 F D S0000000.LOG S0000000.LOG > > ---------------------------------------------------------------------------- > Contains 4 tablespace(s): > > 00001 SYSCATSPACE > 00002 USERSPACE1 > 00003 TS1 > 00004 SYSTOOLSPACE > > ---------------------------------------------------------------------------- > Comment: DB2 BACKUP MYDB OFFLINE > Start Time: 20091024212753 > End Time: 20091024212758 > Status: A > > ---------------------------------------------------------------------------- > EID: 4 Location: c: > > > C:\Documents and Settings\Administrator>db2 prune history 20091025 > DB20000I The PRUNE command completed successfully. > > C:\Documents and Settings\Administrator>db2 list history backup all > for mydb > > List History File for mydb > > Number of matching file entries = 1 > > > Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup > ID > -- --- ------------------ ---- --- ------------ ------------ > -------------- > B D 20091024212753001 F D S0000000.LOG S0000000.LOG > > ---------------------------------------------------------------------------- > Contains 4 tablespace(s): > > 00001 SYSCATSPACE > 00002 USERSPACE1 > 00003 TS1 > 00004 SYSTOOLSPACE > > ---------------------------------------------------------------------------- > Comment: DB2 BACKUP MYDB OFFLINE > Start Time: 20091024212753 > End Time: 20091024212758 > Status: A > > ---------------------------------------------------------------------------- > EID: 4 Location: c: > Again, re-read the link pointing to the Infocenter-page that covers the PRUNE HISTORY command. In this case notice the "WITH FORCE OPTION" parameter, and what is said about that option in the "Usage Notes" section: <q> If the WITH FORCE OPTION is used, you might delete entries that are required for automatic restoration of databases. Manual restores will still work correctly. Use of this command can also prevent the db2ckrst utility from being able to correctly analyze the complete chain of required backup images. Using the PRUNE HISTORY command without the WITH FORCE OPTION prevents required entries from being deleted. </q> Cheers! -- Jeroen |