Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Pruning Tables in TOOLSDB ?

    Hello all,

    I need to start pruning TOOLSDB in our production environment. I searched but in vain.
    Can someone provide me some reference or link to such an article.

    DB2V9.5 on win2k3

    thx

    DBFinder

  2. #2
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Surprise !, No body ever prune tables in TOOLSDB !

    I am pruning two tables, MDTHISTORYTY00 and MDTRESULTSTYP00. Should I be pruning any other table !

    Regards

    DBFinder

  3. #3
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    DBFinder, One way is to open up the Journal. This lists all the Tasks that have executed. Remove the entry and all its related rows are removed from the ToolsDB. You can remove them one at a time by Right Clicking on the item and selecting Remove. Or you can remove multiple consecutive rows by Left Click and Hold the button while you drag it down (or up) the list to highlight them and then Right click / Remove them.

    PS You can also use the Menu item Selected->Remove instead of Right Clicking.

Posting Permissions

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