O'Reilly logo

Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS by Yasuhiro Ohmori, Cathy Drummond, Adrian Burke, Felipe Bortoletto, Paolo Bruni

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Workfiles, RID, and sort pools
This chapter covers past and current changes to the different DB2 “pools.” Customers have struggled to bring their workfile database(s) into harmony between the DB2 releases as they were merged into one database. DB2 10 introduced the ability for various sorting and RID list processes to overflow to the workfile to avoid access path degradation. Various reports and rules of thumb are mentioned.
This chapter contains the following topics:
Sorting
12.1 The workfile ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required