DB2 in 64 Bit Mode and Hiperpools

(Originally posted 2005-11-23.)

A recent client of mine is still using Hiperpools – while in 64-bit mode (and with > 2GB of memory on each LPAR).

It is my contention that they would save CPU, and probably get better buffer pool effectiveness, if they switched to a judicious mixture of virtual pools and data space pools.

Would any reader care to relate their site’s experience with this sort of reconfiguration?

In this post by virtual pools I mean those backed by DBM1 virtual storage, rather than data space or hiperpools. So virtual pools contribute towards the tally of DBM1 virtual storage usage, which (as we all know) is limited to significantly less than 2GB.

This client is on Version 7 – and I expect them to remain there for a while. I do know – from IFCID 225 (Statistics Trace Class 6) – that they can’t replace the whole of their current hiperpool inventory with virtual pools. So some mixture of data space and virtual is inevitable.

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: