(Originally posted 2007-06-21.)
This customer is using DB2 Hiperpools, despite being on a z9 BC processor and running DB2 Version 7.
What I notice from DB2 Statistics trace is that most of the Hiperpool pages are not backed by memory. In other words they’ve ceased to exist. This despite there being plenty of memory in the LPAR. One thing that’s also significant is that there are very few reads back from the Hiperpools. It’s mostly writes.
Somehow I think the two facts are linked. In any case I would recommend the customer moves to Version 8 and, in the short term, uses Dataspace pools instead of the combination of Hiperpools and Virtual Pools.
Meanwhile I’m still scratching my head. 🙂