Chapter 26. DB2 Object Monitoring Using the DB2 Catalog and RTS

 <  Day Day Up  >  

IN THIS CHAPTER

  • DB2 Catalog Queries

  • Real Time Statistics

  • Reviewing the Rules for an Effective Monitoring Strategy

To maintain efficient production DB2-based systems, you must periodically monitor the DB2 objects that make up those systems. This type of monitoring is an essential component of post-implementation duties because the production environment is dynamic. Fluctuations in business activity, errors in the logical or physical design, or lack of communication can cause a system to perform inadequately. An effective strategy for monitoring DB2 objects in the production environment will catch and forestall problems before they affect performance.

Additionally, if you have a DB2 database object monitoring strategy in place, reacting to performance problems becomes simpler. This chapter describes two types of DB2 database object statistics and how to query those statistics: DB2 Catalog queries and Real Time Statistics.

 <  Day Day Up  >  


DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net