Monitor, explain and alert upon all dynamic SQL in your Db2® for z/OS® systems

monitor

Monitoring, explanations and alerts for all dynamic SQL executed in Db2

Whether it comes from an in-house development team or a software product, dynamic SQL has become increasingly more important, and the common usage of dynamic SQL impacts Db2 performance. Unlike static SQL, “explained” and optimized at the BIND, dynamic SQL is bound at run-time, i.e. when a business application executes a query.

For a DBA, it is not possible to know in advance the quality of those queries, nor to control the access path that Db2 will use. They need to monitor the execution on the targeted environments, detect problems and fix the problem by tuning indexes, and/or applications.

Numerous tools can activate and process Db2 traces in order to monitor the execution of the SQL queries. Nevertheless, the overhead generated by the traces drastically limits their usage. A better solution is to monitor the execution of dynamic SQL queries from the Db2 cache, without starting any trace.

Getting started now

Contact us if you want to learn more about our partners

DB/IQ unique cache monitoring offers a global and consolidated vision on all SQL activity in your Db2 systems

Features extract

  • Unique Db2 cache monitoring
  • Alert System specifying thresholds and parameters
  • Cache “snap shots” can be taken at given periods and consolidated to reduce volume of data being evaluated
  • Average CPU Time and Elapse Time for each SQL
  • Easy identification of poor performing SQL
  • Detailed explanatory analysis
  • Reports include Period Analysis, Trends, CPU consumers
  • Neutralizes and identifies duplicate SQLs
  • Tags SQL statements and monitors over a long period of time
  • Contributes to collecting execution frequencies

Benefits

  • Monitors all dynamic SQL regardless of origin
  • Applies the same quality requirements to all SQL queries, whether static or dynamic
  • Reports “SQL problems” in real-time
  • Continuously tunes performance for all dynamic SQL
  • Locates “hot” consumers and tracks them to measure quality development
  • No expensive Db2 traces required

Mainframe Software