< Day Day Up > |
IN THIS CHAPTER
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 > |