21 June,2013 by Jack Vamvas
Question: Analysing an application stack trace , I noticed references to the database pagesize. What is the DB2 database pagesize and how can I change the pagesize value?
Answer: It is possible you may be experiencing pagesize issue. But rather than focusing on the DB2 database pagesize focus on the tablespace pagesizes.
The DB2 database pagesize parameter contains the value that was used as the default page size when the database was created. Possible values are: 4 096, 8 192, 16 384 and 32 768. When a buffer pool or table space is created in that database, the same default page size applies. Read more on database objects
You can specify 4K, 8K, 16K, or 32K for any tablespace, providing you have a bufferpools with matching page size
To use a page size other than the default (4K), complete the following steps.
db2 Connect to MYDB dB2 CREATE BUFFERPOOL MYDBBP SIZE 2000 PAGESIZE 16K dB2 Connect reset dB2 Connect to MYDB dB2 CREATE TABLESPACE MYDBTS PAGESIZE 16K MANAGED BY SYSTEM USING ('\db2home\NODE0000\SQL00006\sessionTS.0') BUFFERPOOL MYDBBP dB2 Connect reset