Db2 runaway query control solution (DB2RNWY)


Runaway queries are one of the major problems affecting Db2 performance.

BMC AMI Ops Monitor for Db2 dynamic and static SQL calls and warning capabilities made it possible to develop the DB2RNWY solution, which provides selective cancel capabilities over such runaway queries.

This solution requires

  • BMC AMI OpsM for Db2
  • BMC AMI Ops Automation for IMS Online
  • BMC AMI Ops Automation for CICS (to cancel a runaway CICS query)

Important

Db2 provides limited protection from runaway queries with the Resource Limit Facility (RLF). However, this protections applies only to dynamic SQL. Moreover, the result from RLF is a query that has stopped with an SQL error code (-905 expected).

This section contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*