Database settings

Use this page to specify the settings for database session support.

To view this administrative console page, click Servers > Application servers > server_name > Web container settings > Session management > Distributed environment settings > Database.

Configuration tab

Datasource JNDI name

Specifies the datasource description.

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

User ID

[AIX HP-UX Linux Solaris Windows] [iSeries]

Specifies the user ID for database access.

Password

[AIX HP-UX Linux Solaris Windows] [iSeries]

Specifies the password for database access.

DB2 row size

[AIX HP-UX Linux Solaris Windows] [iSeries]

Specifies the table space page size configured for the sessions table, if using a DB2 database. Possible values are 4, 8, 16, and 32 kilobytes (KB). The default row size is 4KB.

The default row size is 4KB. 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, you must specify table space name to use this property. For 4KB pages, the table space name is optional.

Table space name

[AIX HP-UX Linux Solaris Windows] [iSeries]

Specifies that table space to be used for the sessions table.

This value is required when the DB2 page size is other than 4KB.

Use 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 multi row schema is not enabled, instances of application data can be placed in the same row.




Related concepts
Distributed sessions
Related tasks
Configuring for database session persistence
Reference topic Reference topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 31, 2013 4:28:44 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-nd-mp&topic=database_settings
File name: uprs_rdatabase_settings.html