WAS v8.5 > Administer applications and their environment > Administer web applications > Configure HTTP sessions

Configure for database session persistence

We can configure a database to collect session data for database session persistence. 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.

   Point to an existing database.

3. Verify the correct database is listed under...
   Resources | JDBC Providers | JDBC_provider | Data Sources | datasource_name

   If necessary, contact the database administrator to verify the correct database name.

4. Go to the appropriate level of Session Management.
   Additional Properties | Distributed Environment Settings | Database

5. Specify the Data Source JNDI name from a previous step.

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

   When you created your data source, you 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.

7. Retype the password for confirmation.

8. Configure a table space and page sizes for DB2 session databases.

9. Switch to a multirow schema.

10. Click OK.

11. To change the tuning parameters, click...
    Additional properties | Custom Tuning Parameters

12. Click Apply.

13. Click Save.

Subtopics

• Switching to a multi-row schema
• Configure tablespace and page sizes for DB2 session databases
• Create a table for session persistence
• Database settings
• Switching to a multi-row schema
• Configure tablespace and page sizes for DB2 session databases
• Create a table for session persistence
• Database settings

Related concepts:
Distributed sessions
Sessions
Configure a JDBC provider
Configure database session persistence using scripting
HTTP session problems
Tune parameter settings (custom tuning parameters)

+

Search Tips   |   Advanced Search