Switching to a multirow schema

 

Overview

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

 

See Also


Multirow schema considerations