DB2 11 : The Ultimate Database for Cloud, Analytics & Mobile.
Title:
DB2 11 : The Ultimate Database for Cloud, Analytics & Mobile.
Author:
Campbell, John.
ISBN:
9781583474044
Personal Author:
Physical Description:
1 online resource (113 pages)
Contents:
Front Cover -- Title Page -- Copyright -- About the Authors -- Contents -- Introduction by Surekha Parekh -- DB2 11 for z/OS: Technical Overview - by John Campbell and Gareth Jones -- DB2 11 Performance Expectations -- Performance Expectations for OLTP and Batch -- Performance Expectations for Queries -- DB2 11 Performance Expectations Summary -- Performance Highlights -- ESP Customer Feedback -- DB2 11 Performance Improvements in More Detail -- No Rebind Required -- Rebind Required-With or Without Apreuse -- Rebind Required-Without Apreuse -- DBA or Application Programmer Effort Required -- DB2-Related Enhancements in z/OS 2.1 -- Buffer Pool Enhancements -- Query Performance and Management Improvements -- Optimizer Externalization of Missing or Conflicting Statistics -- Apreuse(Warn) -- DPSI Improvements -- Availability Improvements -- Extended RBA and LRSN -- BIND, REBIND, DDL, and Online REORG Break-in with Persistent Threads -- Online Schema Changes -- RAS Improvements -- Autonomic Index Pseudo-Delete Cleanup -- Reduction of Overflow Rows and Indirect References -- DDF Enhanced Client Information Fields -- Data Sharing Improvements -- Security Enhancements -- Utility Enhancements -- Analytics Improvements -- Temporal Data Enhancements -- Transparent Archive Query -- New Analytics Features -- Integration with Big Data -- New Application Features -- Mobile Application Support -- Easier DB2 Version Upgrade with Application SQL Compatibility -- DB2 11 for z/OS: Migration Planning and Early Customer Experiences -- DB2 11 Major Themes -- DB2 11 for z/OS: Migration Planning and Early Customer Experiences -- DB2 11 Major Themes -- CPU Savings -- Enhanced Resiliency and Continuous Availability -- Enhanced Business Analytics -- Simpler, Faster DB2 Version Upgrades -- ESP Highlights -- DB2 11 Early Support Program Customer Feedback.
Migration Considerations -- Prerequisites: Hardware and Software -- Customer Quotes from the DB2 11 Early Support Program -- Prerequisites: DB2 Connect -- Pre-Migration Planning -- Important Preparation -- Preparing Your Current DB2 10 NFM for Migration to DB2 11 CM -- DB2 11 Migration Overview -- Migration and Fallback Paths -- APPLCOMPAT: Application Compatibility -- Availability -- BIND/REBIND/DDL/Online REORG Break-in with Persistent RELEASE(DEALLOCATE) Threads -- Persistent Thread Break-in: ESP Customer Testing Experiences -- Improved Control When Altering Partition Limit Keys -- DROP COLUMN -- Utility Enhancements -- REORG Enhancements -- RUNSTATS and RTS Enhancements -- RECOVER Enhancements -- Performance and Scalability -- Performance Enhancements: No REBIND Needed (CM) -- Performance Enhancements Requiring REBIND -- Performance Enhancements Requiring DBA or Application Effort (NFM) -- Optional Enhancements Requiring NFM and DBA Effort -- DB2 Lab Performance Measurement Summary -- Example of Customer Performance Testing -- Automatic Pseudo-Deleted Index Entry Cleanup -- Performance Enhancements -- Q Replication Log Filtering -- Archive Transparency -- Optimizer Enhancements -- GROUP BY Grouping Sets -- Extended LRBA/LRSN -- Other Performance Recommendations -- Performance Summary -- Other Enhancements -- Remove Package Security Vulnerabilities -- Archive Transparency -- For More Information -- DB2 11 Resources -- DB2 10 Migration to DB2 11 and Application Compatibility - by Chris Crone and Jay Yothers -- Migration Prerequisites -- Modes of Migration -- Functional Availability -- Optional Migration Processing -- The Essentials of Migration -- Application Compatibility in DB2 11 for z/OS -- Description of the Problem -- Impact to Customers -- Solution Requirements -- Solution -- Solution Details -- Interaction with NFM.
Identifying Applications That Need to Be Examined -- New Reserved Words -- New Reserved Word Solution -- Pre-Migration Planning -- What's Not Part of This Solution -- Summary -- Case Studies -- BMW Group Develops Eco-Friendly Innovation for Smart Drivers with IBM -- JN Data Gets the Early Adopter Advantage for Its Growing Business.
Abstract:
Essential information about early customer experiences, migration advice, and performance specifics from IBM experts directly involved in the development of DB2 11 Building on the previously published DB2 11: The Database for Big Data and Analytics, this book is particularly for new and existing DB2 for z/OS customers and users who want to learn as much as they can about the new software version before migrating their organizations to DB2 11 for z/OS. The guide begins with a technical overview of DB2 11 features and explains how the new functions in DB2 11 can help enterprise customers address the challenges they face with the explosion of data and information. There has been rapid growth in the variety, volume, and velocity of data due to the increase of smart devices, mobile applications, cloud computing, and social media, and many of the enhancements in DB2 11 are focused on enabling enterprise customers to respond to these market opportunities in a cost-effective way. The book includes a detailed discussion for helping customers plan their DB2 11 migration strategy, and shares experiences of people who have already upgraded to DB2 11 and participated in IBM's Early Support Program. A third section of the book addresses one of the most common obstacles that prevents customers from migrating to a new release: the need to implement any code changes required due to application incompatibilities. With DB2 11's "application compatibility" support, such applications can continue to run under the new release until those changes can be implemented, removing them as an upgrade dependency.
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.
Subject Term:
Genre:
Electronic Access:
Click to View