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.
About this task
To use a page size other than the default (4K), complete the following
steps.
Procedure
- If the SESSIONS table already exists, drop it from the DB2 database.
- Create a new DB2 buffer pool and table space, specifying the same
page size (8K, 16K or 32K) for both, and assign the new buffer pool to this
table space.
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.
- Configure the correct table space name and page size in the Session
Management facility. Page size is referred to as row size on
the Session Management page.)
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.