"list history" command - How to remove entries?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Shyckymn
    New Member
    • Mar 2007
    • 5

    "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?
  • sakumar9
    Recognized Expert New Member
    • Jan 2008
    • 127

    #2
    You can try PRUNE command to remove the entries.'



    Regards
    --- Sanjay

    Comment

    • Shyckymn
      New Member
      • Mar 2007
      • 5

      #3
      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
      Any tips?

      Comment

      Working...