Changing DB2 database pagesize

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

 Read More on DB2 bufferpools and Tablespaces

Querying Bufferpools DB2 - DBA DB2

Database will come up with hidden buffer pools - DBA DB2

Db2 reduce tablespace with ALTER TABLESPACE REDUCE