DB2 runaway query control solution (DB2RNWY)

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

MainView 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

  • MainView for DB2
  • MainView AutoOPERATOR for IMS Online
  • MainView AutoOPERATOR for CICS (to cancel a runaway CICS query)

Note

DB2 provides limited protection from runaway queries with the Resource Limit Facility (RLF), available with DB2 version 2.1. 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).

 

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