Administering and maintaining a highly available solution

Once you have created, configured, and started your DB2® database high availability solution running, there are ongoing activities you will have to perform. You need to monitor, maintain, and repair your database solution to keep it available to client applications.

As your database system runs, you need to monitor and respond to the following kinds of things:

1. Manage log files.

   Log files grow larger, require archiving; and some log files require copying or moving to be available for a restore operation.

2. Perform maintenance activities:

   • Installing software

   • Upgrading hardware

   • Reorganizing database tables

   • Database performance tuning

   • Database backup

3. Synchronize primary and secondary or standby databases so that failover works smoothly.
4. Identify and respond to unexpected failures in hardware or software.