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 ...