Database settings: WAS v5.1

Database settings

Use this page to specify the settings for database session support.
To view this administrative console page, click Servers > Application Servers > server > Web Container > Session Management > Distributed Environment Settings > Database.

Configuration tab

Datasource JNDI Name Specifies the datasource description
The JNDI name of the non-XA enabled data source from which Session Management obtains database connections. For example, if the JNDI name of the datasource is "jdbc/sessions", specify "jdbc/sessions." The data source represents a pool of database connections and a configuration for that pool (such as the pool size). The data source must already exist as a configured resource in the environment.

User ID Specifies the user ID for database access

Password Specifies the password for database access

Confirm Password Specifies the password a second time to ensure it recorded correctly.

DB2 Row Size Specifies the tablespace page size configured for the sessions table, if using a DB2 database. Possible values are 4, 8, 16, and 32 kilobytes (K). The default row size is 4K.
The default row size is 4K. In DB2, it can be updated to a larger value. This can help database performance in some environments. When this value is other than 4, specify Table Space Name to use. For 4K pages, the Table Space Name is optional.

Table Space Name Specifies that tablespace to be used for the sessions table.
This value is required when the DB2 Page Size is other than 4K.

Multi row schema Specifies that each instance of application data be placed in a separate row in the database, allowing larger amounts of data to be stored for each session. This action can yield better performance in certain usage scenarios. If using multirow schema is not enabled, instances of application data can be placed in the same row.

Datasource JNDI Name	Specifies the datasource description The JNDI name of the non-XA enabled data source from which Session Management obtains database connections. For example, if the JNDI name of the datasource is "jdbc/sessions", specify "jdbc/sessions." The data source represents a pool of database connections and a configuration for that pool (such as the pool size). The data source must already exist as a configured resource in the environment.
User ID	Specifies the user ID for database access
Password	Specifies the password for database access
Confirm Password	Specifies the password a second time to ensure it recorded correctly.
DB2 Row Size	Specifies the tablespace page size configured for the sessions table, if using a DB2 database. Possible values are 4, 8, 16, and 32 kilobytes (K). The default row size is 4K. The default row size is 4K. In DB2, it can be updated to a larger value. This can help database performance in some environments. When this value is other than 4, specify Table Space Name to use. For 4K pages, the Table Space Name is optional.
Table Space Name	Specifies that tablespace to be used for the sessions table. This value is required when the DB2 Page Size is other than 4K.
Multi row schema	Specifies that each instance of application data be placed in a separate row in the database, allowing larger amounts of data to be stored for each session. This action can yield better performance in certain usage scenarios. If using multirow schema is not enabled, instances of application data can be placed in the same row.