InfoCenter Home >
4: Developing applications >
4.4: Personalizing applications >
4.4.1: Tracking sessions >
4.4.1.1: Session programming model and environment >
4.4.1.1.7: Tuning session support >
4.4.1.1.7.8: Tuning session support: Tablespace and page sizes for DB2 session databases

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.

Go to previous article: Tuning session support: Scheduled invalidation Go to next article: Best practices for session programming

 

 
Go to previous article: Tuning session support: Scheduled invalidation Go to next article: Best practices for session programming