Environmental Setup for the DB2 9 for System z on Linux Tests

To emulate a customer-like environment we configured our DB2 system, server software, Linux kernel parameters, and the database.

For our DB2 system, the LPAR environment consisted of one LPAR on an 18-way IBM® System z9® Enterprise Class (z9® EC), model 2094-S18 equipped with eight CPUs and 59 GB of main memory.

The guest z/VM® environment was similarly configured, but had an additional 1 GB of memory for expanded storage. The client workstations were connected via a 1 GB Ethernet LAN.

The storage server was a DS8000®. The disk drive modules had a size of 73 GB each and 15000 RPMs. They were configured as one RAID5 array per rank. Each rank has either seven (plus one spare drive) or eight physical disks, so that a total of 120 disk drives were used. For the Linux® operating system, DB2® application, and DB2 logging we used one rank with ECKD 3390 mod 9 disks connected via 8 FICON® express channels. For the database data disks we used 15 Ranks of FCP disks connected Point to Point via eight FPC 2 Gb/sec channels.

Figure 1. System setup for the OLTP workload on the large database
db202

Server software

Table 1 lists the software and levels used for this test.

Table 1. Software used
Software Version
SUSE Linux Enterprise Server 64-bit 10
IBM DB2 Enterprise 9.11
z/VM 5.2.0 Service Level 0602 (64-bit)

1 DB2 9.1 FP1 or later is recommended because this level of Linux has the fix for STMM to grow and shrink shared memory.