You can configure a database to collect session data for
database session persistence.
About this task
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.
- Specify the Data Source JNDI name from a previous step.
The database user ID and password are case-sensitive.
- Specify the database user ID and password that is 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.
- Retype the password for confirmation.
- Configure a table space and page sizes for DB2 session
databases.
- Switch to a multirow
schema.
- Click OK.
- If you want to change the tuning parameters, click Custom
Tuning Parameters under Additional properties.
- Click Apply.
- Click Save.