Configuring for database session persistence

Why and when to perform this task

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

Steps for this task

  1. Creating and configuring a JDBC provider using the administrative console
  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.

    Example configuration for session persistence:

    Name Sessions
    JNDI Name jdbc/sessions
    Container managed persistence Selected
    Component-managed Authentication Alias CELL/jaasalias
    Container-managed Authentication Alias CELL/jaasalias

  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.

    For example:

    Database Name LOC1 (specify your system)

  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.

Related concepts
Distributed sessions
Sessions
Related reference
Database settings
Problems creating or using HTTP sessions
Multirow schema considerations



Searchable topic ID:   tpercnfp
Last updated: Jun 21, 2007 4:55:42 PM CDT    WebSphere Application Server Network Deployment, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/tprs_cnfp.html

Library | Support | Terms of Use | Feedback