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.