This paper
- Describes the setup of an environment using the Oracle 10g R2
database on RHEL 4.5 on IBM System z
- Compares the performance of importing data into the database on
the new IBM System z10 and legacy IBM System z9
This project emerged from a customer considering to migrate his core
workload on System z9 or a System z10.
- Currently, they are running some banking application workload on
several distributed servers. He plans to migrate the core workloads to
Linux (Red Hat) on System z. The application performance had to be
measured between System z9 versus System z10. The scenario is a data
import from a DS8000 storage server into an Oracle 10g R2 database
running Red Hat under z/VM 5.3 on a System z
- The size of the environment in terms of CPUs, memory, and disks,
was defined according to customer needs.
This test was 100% performed by IBM. In summary, they found that a
System z10 sustained 250 MB/sec on data imports -- not bad.
The paper is available at:
TechDocs: http://www.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101507
DeveloperWorks:
http://www.ibm.com/developerworks/linux/linux390/perf/tuning_pap_database_Oracle.html
PDF is also attached.
--
Shawn D. Wells<[email protected]>
Global System z Platform Manager
Cell: (+1) 443-534-0130 (GMT -5)
----------------------------------------------------------------------
For LINUX-390 subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
