Newer version of documentation BMC provides a newer version of the documentation for this version of the product. As a result, BMC no longer accepts comments in this space.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see bao8301.

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)

Note

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*