Can I read DB2 10 for z/OS performance topics. - Cover title. - "SG24-7042-00"--P. [4] of cover on EtoBox?

DB2 10 for z/OS performance topics. - Cover title. - "SG24-7042-00"--P. [4] of cover by Paolo Bruni; International Business Machines Corporation. International Technical Support Organization is a book available to read on EtoBox.

What is DB2 10 for z/OS performance topics. - Cover title. - "SG24-7042-00"--P. [4] of cover about?

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

Author

Paolo Bruni; International Business Machines Corporation. International Technical Support Organization

Publisher

IBM, International Technical Support Organization

Published

2011

Language

EN

ISBN

9780738435718