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.
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_SQLadministrative...