Record:   Prev Next
作者 Campbell, John
書名 The Business Value of DB2 for z/OS : IBM DB2 Analytics Accelerator and Optimizer
出版項 Chicago : MC Press, 2013
©2013
國際標準書號 9781583477588 (electronic bk.)
9781583473818
book jacket
說明 1 online resource (145 pages)
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
附註 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
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
Description based on publisher supplied metadata and other sources
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2020. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries
鏈接 Print version: Campbell, John The Business Value of DB2 for z/OS : IBM DB2 Analytics Accelerator and Optimizer Chicago : MC Press,c2013 9781583473818
主題 Books -- History -- Bibliography -- Periodicals.;Printing -- History -- Bibliography -- Periodicals.;Libraries -- History -- Bibliography -- Periodicals.;Bibliography -- Periodicals
Electronic books
Alt Author Hrle, Namik
Li, Ruiping
Parekh, Surekha
Purcell, Terry
Record:   Prev Next