OS Monitoring Summary | Efficient I/O managment

DB2 performance considerations

WebSphere Commerce is considered an On-Line Transaction Processing (OLTP) application. Therefore, the database should be tuned for an OLTP application. Typical characteristics of an OLTP application are:

• It has frequent insert or update activity.
• There are a high number of users accessing the database.
• SQL executing against the database is quick and relatively simple.

The following sections cover some of the specifics related to DB2 UDB V8.1 for distributed platforms. A more detailed document on DB2 for distributed platforms and WebSphere Commerce can be found at the WebSphere Commerce Developer Domain site

Considerations for the physical environment are related to how the data is actually spread among the disks and how the memory is managed for the databases, so that I/O and memory always attract most of the developers' and testers' concentration in implementing WebSphere Commerce.