IBM 6.1.X manual Session Persistence To Database Tuning, Parameter Setting Additional Details

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	2000	The default value of Session in memory count is 1000.
	memory count		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	Enable with	How-To Set Parameter:
	Distributed	database 32K page	In the WebSphere Administrative Console: Servers ￿
	Environment	tablespace	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	Min=10	Refer to Datasource Tuning For DB2 on how-to set
	size for Session	Max=33	parameter.
	Data Source
	Prepared	15	Refer to Datasource Tuning For DB2 on how-to set
	Statement Cache		parameter.
	size for Session
	Data Source
		4 9
		W E BS P HE R E P O R T AL V 6 . 1 T U N I N G G U I D E