Configure for database session persistence

Tasks

1. Create a JDBC provider.

2. Create a data source pointing to a database using our JDBC provider
   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.

   (ZOS) Point to the z/OS DB2 database containing the DB2 table for session persistence. For example...

   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 under...
   Resources > JDBC Providers > JDBC_provider > Data Sources > datasource_name

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

   (ZOS) For example:

   Database Name
   LOC1 (specify the system)

4. (ZOS) Create a DB2 table in the z/OS DB2 database that will be used for session persistence.

5. (ZOS) Configure the DB2 table for session persistence.

6. Go to the appropriate level of Session Management.

7. Under Additional Properties, click Distributed Environment Settings

8. Select and click Database.

9. Specify the Data Source JNDI name from a previous step. The database user ID and password are case-sensitive.

10. Specify the database user ID and password used to access the database and for table creation. When we created your data source, we 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.

11. Optional: (ZOS) (iSeries) Append the schema name in the session User ID field to have more than one instance of the session table.

    The session manager uses the schema name to qualify the session table name for all database operations. If only the userid is specified without the schema name, the schema name defaults to NULL and therefore a table name with NULL as the schema name, for example, NULL.SESSIONS, is created. Create multiple session tables with different schema names, other than NULL, and access them separately by modifying the user name to contain the appropriate schema name.

12. (iSeries) Retype the password for confirmation.

13. (iSeries) Configure a table space and page sizes for DB2 session databases.

14. Switch to a multirow schema.

15. Click OK.

16. To change the tuning parameters, click Custom Tuning Parameters under Additional properties.

17. Click Apply.

18. Click Save.

Subtopics

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

Related:

Distributed sessions

Sessions

Configure a JDBC provider

Configure database session persistence using scripting

HTTP session problems

Tune parameter settings (custom tuning parameters)