WebSphere Application Server Network Deployment, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Switching to a multirow schema

Why and when to perform this task

By default, a single session maps to a single row in the database table used to hold sessions. With this setup, there are hard limits to the amount of user-defined, application-specific data that WebSphere Application Server can access.

Steps for this task

  1. Modify the Session Management facility properties to switch from single to multirow schema.
  2. Manually drop the database table or delete all the rows in the database table that the product uses to maintain HttpSession objects.

    To drop the table:

    1. Determine which data source configuration Session Management is using.
    2. In the data source configuration, look up the database name.
    3. Use the database facilities to connect to the database.
    4. Drop the SESSIONS table.



Related tasks
Tuning session management
Configuring for database session persistence

Related reference
Multirow schema considerations

Task topic    

Terms of Use | Feedback

Last updated: Mar 17, 2005 4:28:29 AM CST
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/tprs_swsk.html

© Copyright IBM Corporation 2002, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)