Database server

This paper presents building and running Oracle Real Application Clusters (Oracle RAC) 10g Release 2 on Novell SUSE Linux Enterprise Server (SLES 10) SP2 with an IBM System z10.

The paper describes the detailed system setup and several tests with various varying parameters to determine optimal values and performance trade-offs.

View

Oracle Real Application Clusters on Linux on IBM System z: Set up and network performance tuning

Creation date

April 2011

Back to top

Presentation abstract

• Special kernel parameter settings
• File system considerations
• Database specific I/O options
• Choice of I/O schedulers
• ECKD and SCSI disks
• Striped volumes with logical volume manager (LVM) and storage pool striping
• Using the storage server with optimal response times

View

Performance considerations for databases on Linux on System z

Creation date

June 2010

Back to top

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.

View

DB2 Database Partitioning for Linux on System z

Creation date

November 2009

Back to top

DB2 Connect Enterprise Edition V9.1 for Linux® on System z (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 for various numbers of CPUs and memory sizes 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.

View

Performance of environments using DB2 Connect Enterprise Edition

Creation date

February 2008

Back to top

This paper demonstrates data server scalability for DB2 9 running on IBM System z with Linux.

The paper captures the best practices for deploying IBM DB2 9 for mission critical online transaction processing (OLTP) workloads in their product environment.

This paper shows that:

• 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.

View

Performance and scalability of a large OLTP workload with DB2 9 for Linux on System z

Creation date

December 2007

Back to top

This paper describes a specific customer setup of importing data into an Oracle 10g R2 database running Red Hat Linux under z/VM 5.3 on a System z. It compares the performance of the import process on System z9 with System z10.

We could show an improvement of a factor of two when migrating from System z9 to System z10. The factor of two is based on the compute intensive workload which was neither burdened by heavy network load nor by the storage server which handled the data rates of up to 250 MB/sec easily.

This very impressive result helps confirm that upgrading to the IBM System z10 significantly enhances the capabilities of enterprise IT customers.

View

Performance of an Oracle 10g R2 Database Import Environment

Creation date

May 2009

Back to top