IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Upgrade from a previous installation > Plan your upgrade > Back up your portal server and Tivoli Data Warehouse databases
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Back up the Tivoli Data Warehouse database
Follow the procedure in this section to back up the Tivoli Data Warehouse database.
Use the following command to back up the Tivoli Data Warehouse database where DB2 Database for Linux, UNIX, and Windows is the relational database management system of choice.
db2 backup database yourwarehousedatabase to /yourbackuplocation
If an existing connection prevents you from backing up the database, use the following commands.
- db2 connect to yourwarehousedatabase
- db2 quiesce database immediate force connections
- db2 connect reset
- db2 backup database yourwarehousedatabase to /yourbackuplocation
- db2 connect to yourwarehousedatabase
- db2 unquiesce database
- db2 connect reset
Sites using the Summarization and Pruning Agent with DB2 for Linux, UNIX, and Windows
Your migrated Tivoli Data Warehouse database requires subsequent checking to ensure it is set up so the Summarization and Pruning Agent can perform multiple system batching. Complete these steps:
- Back up the database, if necessary.
- Edit the KSY_DB2_WAREHOUSEMARKER.sql script. If using archive logging, modify it as suggested in the script to avoid the need for extra backup at the end.
- Execute the script:
db2 -tvf KSY_DB2_WAREHOUSEMARKER.sqlThe code will detect if the table is correctly migrated. If not, a single managed system will be enforced independent of the setting to prevent database deadlocks.
This procedure affects only the WAREHOUSEMARKER table. If you do not complete it, the Summarization and Pruning Agent will do single system batching only.
Parent topic:
Back up your portal server and Tivoli Data Warehouse databases