Table of Contents

Solving the Page Size issues

Contents

Solving the Page Size issues

Recipes

Increasing the page size (to 32K) for existing DB

db2 create bufferpool <buffer name> IMMEDIATE SIZE AUTOMATIC PAGESIZE 32K
db2 create LARGE tablespace <tablespace name> PAGESIZE 32K BUFFERPOOL <buffer name> NO FILE SYSTEM CACHING
db2 GRANT USE OF TABLESPACE <tablespace name> TO <DB user>

Creating DB with large page size (32K)

create db <DB Name> pagesize 32K