Configure for database session persistence
You can configure a database to collect session data for database session persistence.
Overview
To configure the session management facility for database session persistence, complete the following steps.
Procedure
- Create and configure a JDBC provider.
- Create a data source pointing to a database.
Use the JDBC provider that you defined: Resources > JDBC > JDBC Providers > JDBC_provider > Data Sources > New. The data source should be non-JTA, for example, non-XA enabled. Note the JNDI name of the data source.
Point to an existing database.
- Verify that the correct database is listed under Resources > JDBC Providers > JDBC_provider > Data Sources > datasource_name. If necessary, contact your database administrator to verify the correct database name.
- Go to the appropriate level of Session Management.
- Under Additional Properties, click Distributed Environment Settings
- Select and click Database. The database user ID and password are case-sensitive.
- Specify the Data Source JNDI name from a previous step.
- Specify the database user ID and password for accessing the database.
- Retype the password for confirmation.
- Configure a table space and page sizes for DB2 session databases.
- Switch to a multirow schema.
- Click OK.
- To change the tuning parameters, click Custom Tuning Parameters under Additional properties and select a setting or customize a setting.
- Click Apply.
- Click Save.
Switching to a multirow schema
Configure tablespace and page sizes for DB2 session databases
Database settings
Multirow schema considerations
Related concepts
Distributed sessions
Sessions
Related Reference
HTTP session problems