Why and when to perform this task
If you are using DB2 for session persistence, you can increase the page size to optimize performance for writing large amounts of data to the database. Page sizes of 8K, 16K, and 32K are supported.
To use a page size other than the default (4K), do the following:
Steps for this task
DB2 Connect to session DB2 CREATE BUFFERPOOL sessionBP SIZE 1000 PAGESIZE 8K DB2 Connect reset DB2 Connect to session DB2 CREATE TABLESPACE sessionTS PAGESIZE 8K MANAGED BY SYSTEM USING ('D:\DB2\NODE0000\SQL00005\sessionTS.0') BUFFERPOOL sessionBP DB2 Connect reset
Refer to DB2 product documentation for details.
Results
When the product is restarted, the Session Management facility creates the new SESSIONS table in the specified tablespace based on the indicated page size.