LEADER 05172nam 2200625 450 001 9910463611603321 005 20200520144314.0 010 $a1-58347-401-3 010 $a1-58347-404-8 035 $a(CKB)2670000000578060 035 $a(EBL)1866826 035 $a(OCoLC)899000607 035 $a(SSID)ssj0001408949 035 $a(PQKBManifestationID)11755194 035 $a(PQKBTitleCode)TC0001408949 035 $a(PQKBWorkID)11354537 035 $a(PQKB)11424459 035 $a(MiAaPQ)EBC1866826 035 $a(Au-PeEL)EBL1866826 035 $a(CaPaEBR)ebr10990864 035 $a(CaONFJC)MIL664856 035 $a(EXLCZ)992670000000578060 100 $a20141208h20142014 uy 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt 182 $cc 183 $acr 200 00$aDB2 11 $ethe ultimate database for cloud, analytics, and mobile /$fJohn Campbell [and four others] 205 $aFirst edition. 210 1$aBoise, Idaho :$cMC Press,$d2014. 210 4$dİ2014 215 $a1 online resource (113 p.) 300 $aDescription based upon print version of record. 311 $a1-322-33574-5 311 $a1-58347-403-X 327 $aFront 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 327 $aBuffer 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 327 $aTransparent 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 327 $aPrerequisites: 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 327 $aRUNSTATS 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 327 $aPerformance Summary 330 $aEssential 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 606 $aCloud computing 608 $aElectronic books. 615 0$aCloud computing. 676 $a004.6782 702 $aCampbell$b John 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910463611603321 996 $aDB2 11$92156115 997 $aUNINA