Switching to a multirow schema

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.

 

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.

---

Tuning session management
Configure for database session persistence
Multirow schema considerations

 

WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.