Introduction to the DB2 9 for System z on Linux Tests

The objective of our DB2 performance tests was to showcase performance and scalability of DB2® running on Linux® on System z™ using an OLTP workload.

DB2 9 is an extremely powerful and flexible data server that offers industry-leading OLTP performance. It is highly optimized for each of the operating system environments it supports. This paper describes the behavior of DB2 in a high-throughput transactional environment on a "mid-sized" IBM® System z9™ system. It describes the best practices used to configure the data server by including a description of the hardware configuration, operating system tuning, and database implementation. This paper also demonstrates the impact on performance as a database grows over time. The amount of data accessed per transaction remained the same to emulate typical customer-like scenarios where the most recent data is referenced. Finally, the paper compares the performance of DB2 running on a System z LPAR versus a guest z/VM®.