DB2 11 : the ultimate database for cloud, analytics, and mobile / / John Campbell [and four others]

• Pubblicazione: Boise, Idaho : , : MC Press, , 2014; ©2014
• Edizione: First edition.
• Descrizione fisica: 1 online resource (113 p.)
• Disciplina: 004.6782
• Soggetto topico: Cloud computing
• Soggetto genere / forma: Electronic books.
• Persona (resp. second.): CampbellJohn
• Note generali: Description based upon print version of record.
• Nota di contenuto: 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
• Sommario/riassunto: 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
• Titolo autorizzato: DB2 11
• ISBN: 1-58347-401-3; 1-58347-404-8
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910463611603321
• Lo trovi qui: Univ. Federico II