Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2007
    Posts
    11

    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?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Mar 2007
    Posts
    11

    Oops. Doesn't work...

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


  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  5. #5
    Join Date
    Mar 2007
    Posts
    11

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

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    No. Maybe you should check with IBM.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •