Toad World Blog

Db2 for z/OS Buffer Pools - Time to Give AUTOSIZE(YES) a Try?

Apr 30, 2018 8:59:00 AM by Robert Catterall

Db2 9 for z/OS became generally available back in 2007. In the years since, most of the features introduced with Db2 9 have been broadly put to use. An interesting exception is the auto-sizing of buffer pools, implemented via the AUTOSIZE(YES) option of the -ALTER BUFFERPOOL command. Based on my experience, it seems that few Db2 for z/OS sites have gone with buffer pool auto-sizing. I find that a bit perplexing. In the Db2 for Linux/UNIX/Windows user community, a feature called self-tuning memory more


Tags: IBM DB2 DB2 z/OS

Robert Catterall

Written by Robert Catterall