DB2 Connect Enterprise Edition V9.1 for Linux® on zSeries
(DB2 Connect) connects LAN-based systems and their applications
to the company's mainframe host DB2 databases. Additionally,
DB2 Connect can be used in a three tier environment and can
act as a gateway concentrating large numbers of SQL connections
from various clients to a fewer, well-defined number of connections
to the DB2 database on z/OS.
This paper shows the results from our performance measurements
using DB2 Connect in a two and a three tier environment. The
scaling behavior from DB2 Connect for a various number of
CPUs and memory was examined.
Additionaly, this report focuses on the connection concentrator
functions of DB2 Connect. This feature allows a controlled
load on the database on z/OS from a DB2 Connect server.
This paper demonstrates data server scalability for DB2 9
running on IBM System z with Linux. It shows:
A high volume of transactions can be processed on a large
database.
The database size can grow by a factor of six to approximately
1.4 TB with no marked performance change.
DB2 9 performs very well when running on a System z LPAR
or under z/VM.
The paper captures the best practices for deploying IBM DB2
9 for mission critical online transaction processing (OLTP)
workloads in their product environment.
