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

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

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.