Cargando…
DB2 11 : the ultimate database for cloud, analytics, and mobile /
Building on the prior book ""DB2 11: The Database for Big Data and Analytics, "" published in 2013, this book is written 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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Boise, Idaho :
MC Press,
2014.
|
| Edición: | First edition. |
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- 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 EnhancementsQuery 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 QueryNew 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 for z/OS: Migration Planning and Early Customer Experiences; DB2 11 Major Themes; 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 SoftwareCustomer 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 EnhancementsRECOVER 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.