4.4.1.1.7.8: Tuning session support: Tablespace and page sizes for DB2 session databases
If you are using DB2 for session persistence,
you can increase the page size to optimize performance
for the writing of large amounts of data to the database.
In versions earlier than 4.0, IBM WebSphere Application Server supported only a 4K page size.
Page sizes of 8K, 16K, or 32K are supported in Version 4.0.
To use a page size other than the default (4K), do the following:
If the SESSIONS table already exists, drop it from the DB2 database.
Create a new DB2 buffer pool and tablespace,
specifying the same page size (8K, 16K or 32K) for both,
and assign the new buffer pool to this tablespace. A simple example follows:
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 tablespace name and page size in the Session
Manager. (Page size is referred to as row size in the Session Manager
console.)
When the product is restarted,
the Session Manager creates a new SESSIONS table
in the specified tablespace based on the page size specified.