IBM WEBSPHERE 6.1.X - Manual (Page 54)

4 9
W E B S P H E R E P O R T A L V 6 . 1 T U N I N G G U I D E
Session Persistence To Database Tuning
To enable Session Persistence to Database, a data source with non-XA JDBC driver must
be created. We also configured DB2 Session Database with 32K page size to optimize
performance for writing large amounts of data to the database. For details on configuring
tablespace and page size for DB2 session database visit WebSphere Application Server
Info Center. Additional tunings are applied below:
Table 27: WebSphere Session Persistence Tuning
Parameter Setting Additional Details
Session in
memory count 2000 The default value of Session in memory count is 1000.
For Session database persistence enabled load, we set
session in memory count to 2000.
How-To Set Parameter:
In the WebSphere Administrative Console: Servers
Application Servers
WebSphere Portal Container
Settings: Session Management Max in memory
- Set Max in memory
Allow overflow disable The default value of session allow overflow is checked.
For Session database persistence enabled load, we
unchecked it.
How-To Set Parameter:
In the WebSphere Administrative Console: Servers
Application Servers
WebSphere Portal Container
Settings: Session Management -> Allow overflow ->
uncheck it.
Session
Distributed
Environment Enable with
database 32K page
tablespace How-To Set Parameter:
In the WebSphere Administrative Console: Servers
Application Servers
WebSphere Portal Container
Settings: Session Management
DistributedEnvironment Settings ->database
Jndi name: jdbc/sessions (set it according to your
Session datasource)
Userid/password: set it according to your session db
DB2 Row size: ROW_SIZE_32KB
Tablespace name=sess_user32k (set it according to
your db tablespace)
Multiple row schema: uncheck it
ConnectionPool
size for Session
Data Source Min=10
Max=33
Refer to Datasource Tuning For DB2 on how-to set
parameter.
Prepared
Statement Cache
size for Session
Data Source 15 Refer to Datasource Tuning For DB2 on how-to set
parameter.