And Something Else That Confuses Me

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

Published by Martin Packer

.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: