IBM®
Skip to main content
    Country/region [select]      Terms of use
 
 
    
     Home      Products      Services & industry solutions      Support & downloads      My IBM     
developerworks > My developerWorks >  Dashboard > IBM Database Wiki > ... > Best Practices > Best Practice - Minimizing Planned Outages
developerWorks
Log In   View a printable version of the current page.
Best Practice - Minimizing Planned Outages
Added by torodanhan, last edited by torodanhan on Apr 01, 2009  (view change)
Labels: 
(None)

  Minimizing Planned Outages

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.

Table of contents

Best Practice - Minimizing Planned Outages - 1. Introduction
Best Practice - Minimizing Planned Outages - 2. Improving availability during table and index maintenance
Best Practice - Minimizing Planned Outages - 3. Improving availability during data loading or data ingestion
Best Practice - Minimizing Planned Outages - 4. Improving availability during upgrades
Best Practice - Minimizing Planned Outages - 5. Improving availability during backups
Best Practice - Minimizing Planned Outages - 6. Improving availability during performance tuning
Best Practice - Minimizing Planned Outages - 7. Improving availability through storage management
Best Practice - Minimizing Planned Outages - 8. Conclusion
Best Practice - Minimizing Planned Outages - 9. Best Practices Summary



( You can also download a PDF of this Best Practice from http://download.boulder.ibm.com/ibmdl/pub/software/dw/dm/db2/bestpractices/DB2BP_Planned_Outages_0508I.pdf which may not contain updates made in this wiki. )


    About IBM Privacy Contact