Chapter 9. Miscellaneous Performance Enhancements
There are multiple minor enhancements in DB2 UDB v8.1 that help performance. In this chapter we will discuss:
Distributed Catalog Cache
Prefetching Enhancements with Block-Based Buffer Pools
Page Cleaner I/O Improvements
Multithreading of Java-Based Routines
64-bit Support
Automatic Relationship and Association Management (ARAM)
New Join Variations
Increased Opportunity for Selection of Bit-Filters
These features don't each warrant their own chapter, but, we cover them each here.
Get DB2® Version 8: The Official Guide 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.