DB2 Performance
01/2010 *Best Practice for DB2 on AIX 6.1 for POWER Systems (SG24-7821-00) 
*This IBM® Redbooks® publication presents a best practices guide for DB2® and InfoSphere™ Warehouse performance on a AIX® 6L with Power Systems™ virtualization environment. It covers Power hardware features such as PowerVM™, multi-page support, Reliability, Availability, and Serviceability (RAS) and how to best exploit them with DB2 LUW workloads for both transactional and data warehousing systems
10/2008 *Best Practices: DB2 Workload Management *DB2 Workload Management helps prevent, detect, and resolve conflicting resource requirements on a DB2 data server based on defined business objectives. This paper introduces you to the current best practices for DB2 workload manager on your DB2 Version 9.5 for Linux, UNIX, and Windows data server which can be used to help you meet your business objectives for the work being executed on DB2 data servers. The best practices presented here are based on IBM field experience in benchmark and proof-of-concept exercises as well as feedback from customer adoptions of DB2 Version 9.5.
10/2008 *Best Practice: Tuning and Monitoring Database System Performance *See best practices for the performance evolution of a Data Server. From important principles of initial hardware and software configuration to monitoring techniques that help you understand system performance under both operational and troubleshooting conditions. For troubleshooting performance problems, this paper provide a step-wise, methodical method for determining the problem.
05/2008 Best Practices: Writing and Tuning Queries for Optimal Performance Learn best practices for minimizing the impact of SQL statements on DB2 database performance. This paper focuses on good fundamental writing and tuning practices that can be widely applied to help improve DB2 database performance.
06/2006 IBM DB2 Enterprise 9 performance with POWER5+ and AIX 5L multipage support Learn how IBM® DB2® 9 for Linux®, UNIX®, and Windows® (DB2) exploits multiple page sizes. With the introduction of the POWER5+™ processor architecture, the IBM AIX 5L™ operating system added support for a new 64-kilobyte page with properties that are similar to the current default 4-kilobyte pages. In addition, AIX 5L Version 5.3 TL04 also introduced a new 16-gigabyte huge-page feature for this hardware architecture. DB2 9 automatically exploits the 64-kilobyte pages to deliver high performance for database applications on this platform. In addition, DB2 also supports the enablement of 16-gigabyte huge pages.
DB2 Performance in Virtualized Environments
10/2009 Scaling DB2 9.7 in a Red Hat® Enterprise Virtualization Environment* *This paper describes the performance and scaling of DB2 9.7 running in Red Hat Enterprise Linux 5.4 guests on a Red Hat Enterprise Linux 5.4 host with the KVM hypervisor.
12/2008 SAP® SD Benchmark using DB2 running Red Hat® Enterprise Linux® 5 Virtualization on IBM System x3850 M2* *Comparison of bare metal versus para-virtualized guest performance using SAP SD 2-tier benchmark with RHEL 5.2 XEN 3.1 and DB2 9.5
06/2007 Implementing System p virtualization with DB2 and WebSphere using IBM Enterprise Workload Management* *This article describes how to create a solution that uses these features in a Java™ 2 Platform, Enterprise Edition (J2EE) environment to meet and exceed service-level agreement (SLA) targets with stable, predictable response times. Compared to a native configuration that underutilizes system resources, a four-fold improvement in response time is possible.
DB2 Performance with Deep Compression
10/2006 Row compression in DB2 9 - Analysis of a DSS database environment* *Row compression is a new feature of IBM® DB2® 9 that yields storage capacity savings. This article examines the storage savings and performance impact of this feature. It describes the workload characteristics and environments in which row compression will thrive, as well as providing general guidelines that you can follow to efficiently use this feature.
DB2 Performance with SAP
SAP Business Intelligence with IBM DB2 for LUW IBM DB2 for Linux, UNIX and Windows offers unique features like 'Multidimensional Clustering' (MDC) and 'Database Partitioning' (DPF) for data warehouse/OLAP-like workloads. Read on to find out how these features are used by SAP Business Intelligence/SAP Business Warehouse.
04/2009 Implementing SAP NetWeaver Business Warehouse (BW) on IBM® InfoSphere Warehouse™* *This paper provides guidelines and recommendations for running SAP NetWeaver BW on IBM® InfoSphere Warehouse™. It provides an overview of the InfoSphere Balanced Warehouse and of SAP NetWeaver BW. It provides hardware sizing recommendations for SAP NetWeaver BW on InfoSphere Balanced Warehouse. It discusses the IBM® DB2® for Linux®, UNIX® and Windows® features exploited in SAP NetWeaver BW, proposes an optimal DB2 LUW DPF database layout and data distribution and summarizes DB2 configuration parameter settings for SAP NetWeaver BW
03/2009 Performance Optimization with SAP on DB2 for Linux, UNIX, and Windows System Copy
This presentation covers advanced SAP system copy techniques, considerations for DB2 database layout and tuning as well as unique DB2 capabilities. In addition, you acquire advanced knowledge about how you migrate your SAP system to IBM DB2. The presentation covers both general performance tuning options for export and import including the impact of Unicode on system copy performance as well as specific tuning options to migrate to DB2.
12/2008 SAP® SD Benchmark using DB2 running Red Hat® Enterprise Linux® 5 Virtualization on IBM System x3850 M2* *Comparison of bare metal versus para-virtualized guest performance using SAP SD 2-tier benchmark with RHEL 5.2 XEN 3.1 and DB2 9.5
DB2 Performance with Storage
06/2009 IBM DB2 9.5 Performance and Scalability on RHEL5 with NFS and FCP using NetApp FAS or IBM N series Storage System This paper is based on a joint study between NetApp and IBM and offers tuning recommendations for running DB2 9.5 databases over NFS and FCP on NetApp FAS or IBM N series system storage in a RHEL5 environment. A series of tests using an Online Transaction Processing (OLTP) workload were run to determine how various tunings affect performance, compare the level of performance NFS and FCP protocol can offer, and demonstrate scalability of DB2 as more CPU and memory resources were equipped.
DB2 Performance with pureXML
04/2010 *Intel and IBM redefine the limits of Data Warehousing*DB2 9.7 demonstrates performance with a 10 TB XML data warehouse using Intel Xeon 7540 EX processors (Nehalem EX with 4 sockets/32 cores) and IBM Storage DS8700 on Linux RHEL 5.4. Article also includes a TPoX OLTP result with Nehalem EX server achieving 14,000 TPoX transaction per second with 1 TB XML data on Linux SLES 10 SP2.
08/2009 Using DB2 pureXML and BladeCenter JS43 Server for high-performance transaction processing XML has become the standard for data exchange, service-oriented architectures (SOAs), message-based transaction processing and much more. This paper describes how the latest version of DB2, namely DB2 9.7, when combined with an IBM BladeCenter JS43 server, delivers outstanding XML transaction-processing results using the TPoX 2.0 workload.
06/2009 Intel and IBM Collaborate to boost performance and power consumption* *DB2 9.7 with Intel Xeon 5570 processors (Nehalem EP with 2 sockets/8 cores) achieved 5139 TPoX transaction per second (308,384 transactions per minutes) running Linux SLES 10 SP2 with 1 TB XML data using the TPoX 1.2 workload. It delivers out-of-the-box performance without hand tuning, and show great performance and power improvement on the 5500 series.
05/2009 15 best practices for pureXML performance in DB2 9 and 9.5 While most existing performance guidelines for DB2 also apply to XML data, this article provides additional XML-specific performance tips.
04/2009 Enhance business insight and scalability of XML data with new DB2 V9.7 pureXML features New features in DB2 9.7 enable administrators to leverage new database design options for XML data, including hash partitioning (database partitioning), range partitioning (table partitioning), and multi-dimensional clustering. These options can help companies accommodate large data volumes, exploit parallel processing environments, simplify the addition or removal of time-sensitive data, and speed performance of many types of queries. Used individually or together, these DB2 design options enable organizations to incorporate XML data into their relational data warehouses; create operational data stores for XML messages, documents, and data feeds; and improve scalability of XML transaction processing workloads.
03/2009 Taming a Terabyte of XML Data Using DB2's pureXML capabilities and Intel multi-core CPUs, Intel and IBM executed the industry's first terabyte XML database benchmark to demonstrate that high-end transaction processing over a terabyte of XML data is no longer wishful thinking. This article describes these performance tests, the hardware used, the DB2 configuration, and the results and lessons learned. Various DB2 technologies proved to be of critical importance, including deep compression, automatic storage, self-tuning memory, and, of course, pureXML. The results quantify DB2's multi-user scalability with Linux on Intel quad-core and six-core processors (Intel Xeon Processor 7300 and 7400 Series).
04/2008 DB2® 9.5 pureXML Performance Trends on the Next Generation Quad-Core Intel® Xeon® Processor* *This paper will showcase the scalability and performance of IBM* DB2 9.5 on the newest Quad-Core Intel® Xeon® processor, compared to IBM DB2 9 on Dual-Core Intel® MP System. You will be able to observe how the new DB2 9.5 pureXML features, in combination with the Quad-Core Intel® Xeon® processor delivers excellent performance and provides real measurable benefits. We will review the new IBM DB2 9.5 pureXML features, the new 45nm Hi-k next generation Intel® Core™ microarchitecture, and the resulting scalability of a native XML application on the latest Quad-Core Intel® Xeon® processor. To show the real benefits of the next generation Quad-Core Intel® Xeon® processor 7300 Series with the latest IBM DB2 9.5, we will be comparing this combination to the Dual-Core Intel® Xeon® Processor 7100 Series running DB2 9.
01/2007 DB2 9 XML performance characteristics - Use the TPoX benchmark to test the performance of a simulated brokerage scenario Learn about the performance and scalability characteristics of a simulated securities brokerage transaction processing environment using DB2® 9 XML, IBM POWER5+, AIX 5.3, and TotalStorage DS8100. This scenario includes use of the FIXML schema, a financial industry standard. The Transaction Processing over XML (TPoX) database benchmark is used to obtain the results discussed in this article.
12/2006 A performance comparison of DB2 9 pureXML with CLOB and shredded XML storage Like other databases, the DB2® V8 XML Extender offers two storage and access models for XML: XML documents can be stored intact as unparsed text in CLOB columns, or they can be mapped and shredded to a set of relational tables. Both options have known performance limitations. The new pureXML™ technology in DB2® 9 seeks to overcome these limitations by storing and querying XML in its inherent hierarchical format. This article describes a series of measurements to characterize the cases in which pureXML does or doesn't provide a performance benefit, and to quantify the performance difference to CLOB or shredded storage.
10/2006 Exploit XML indexes for XML query performance in DB2 9 XML indexes are essential for high query performance, but their usage for query evaluation depends on how query predicates are formulated. This article presents a set of guidelines for writing XML queries and creating XML indexes in a consistent manner so that indexes speed up your queries as expected. Also learn what to look for in XML query execution plans to detect performance issues, and find out how to fix them.
