This paper provides a set of guidelines for implementing
a data warehouse on a System z with IBM InfoSphere Warehouse,
the Linux operating system, and IBM System Storage DS8300.
It presents one particular System z9 implementation and provides
performance results to illustrate the validity of the configuration.
The paper also demonstrates how these guidelines are scalable
to a System z10.
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.
Additionally, 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.
