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.

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