Backing up your portal server and Tivoli Data Warehouse databases

When backing up your IBM Tivoli Monitoring environment, you must also back up your portal server database and Tivoli Data Warehouse database. The following sections contains procedures for backup up DB2 databases, which are provided as examples. If you use SQL Server for your portal server database, or Oracle for your Tivoli Data Warehouse database, use the corresponding commands.

• Backing up your portal server database
• Backing up your Tivoli Data Warehouse database

Backing up your portal server database

Use the following command to backup your portal server database.

db2 backup database yourtepsdatabase to /yourbackuplocation

If an existing connection prevents you from backing up the database, use the following commands.

1. db2 connect to yourtepsdatabase
2. db2 quiesce database immediate force connections
3. db2 connect reset
4. db2 backup database yourtepsdatabase to /yourbackuplocation
5. db2 connect to yourtepsdatabase
6. db2 unquiesce database
7. db2 connect reset

Backing up your Tivoli Data Warehouse database

Use the following command to back up your Tivoli Data Warehouse database.

db2 backup database yourwarehousedatabase to /yourbackuplocation

If an existing connection prevents you from backing up the database, use the following commands.

1. db2 connect to yourwarehousedatabase
2. db2 quiesce database immediate force connections
3. db2 connect reset
4. db2 backup database yourwarehousedatabase to /yourbackuplocation
5. db2 connect to yourwarehousedatabase
6. db2 unquiesce database
7. db2 connect reset

[ Top of Page | Previous Page | Next Page | Contents | Index ]