Monitoring application performance

Once an application has been deployed and run in production, we should actively monitor it for potential bottlenecks. DB2 provides various tools that can be used to monitor application activities. These include event monitors, snapshots, SQL-based snapshots, and monitoring functions, administrative views, and stored procedures. In this recipe, we will discuss different areas of application monitoring and the preferred tools that an application developer can use.

In this recipe, we will discuss various administrative views, routines, and functions which are very useful for monitoring applications.

How to do it...

There are different aspects of monitoring. Whenever we observe any slowdown in application performance, we need handy scripts that can be used to monitor and identify problems. This recipe provides various monitoring tips and commands that can be used for such monitoring requirements.

• Monitoring current SQL statements: The MON_CURRENT_SQL administrative...