WebSphere Application Server Network Deployment, Version 6.0.x   Operating Systems: AIX, HP-UX, Linux, Solaris, Windows
             [TIP: Focusing the table of contents and search results]

Switching to a multirow schema

The multirow schema configuration supports storing an unlimited amount of data that is only bounded by the database capacities in an application. The application can read individual fields instead of the whole record, which can help to improve performance by avoiding unnecessary Java object serialization. Configure the session management facility to store each attribute in a session object in its own row in the database by using the multirow schema configuration.

About 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.

Procedure

  1. Modify the Session Management facility properties to switch from single to multirow schema.
  2. Manually drop the table.

    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
Session management tuning
Configuring for database session persistence
Related reference
Multirow schema considerations
Task topic    

Terms of Use | Feedback

Last updated: Mar 8, 2007 8:14:28 PM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/tprs_swsk.html

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