Configure for database session persistence

 

Overview

To configure the session management facility for database session persistence, complete the following:

 

Procedure

1. Create and configure a JDBC provider.

2. Create a data source pointing to an existing database, using the JDBC provider that you defined. Resources > 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 for the value of the databaseName property under Data Sources > datasource_name > Custom Properties. If necessary, contact your database administrator to verify the correct database name.

4. Go to the appropriate level of Session Management.

5. Click Distributed Environment Settings

6. Select and click Database.

7. Specify the Data Source JNDI name from step 2.

8. Specify the database user ID and password for accessing the database.

9. Retype the password for confirmation.

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

11. Switch to a multirow schema.

12. Click OK.

13. If you want to change the tuning parameters, click Custom Tuning Parameters and select a setting or customize one.

14. Click Apply.

15. Click Save.

 

See also

Switching to a multirow schema
Configuring tablespace and page sizes for DB2 session databases
Database settings
Multirow schema considerations

 

See Also

Distributed sessions
Sessions

 

See Also

Problems creating or using HTTP sessions

 

---