"list history" command - How to remove entries?

Shyckymn · #1 (**permalink**) 01-31-08, 07:51

How do I delete some entries that are result of the query below?

db2 list history containing schema.table for database

I want to remove some entries from the List History command.

It is possible?

ARWinner · #2 (**permalink**) 01-31-08, 08:04

The only way I know is the PRUNE HISTORY command, but it is only able to remove items before a timestamp:

http://publib.boulder.ibm.com/infoce...c/r0001992.htm

It will remove all items regardless of the type.

Andy

Shyckymn · #3 (**permalink**) 01-31-08, 11:04

After execute the command "db2 prune history 200801", all the items remain when I type the command "list history"...

ARWinner · #4 (**permalink**) 01-31-08, 11:18

What is the output of the list history?

What is the output of db2ckrst?
http://publib.boulder.ibm.com/infoce...c/r0004471.htm

Maybe it thinks it still needs those entries.

Andy

Shyckymn · #5 (**permalink**) 02-08-08, 11:12

The command "db2 prune history 200801" was executed without errors.
But the "list history" command until has all the entries.

Here's the output of db2ckrst:

Quote:

db2ckrst -d dbname -t 20080101000000 -r database

Error: db2ckrst - No image found for timestamp 20080101000000
Return code of -8 seen at line 1363

Any tips?