Filter
Top Products
49
WEBSPHERE PORTAL V6.1 TUNING GUIDE
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.