Oracle Database on Linux on System z - Disk I/O Connectivity Study

This study provides guidelines for disk configuration and tuning hints with regard to ECKD and FCP disk devices, and specifically for the Oracle standalone database using a transactional workload (OLTP) in an LPAR from System z 196 EC. It also compares the behavior of Oracle release 11g with release 10g.

The objective of this paper is to help you decide which disk type is appropriate and to describe how to optimize disk throughput rates.

View
Creation date
December 2012

BI Oracle Workloads

Many customers have successfully consolidated Oracle databases on the mainframe. Linux on System z provides the strategic platform for Oracle on the highly scalable servers of the IBM System z and zEnterprise. The consolidation of distributed Oracle servers explores a large potential for savings on software license cost and operational cost, such as service personnel, power, space, network cost, and air-condition.

This presentation addresses some of the architecture, services, pitfalls, and migration considerations, based on practical experience with large scale consolidations scenarios.

View
Creation date
November 2012

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

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
Creation date
April 2011

Performance considerations for databases on Linux on System z

Presentation abstract
View
Creation date
June 2010

DB2 Database Partitioning for Linux on System z

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
Creation date
November 2009

Performance of environments using DB2 Connect Enterprise Edition

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
Creation date
February 2008

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

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:
View
Creation date
December 2007

Performance of an Oracle 10g R2 Database Import Environment

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
Creation date

May 2009

Team

Please address any comments to the performance team: linux390@de.ibm.com