Cargando…
DB2 10 for z/OS performance topics /
DB2℗ʼ 10 can reduce the total DB2 CPU demand from 5-20% when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database defin...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Autor Corporativo: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Poughkeepsie, N.Y. :
IBM, International Technical Support Organization,
©2011.
|
| Colección: | IBM redbooks.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | OR_ocn803518926 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr |n||||||||| | ||
| 008 | 120319s2011 nyu o 001 0 eng d | ||
| 040 | |a VT2 |b eng |e pn |c VT2 |d OCLCO |d OCLCQ |d B24X7 |d OCLCA |d OCLCF |d OCLCQ |d OCLCO |d COO |d OCLCQ |d OCLCO |d LIV |d OCLCA |d BRF |d OCLCO |d ORMDA |d OCLCQ |d OCLCO | ||
| 019 | |a 1351474656 | ||
| 020 | |a 9780738435718 |q (print) | ||
| 020 | |a 0738435716 |q (print) | ||
| 035 | |a (OCoLC)803518926 |z (OCoLC)1351474656 | ||
| 037 | |a 0738435716 |b O'Reilly Media | ||
| 050 | 4 | |a QA76.9.D3 |b D32 2011eb | |
| 082 | 0 | 4 | |a 005.75/65 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Bruni, Paolo. | |
| 245 | 1 | 0 | |a DB2 10 for z/OS performance topics / |c Paolo Bruni [and others]. |
| 260 | |a Poughkeepsie, N.Y. : |b IBM, International Technical Support Organization, |c ©2011. | ||
| 300 | |a 1 online resource (408 pages). | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a IBM Redbooks | |
| 500 | |a "SG24-7942-00." | ||
| 500 | |a Includes index. | ||
| 588 | 0 | |a Online resource; title from cover (Safari Books Online, viewed March 16, 2012). | |
| 504 | |a Includes bibliographical references and index. | ||
| 520 | |a DB2℗ʼ 10 can reduce the total DB2 CPU demand from 5-20% when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types. Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS. DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs. This IBM Redbooks℗ʼ publication℗ʼ provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are somewhat familiar with DB2 10 for z/OS. See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a IBM Database 2. |
| 630 | 0 | 0 | |a z/OS. |
| 630 | 0 | 7 | |a IBM Database 2 |2 fast |
| 630 | 0 | 7 | |a z/OS |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a Database management |2 fast | |
| 710 | 2 | |a International Business Machines Corporation. |b International Technical Support Organization. | |
| 776 | 0 | 8 | |i Print version: |a Bruni, Paolo. |t DB2 10 for z/OS performance topics. |d Poughkeepsie, N.Y. : IBM, International Technical Support Organization, ©2011 |z 9780738435718 |
| 830 | 0 | |a IBM redbooks. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/0738435716/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Books 24x7 |b B247 |n bks00050093 | ||
| 994 | |a 92 |b IZTAP | ||