DB2 graphic QMF Version 8

Cleanup of HPO Activity Log tables

As historical data is added to the HPO Activity Log tables, you must perform maintenance on the tables, table spaces, and indexes. (The Q.OBJ_ACTIVITY_DTL table grows substantially faster than the Q.OBJ_ACTIVITY_SUMM table, so it requires careful maintenance.)

Make sure that RUNSTATS is run for the appropriate table spaces and indexes; this helps to maintain efficient performance.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004