Set for database session persistence

 

+

Search Tips   |   Advanced Search

 

Overview

To configure the session management facility for database session persistence...

1. Create and configure a JDBC provider.
2. Create a data source pointing to a database.

   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.

3. Verify that the correct database is listed under...

   Resources | JDBC Providers | JDBC_provider | Data Sources | datasource_name

4. Go to the appropriate level of Session Management.

5. Under Additional Properties, click...

   Distributed Environment Settings

6. Select and click Database.

7. Specify the Data Source JNDI name.

   The database user ID and password are case-sensitive.

8. Specify the database user ID and password used to access the database and for table creation.

   By creatingd the data source, we might have specified a Container Managed Authentication Alias or a Component Managed Authentication Alias; however, these two settings are not used by the session manager for session persistence. The session manager uses the userId and password specified in this step for session persistence.

9. Retype the password for confirmation.
10. Set a table space and page sizes for DB2 session databases.
11. Switch to a multirow schema.

12. Click OK.

13. To change the tuning parameters, click Custom Tuning Parameters under Additional properties and select a setting or customize a setting.

14. Click Apply.

15. Click Save.

 

Related concepts

Distributed sessions
Switching to a multirow schema
Set tablespace and page sizes for DB2 session databases
Create a table for session persistence
Database settings
Sessions

 

Related

HTTP session problems