Chapter 30. DB2 Resource Governing
In This Chapter
In addition to performance monitoring and tuning, actively controlling certain types of SQL can be beneficial. For example, consider a critical decision support query that retrieves hundreds, thousands, or even millions of rows from DB2 tables. If the query is well-planned, the designer will have a good idea of the amount of time necessary to satisfy the request.
As time goes on, however, the performance of the query could degrade for many reasons, such as unorganized indexes and table spaces, additional rows being returned, or outdated RUNSTATS. This degradation could affect the entire system because S-locks are being held and DB2 resources are being monopolized. ...
Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
