var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: "list history" command - How to remove entries?
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?
The only way I know is the PRUNE HISTORY command, but it is only able to remove items before a timestamp:
It will remove all items regardless of the type.
Oops. Doesn't work...
After execute the command "db2 prune history 200801", all the items remain when I type the command "list history"...
What is the output of the list history?
What is the output of db2ckrst?
Maybe it thinks it still needs those entries.
Here's the output of db2ckrst
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:
db2ckrst -d dbname -t 20080101000000 -r database
Error: db2ckrst - No image found for timestamp 20080101000000
Return code of -8 seen at line 1363
No. Maybe you should check with IBM.