Chapter 6. Keeping the transaction monitoring environment fit 191
6.4 TMTP TDW maintenance tips
This section provides information about maintaining and troubleshooting the
Tivoli Data Warehouse.
Backing up and restoring
The dbrest.bat script in the misc\tools directory is an example script that shows
you how to restore the three databases on an NT or 2000 Microsoft® Windows
System.
Pruning
If you have established a schedule to automatically run the data mart ETL
process steps on a periodic basis, occasionally manually prune the logs in the
directory %DB2DIR%\logging.
The BWM_m05_s050_mart_prune step prunes the hourly, daily, weekly, and
monthly fact tables as soon as they have data older than three months.
If you schedule the data mart ETL proces ...