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:
12.1 The workfile evolution ...
Get Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS 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.
