DB2: The Real Benefit of Data Redundancy

It does not matter to a user why his or her database request failed. The steps required to maximize performance given in the below article.

Whether a transaction timed out because of bad performance, or a component of the solution failed, or an administrator has taken the database offline to perform maintenance, the result is the same to the user: the database is unavailable to process requests.


Steps you need to maximize database availability

  • Redundancy: Having secondary copies of each component of your solution that can take over workload in the event of failure.
  • System monitoring: collecting statistics about the components of your solution to facilitate workload balancing or detecting that components have failed.
  • Load balancing: transferring some workload from an overloaded component of your solution to another component of your solution that has a lighter load.
  • Failover: transferring all workload from a failed component of your solution to a secondary component.
  • Maximizing performance: reducing the chance that transactions take a very long time to complete or time out.
  • Minimizing the impact of maintenance: scheduling automated maintenance activities and manual maintenance activities, so as to impact user applications as little as possible.

Explained all the steps that you need to maximize database performance.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.