|
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910788079003321 |
|
|
Titolo |
DB2 11 : the ultimate database for cloud, analytics, and mobile / / John Campbell [and four others] |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Boise, Idaho : , : MC Press, , 2014 |
|
©2014 |
|
|
|
|
|
|
|
|
|
ISBN |
|
1-58347-401-3 |
1-58347-404-8 |
|
|
|
|
|
|
|
|
Edizione |
[First edition.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (113 p.) |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
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 |
|
|
|
|
|
|
|
| |