Filter
Top Products
15
WEBSPHERE PORTAL V6.1 TUNING GUIDE
Database Tuning
D A T A S O U R C E T U N I N G F O R D B 2
Multiple databases are used to hold information in WebSphere Portal V6.1. We used six
separate DB2 databases, each representing a separate database domain and having their
own datasources. These are:
Table 7: DB2 Database Domains
Database Database name Datasource name
Release
release reldbDS
Community
community commdbDS
Customization
custom cusdbDS
Feedback
fdbkdb fdbkdbDS
Likeminds
Lmdb lmdbDS
JCR
jcrdb jcrdbDS
All datasources are configured in a similar manner by logging on to the WebSphere
Application Server administrative console. For the prepared statement cache size, the path
is Resources → JDBC Providers → provider name → Data Sources → datasource name.
The provider name and datasource name are based on the names selected for that
database during the database transfer step. Look for the parameter Statement cache size.
For the connection pool settings, the path in the WebSphere Application Server
administrative console is Resources → JDBC Providers → Provider name → Data Sources
→ Datasource name → Connection Pools. The settings are Minimum connections and
Maximum connections.
The default settings were used for the prepared statement cache size, and connection pool
minimum and maximum sizes.
D B 2 D A T A B A S E S E R V E R T U N I N G
WebSphere Portal V6.1 uses database servers for core functionality. In our measurement
environment, we used DB2 database server for the Portal application. The LDAP server,
IBM Tivoli Directory Server also included a DB2 database as a repository, but it is largely
unseen and was operated as an out of box configuration.
We recommend using a remote database server for the largest capacity. For our
measurements we used IBM DB2 Enterprise Edition V9.1 fixpack 5 as our database server.
WebSphere Portal V6.1 uses the concept of Database domains to designate either groups
of tables belonging to one domain, or even entirely separate databases to store the data
specific to each domain.