Db2 10 For Z Os Performance Topics eBook Download PDF

Download Db2 10 For Z Os Performance Topics full books in PDF, epub, and Kindle. Read online Db2 10 For Z Os Performance Topics ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!

DB2 10 for z/OS Performance Topics

Author: Paolo Bruni

Publisher: IBM Redbooks

Published: 2013-08-23

Total Pages: 422

ISBN-13: 0738435716

DOWNLOAD EBOOK

DB2® 10 for z/OS can reduce the total DB2 CPU demand from 5-20%, compared to DB2 9, when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types. Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS. DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs. This IBM Redbooks® publication® provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are somewhat familiar with DB2 10 for z/OS. See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions.

Book Synopsis DB2 10 for z/OS Performance Topics by : Paolo Bruni

Download or read book DB2 10 for z/OS Performance Topics written by Paolo Bruni and published by IBM Redbooks. This book was released on 2013-08-23 with total page 422 pages. Available in PDF, EPUB and Kindle. Book excerpt: DB2® 10 for z/OS can reduce the total DB2 CPU demand from 5-20%, compared to DB2 9, when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types. Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS. DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs. This IBM Redbooks® publication® provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are somewhat familiar with DB2 10 for z/OS. See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions.

Security Functions of IBM DB2 10 for z/OS

Author: Paolo Bruni

Publisher: IBM Redbooks

Published: 2011-09-14

Total Pages: 456

ISBN-13: 0738436038

DOWNLOAD EBOOK

IBM® DB2® 9 and 10 for z/OS® have added functions in the areas of security, regulatory compliance, and audit capability that provide solutions for the most compelling requirements. DB2 10 enhances the DB2 9 role-based security with additional administrative and other finer-grained authorities and privileges. This authority granularity helps separate administration and data access that provide only the minimum appropriate authority. The authority profiles provide better separation of duties while limiting or eliminating blanket authority over all aspects of a table and its data. In addition, DB2 10 provides a set of criteria for auditing for the possible abuse and overlapping of authorities within a system. In DB2 10, improvements to security and regulatory compliance focus on data retention and protecting sensitive data from privileged users and administrators. Improvements also help to separate security administration from database administration. DB2 10 also lets administrators enable security on a particular column or particular row in the database complementing the privilege model. This IBM Redbooks® publication provides a detailed description of DB2 10 security functions from the implementation and usage point of view. It is intended to be used by database, audit, and security administrators.

Book Synopsis Security Functions of IBM DB2 10 for z/OS by : Paolo Bruni

Download or read book Security Functions of IBM DB2 10 for z/OS written by Paolo Bruni and published by IBM Redbooks. This book was released on 2011-09-14 with total page 456 pages. Available in PDF, EPUB and Kindle. Book excerpt: IBM® DB2® 9 and 10 for z/OS® have added functions in the areas of security, regulatory compliance, and audit capability that provide solutions for the most compelling requirements. DB2 10 enhances the DB2 9 role-based security with additional administrative and other finer-grained authorities and privileges. This authority granularity helps separate administration and data access that provide only the minimum appropriate authority. The authority profiles provide better separation of duties while limiting or eliminating blanket authority over all aspects of a table and its data. In addition, DB2 10 provides a set of criteria for auditing for the possible abuse and overlapping of authorities within a system. In DB2 10, improvements to security and regulatory compliance focus on data retention and protecting sensitive data from privileged users and administrators. Improvements also help to separate security administration from database administration. DB2 10 also lets administrators enable security on a particular column or particular row in the database complementing the privilege model. This IBM Redbooks® publication provides a detailed description of DB2 10 security functions from the implementation and usage point of view. It is intended to be used by database, audit, and security administrators.

DB2 10 for Z/OS Performance Topics

Author: Darrell Sparks

Publisher: Createspace Independent Publishing Platform

Published: 2018-06-13

Total Pages: 392

ISBN-13: 9781724762955

DOWNLOAD EBOOK

In this book we offer the information the efficiency of DB2 10 for z/OS Performance Topics talking about the possible efficiency effects of the most important features when moving from DB2 9. We consist of efficiency dimensions made in the Rubber Area Lab and offer concerns and high-level reports. Keep in mind that results are likely to differ because the circumstances and work will be different.DB2 10 for z/OS Performance Topics offered a powerful efficiency enhancement that forced great value for IBM customers. DB2 10 for z/OS Performance Topics carries on the pattern by concentrating on further CPU benefits and efficiency enhancement through enhancements within DB2 and the collaboration with IBM System z(R) software and components. Most of CPU discount rates are integrated straight to DB2, demanding no program changes. Improvements often be effective after the REBIND in the case of fixed programs, while some enhancements require customer activities such as Information Meaning Terminology (DDL) up-dates.

Book Synopsis DB2 10 for Z/OS Performance Topics by : Darrell Sparks

Download or read book DB2 10 for Z/OS Performance Topics written by Darrell Sparks and published by Createspace Independent Publishing Platform. This book was released on 2018-06-13 with total page 392 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book we offer the information the efficiency of DB2 10 for z/OS Performance Topics talking about the possible efficiency effects of the most important features when moving from DB2 9. We consist of efficiency dimensions made in the Rubber Area Lab and offer concerns and high-level reports. Keep in mind that results are likely to differ because the circumstances and work will be different.DB2 10 for z/OS Performance Topics offered a powerful efficiency enhancement that forced great value for IBM customers. DB2 10 for z/OS Performance Topics carries on the pattern by concentrating on further CPU benefits and efficiency enhancement through enhancements within DB2 and the collaboration with IBM System z(R) software and components. Most of CPU discount rates are integrated straight to DB2, demanding no program changes. Improvements often be effective after the REBIND in the case of fixed programs, while some enhancements require customer activities such as Information Meaning Terminology (DDL) up-dates.

DB2 10 for Z/OS Performance Topics

Author: Malcolm Jeremiah

Publisher: Createspace Independent Publishing Platform

Published: 2017-08-09

Total Pages: 392

ISBN-13: 9781984358462

DOWNLOAD EBOOK

DB2 10 for z/OS Performance Topics can potentially provide significant total cost of ownership savings depending on the application mixture and type of transactions. In this book we provide the details of the performance of DB2 10 for z/OS Performance Topics discussing the possible performance impacts of the most important functions when migrating from DB2 10. We include performance measurements made in the Silicon Valley Laboratory and provide considerations and high-level estimates. Keep in mind that results are likely to vary because the conditions and work will differ.

Book Synopsis DB2 10 for Z/OS Performance Topics by : Malcolm Jeremiah

Download or read book DB2 10 for Z/OS Performance Topics written by Malcolm Jeremiah and published by Createspace Independent Publishing Platform. This book was released on 2017-08-09 with total page 392 pages. Available in PDF, EPUB and Kindle. Book excerpt: DB2 10 for z/OS Performance Topics can potentially provide significant total cost of ownership savings depending on the application mixture and type of transactions. In this book we provide the details of the performance of DB2 10 for z/OS Performance Topics discussing the possible performance impacts of the most important functions when migrating from DB2 10. We include performance measurements made in the Silicon Valley Laboratory and provide considerations and high-level estimates. Keep in mind that results are likely to vary because the conditions and work will differ.

DB2 10 for Z/OS Performance Topics

Author: Paolo Bruni

Publisher:

Published: 2011

Total Pages: 0

ISBN-13:

DOWNLOAD EBOOK

DB2℗ʼ 10 can reduce the total DB2 CPU demand from 5-20% when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types. Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS. DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs. This IBM Redbooks℗ʼ publication℗ʼ provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are somewhat familiar with DB2 10 for z/OS. See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions.

Book Synopsis DB2 10 for Z/OS Performance Topics by : Paolo Bruni

Download or read book DB2 10 for Z/OS Performance Topics written by Paolo Bruni and published by . This book was released on 2011 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: DB2℗ʼ 10 can reduce the total DB2 CPU demand from 5-20% when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types. Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS. DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs. This IBM Redbooks℗ʼ publication℗ʼ provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are somewhat familiar with DB2 10 for z/OS. See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions.

DB2 9 for z/OS Performance Topics

Author: Paolo Bruni

Publisher: IBM Redbooks

Published: 2012-09-28

Total Pages: 424

ISBN-13: 0738488836

DOWNLOAD EBOOK

DB2 9 for z/OS is an exciting new version, with many improvements in performance and little regression. DB2 V9 improves availability and security, as well as adds greatly to SQL and XML functions. Optimization improvements include more SQL functions to optimize, improved statistics for the optimizer, better optimization techniques, and a new approach to providing information for tuning. V8 SQL procedures were not eligible to run on the IBM System z9 Integrated Information Processor (zIIP), but changing to use the native SQL procedures on DB2 V9 makes the work eligible for zIIP processing. The performance of varying length data can improve substantially if there are large numbers of varying length columns. Several improvements in disk access can reduce the time for sequential disk access and improve data rates. The key DB2 9 for z/OS performance improvements include reduced CPU time in many utilities, deep synergy with IBM System z hardware and z/OS software, improved performance and scalability for inserts and LOBs, improved SQL optimization, zIIP processing for remote native SQL procedures, index compression, reduced CPU time for data with varying lengths, and better sequential access. Virtual storage use below the 2 GB bar is also improved. This IBM Redbooks publication provides an overview of the performance impact of DB2 9 for z/OS, especially performance scalability for transactions, CPU, and elapsed time for queries and utilities. We discuss the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are familiar with DB2 V9. See DB2 9 for z/OS Technical Overview, SG24-7330, for an introduction to the new functions.

Book Synopsis DB2 9 for z/OS Performance Topics by : Paolo Bruni

Download or read book DB2 9 for z/OS Performance Topics written by Paolo Bruni and published by IBM Redbooks. This book was released on 2012-09-28 with total page 424 pages. Available in PDF, EPUB and Kindle. Book excerpt: DB2 9 for z/OS is an exciting new version, with many improvements in performance and little regression. DB2 V9 improves availability and security, as well as adds greatly to SQL and XML functions. Optimization improvements include more SQL functions to optimize, improved statistics for the optimizer, better optimization techniques, and a new approach to providing information for tuning. V8 SQL procedures were not eligible to run on the IBM System z9 Integrated Information Processor (zIIP), but changing to use the native SQL procedures on DB2 V9 makes the work eligible for zIIP processing. The performance of varying length data can improve substantially if there are large numbers of varying length columns. Several improvements in disk access can reduce the time for sequential disk access and improve data rates. The key DB2 9 for z/OS performance improvements include reduced CPU time in many utilities, deep synergy with IBM System z hardware and z/OS software, improved performance and scalability for inserts and LOBs, improved SQL optimization, zIIP processing for remote native SQL procedures, index compression, reduced CPU time for data with varying lengths, and better sequential access. Virtual storage use below the 2 GB bar is also improved. This IBM Redbooks publication provides an overview of the performance impact of DB2 9 for z/OS, especially performance scalability for transactions, CPU, and elapsed time for queries and utilities. We discuss the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are familiar with DB2 V9. See DB2 9 for z/OS Technical Overview, SG24-7330, for an introduction to the new functions.

IBM DB2 11 for z/OS Buffer Pool Monitoring and Tuning

Author: Jeff Berger

Publisher: IBM Redbooks

Published: 2014-07-31

Total Pages: 64

ISBN-13: 0738453749

DOWNLOAD EBOOK

IBM® DB2® buffer pools are still a key resource for ensuring good performance. This has become increasingly important as the difference between processor speed and disk response time for a random access I/O widens in each new generation of processor. An IBM System z® processor can be configured with large amounts of storage, which if used wisely, can help compensate by using storage to avoid synchronous I/O. Several changes in buffer pool management have been provided by DB2 10 and DB2 11. The purpose of this IBM RedpaperTM is to cover the following topics: Describe the functions of the DB2 11 buffer pools Introduce a number of matrixes for read and write performance of a buffer pool Provide information about how to set up and monitor the DB2 buffer pools The paper is intended to be read by DB2 system administrators, but it might be of interest to any IBM z/OS® performance specialist. It is assumed that the reader is familiar with DB2 and performance tuning. In this paper, we also assume that you are familiar with DB2 11 for z/OS performance. See DB2 11 for z/OS Technical Overview, SG24-8180; and DB2 11 for z/OS Performance Topics, SG24-8222, for more information about DB2 11 functions and their performance.

Book Synopsis IBM DB2 11 for z/OS Buffer Pool Monitoring and Tuning by : Jeff Berger

Download or read book IBM DB2 11 for z/OS Buffer Pool Monitoring and Tuning written by Jeff Berger and published by IBM Redbooks. This book was released on 2014-07-31 with total page 64 pages. Available in PDF, EPUB and Kindle. Book excerpt: IBM® DB2® buffer pools are still a key resource for ensuring good performance. This has become increasingly important as the difference between processor speed and disk response time for a random access I/O widens in each new generation of processor. An IBM System z® processor can be configured with large amounts of storage, which if used wisely, can help compensate by using storage to avoid synchronous I/O. Several changes in buffer pool management have been provided by DB2 10 and DB2 11. The purpose of this IBM RedpaperTM is to cover the following topics: Describe the functions of the DB2 11 buffer pools Introduce a number of matrixes for read and write performance of a buffer pool Provide information about how to set up and monitor the DB2 buffer pools The paper is intended to be read by DB2 system administrators, but it might be of interest to any IBM z/OS® performance specialist. It is assumed that the reader is familiar with DB2 and performance tuning. In this paper, we also assume that you are familiar with DB2 11 for z/OS performance. See DB2 11 for z/OS Technical Overview, SG24-8180; and DB2 11 for z/OS Performance Topics, SG24-8222, for more information about DB2 11 functions and their performance.

DB2 9 for Z/OS Performance Topics

Author: Paolo Bruni

Publisher:

Published: 2007

Total Pages:

ISBN-13:

DOWNLOAD EBOOK

Book Synopsis DB2 9 for Z/OS Performance Topics by : Paolo Bruni

Download or read book DB2 9 for Z/OS Performance Topics written by Paolo Bruni and published by . This book was released on 2007 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt:

DB2 10 for z/OS Technical Overview

Author: Paolo Bruni

Publisher: IBM Redbooks

Published: 2014-07-16

Total Pages: 724

ISBN-13: 0738435112

DOWNLOAD EBOOK

IBM® DB2® Version 10.1 for z/OS® (DB2 10 for z/OS or just DB2 10 throughout this book) is the fourteenth release of DB2 for MVSTM. It brings improved performance and synergy with the System z® hardware and more opportunities to drive business value in the following areas: Cost savings and compliance through optimized innovations DB2 10 delivers value in this area by achieving up to 10% CPU savings for traditional workloads and up to 20% CPU savings for nontraditional workloads, depending on the environments. Synergy with other IBM System z platform components reduces CPU use by taking advantage of the latest processor improvements and z/OS enhancements. Streamline security and regulatory compliance through the separation of roles between security and data administrators, column level security access, and added auditing capabilities. Business insight innovations Productivity improvements are provided by new functions available for pureXML®, data warehousing, and traditional online TP applications Enhanced support for key business partners that allow you to get more from your data in critical business disciplines like ERP Bitemporal support for applications that need to correlate the validity of data with time. Business resiliency innovations Database on demand capabilities to ensure that information design can be changed dynamically, often without database outages DB2 operations and utility improvements enhancing performance, usability, and availability by exploiting disk storage technology. The DB2 10 environment is available either for brand new installations of DB2, or for migrations from DB2 9 for z/OS or from DB2 UDB for z/OS Version 8 subsystems. This IBM Redbooks® publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating or skip migrating to DB2 10.

Book Synopsis DB2 10 for z/OS Technical Overview by : Paolo Bruni

Download or read book DB2 10 for z/OS Technical Overview written by Paolo Bruni and published by IBM Redbooks. This book was released on 2014-07-16 with total page 724 pages. Available in PDF, EPUB and Kindle. Book excerpt: IBM® DB2® Version 10.1 for z/OS® (DB2 10 for z/OS or just DB2 10 throughout this book) is the fourteenth release of DB2 for MVSTM. It brings improved performance and synergy with the System z® hardware and more opportunities to drive business value in the following areas: Cost savings and compliance through optimized innovations DB2 10 delivers value in this area by achieving up to 10% CPU savings for traditional workloads and up to 20% CPU savings for nontraditional workloads, depending on the environments. Synergy with other IBM System z platform components reduces CPU use by taking advantage of the latest processor improvements and z/OS enhancements. Streamline security and regulatory compliance through the separation of roles between security and data administrators, column level security access, and added auditing capabilities. Business insight innovations Productivity improvements are provided by new functions available for pureXML®, data warehousing, and traditional online TP applications Enhanced support for key business partners that allow you to get more from your data in critical business disciplines like ERP Bitemporal support for applications that need to correlate the validity of data with time. Business resiliency innovations Database on demand capabilities to ensure that information design can be changed dynamically, often without database outages DB2 operations and utility improvements enhancing performance, usability, and availability by exploiting disk storage technology. The DB2 10 environment is available either for brand new installations of DB2, or for migrations from DB2 9 for z/OS or from DB2 UDB for z/OS Version 8 subsystems. This IBM Redbooks® publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating or skip migrating to DB2 10.

IBM DB2 11 for Z/Os Performance Topics

Author: Ibm Redbooks

Publisher:

Published: 2014-07-25

Total Pages:

ISBN-13: 9780738439679

DOWNLOAD EBOOK

IBM DB2 11 for z/OS focuses on CPU savings and performance improvement through innovations within DB2 and the synergy with IBM System z hardware and software. Most of CPU reductions are built in directly to DB2, requiring no application changes. Enhancements often take effect after the REBIND in the case of static applications, while some enhancements require user actions such as Data Definition Language (DDL) updates. This IBM Redbooks publication provides the details of the performance of DB2 11 for z/OS, discussing the possible performance impacts of the most important functions when migrating from DB2 10. It includes performance measurements made in the Silicon Valley Laboratory and provide considerations and high-level estimates. It assumes familiarity with DB2 11 for z/OS. --

Book Synopsis IBM DB2 11 for Z/Os Performance Topics by : Ibm Redbooks

Download or read book IBM DB2 11 for Z/Os Performance Topics written by Ibm Redbooks and published by . This book was released on 2014-07-25 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt: IBM DB2 11 for z/OS focuses on CPU savings and performance improvement through innovations within DB2 and the synergy with IBM System z hardware and software. Most of CPU reductions are built in directly to DB2, requiring no application changes. Enhancements often take effect after the REBIND in the case of static applications, while some enhancements require user actions such as Data Definition Language (DDL) updates. This IBM Redbooks publication provides the details of the performance of DB2 11 for z/OS, discussing the possible performance impacts of the most important functions when migrating from DB2 10. It includes performance measurements made in the Silicon Valley Laboratory and provide considerations and high-level estimates. It assumes familiarity with DB2 11 for z/OS. --