Configuring for database session persistence

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

  1. Create and configure a JDBC provider.
  2. 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.

  3. 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.
  4. Go to the appropriate level of Session Management.
  5. Under Additional Properties, click Distributed Environment Settings
  6. Select and click Database. The database user ID and password are case-sensitive.
  7. Specify the Data Source JNDI name from a previous step.
  8. Specify the database user ID and password for accessing the database. 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.
  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 under Additional properties and select a setting or customize a setting.
  14. Click Apply.
  15. Click Save.



In this information ...


Related concepts
Related reference

IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 30, 2013 4:53:43 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-base-dist&topic=tpercnfp
File name: tprs_cnfp.html