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



Searchable topic ID:   tperswsk
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/ae/tprs_swsk.html

Library | Support | Terms of Use | Feedback