Business Value of DB2 for z/OS : IBM DB2 Analytics Accelerator and Optimizer.
Title:
Business Value of DB2 for z/OS : IBM DB2 Analytics Accelerator and Optimizer.
Author:
Campbell, John.
ISBN:
9781583477588
Personal Author:
Physical Description:
1 online resource (145 pages)
Contents:
Cover -- Copyright -- Contents -- About the Authors -- Foreword by Don Haderle -- Introduction by Surekha Parekh -- 30 Years of Innovation -- The Vision of DB2 -- Revolution in IBM DB2 Performance: IBM DB2 Analytics Accelerator by Namik Hrle, Ruiping Li, and Wolfgang Hengstler -- Abstract -- Objectives -- Introduction -- What Is Business Analytics? -- How Business Analytics Can Help Your Organization -- Key Design and Operational Features -- Query Execution Process Flow -- DB2 Analytics Accelerator Content Maintenance -- DB2 Analytics Accelerator Table Definition and Deployment -- High-Performance Storage Saver -- Connectivity Options -- Disaster Recovery Considerations -- Query Acceleration Criteria -- Query Acceleration Control Knobs -- EXPLAIN Function -- System-Scope Instrumentation -- Thread-Scope Instrumentation -- DB2 Analytics Accelerator Administrative Stored Procedures -- DISPLAY ACCELerator Command -- Performance Considerations -- The PureData System for Analytics S-Blade, Based on Netezza Technology -- Applying Data Stream Processing to DB2 Queries -- Comparing PureData System for Analytics Appliance Models -- Minimizing Disk Failures -- Minimizing S-Blade Failures -- Summary -- DB2 10 for z/OS Query Optimization Update by Terry Purcell -- Access Path Management -- DB2 10 Takes Plan Management to the Next Level -- Predicate Processing and Runtime Optimizations -- Sort Performance Enhancements -- New Choices for the Query Optimizer -- Improving Parallelism Efficiency and Removing Limitations -- Improving the Inputs to the Query Optimizer -- Summary -- Planning for IBM DB2 10 for z/OS Upgrade by John Campbell -- Highlights of the Beta Program Testing -- Performance and Scalability -- Availability -- Other Issues -- Incompatible Changes -- Migration and Planning Considerations -- Items Planned for Post-GA Delivery.
When Should You Migrate to DB2 10 for z/OS? -- Summary -- DB2 10 for z/OS Case Studies Kela Invests in Improving Service Delivery for Finland's Citizens -- Primerica Improves Efficiency and Gains More Flexibility -- GAD Upgrades Database Systems to Boost Power and Productivity -- DB2 10 for z/OS Eases Workload Consolidation for Bankdata and JN Data -- Bank Hapoalim Improves Efficiency, Reduces Tape Usage by 25 Percent.
Abstract:
Celebrating the 30th anniversary of the first release of DB2, this book highlights the important milestones, capabilities, and impacts of the database management software for IBM's mainframe operating system. Special focus is given to IBM DB2 Analytics Accelerator, covering the key design and operational aspects that enable IBM DB2 for z/OS clients to benefit from faster performance, reduced CPU usage, and lower costs. The second half of the book discusses performance enhancements and cost-saving measures in the version 10 release and is rich with hints and tips for a successful upgrade. A special section on query performance and IBM DB2 Optimizer illustrates how DB2 10 addresses customer issues such as reducing total cost of ownership while maintaining stability and reliability. The final section is a collection of case studies in which DB2 10 for z/OS customers share their migration experiences and articulate the business benefits they are seeing since upgrading to the new release.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Genre:
Electronic Access:
Click to View