View the best practices for minimizing, or even potentially eliminating, planned database outages. Planned outages can include activities such as routine database maintenance activities or upgrades to your database environment.
This paper describes several best practices for minimizing or even potentially eliminating
planned database outages. An outage is any situation in which the database is unable to
serve user requests, either completely as in the case of an offline database or partially as
in the case of unacceptable performance. Planned outages can include activities such as
routine database maintenance activities or upgrades to your database environment.
Outages have a direct impact on the availability of your database environment.
Availability is a measure of a system’s ability to serve user application requests. Some
database environments can tolerate occasional interruptions in availability while others
must be available around the clock. The availability strategy you choose, and the
resources you spend to achieve your availability goals, should be driven by the needs of
your business.
DB2 data server contains features that can help you eliminate some types of planned
outages and reduce the impact of others. This paper will discuss those features as well as
when and how to use them to help achieve a high level of availability.
- Executive summary
- Introduction
- Availability
- Outages
- Unplanned outages
- Planned outages
- Availability strategies
- Improving availability during table and index maintenance
- Improving availability during data loading or data ingestion
- Improving availability during upgrades
- Improving availability during backups
- Improving availability during performance tuning
- Improving availability through storage management
- Best Practices
- Conclusion
- Further reading
- Notices
"
Best Practices:
Minimizing Planned Outages
"
(May 2008)
View the best practices for minimizing, or even potentially eliminating, planned database outages. Planned outages can include activities such as routine database maintenance activities or upgrades to your database environment. (pdf; 524KB; 25 pages)
Comment, edit, or add your own insights to the Minimizing Planned
Outages best practices
on the IBM Database Wiki.
Check out all the other Best Practices papers and see how you can improve your experience with DB2 for Linux, UNIX, and Windows.
| 
