dba-db2.com
Changing DB2 database pagesize

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

 Read More

Querying Bufferpools DB2 - DBA DB2

Database will come up with hidden buffer pools - DBA DB2

Db2 reduce tablespace with ALTER TABLESPACE REDUCE

Author: Jack Vamvas(http://www.dba-db2.com)

Subscribe to DBA-DB2.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright