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...
Gespeichert in:
| Beteilige Person: | |
|---|---|
| Körperschaft: | |
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Poughkeepsie, N.Y.
IBM, International Technical Support Organization
2011
|
| Schriftenreihe: | IBM Redbooks
|
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/0738435716/?ar |
| Zusammenfassung: | 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. |
| Beschreibung: | "SG24-7942-00.". - Includes index. - Includes bibliographical references and index. - Online resource; title from cover (Safari Books Online, viewed March 16, 2012) |
| Umfang: | 1 Online-Ressource (408 Seiten). |
Internformat
MARC
| LEADER | 00000cam a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-09409568X | ||
| 003 | DE-627-1 | ||
| 005 | 20240228115025.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 230802s2011 xx |||||o 00| ||eng c | ||
| 035 | |a (DE-627-1)09409568X | ||
| 035 | |a (DE-599)KEP09409568X | ||
| 035 | |a (ORHE)0738435716 | ||
| 035 | |a (DE-627-1)09409568X | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.75/65 |2 23 | |
| 100 | 1 | |a Bruni, Paolo |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a DB2 10 for z/OS performance topics |c Paolo Bruni [and others] |
| 264 | 1 | |a Poughkeepsie, N.Y. |b IBM, International Technical Support Organization |c 2011 | |
| 300 | |a 1 Online-Ressource (408 Seiten). | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 490 | 0 | |a IBM Redbooks | |
| 500 | |a "SG24-7942-00.". - Includes index. - Includes bibliographical references and index. - Online resource; title from cover (Safari Books Online, viewed March 16, 2012) | ||
| 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. | ||
| 630 | 2 | 0 | |a IBM Database 2 |
| 630 | 2 | 0 | |a z/OS |
| 650 | 0 | |a Database management | |
| 650 | 4 | |a IBM Database 2 | |
| 650 | 4 | |a z/OS | |
| 650 | 4 | |a Bases de données ; Gestion | |
| 650 | 4 | |a Database management | |
| 710 | 2 | |a International Business Machines Corporation. |b International Technical Support Organization. |e MitwirkendeR |4 ctb | |
| 776 | 1 | |z 9780738435718 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9780738435718 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/0738435716/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-09409568X |
|---|---|
| _version_ | 1821494940405858304 |
| adam_text | |
| any_adam_object | |
| author | Bruni, Paolo |
| author_corporate | International Business Machines Corporation. International Technical Support Organization |
| author_corporate_role | ctb |
| author_facet | Bruni, Paolo International Business Machines Corporation. International Technical Support Organization |
| author_role | aut |
| author_sort | Bruni, Paolo |
| author_variant | p b pb |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)09409568X (DE-599)KEP09409568X (ORHE)0738435716 |
| dewey-full | 005.75/65 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/65 |
| dewey-search | 005.75/65 |
| dewey-sort | 15.75 265 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03683cam a22004452 4500</leader><controlfield tag="001">ZDB-30-ORH-09409568X</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228115025.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">230802s2011 xx |||||o 00| ||eng c</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)09409568X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP09409568X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)0738435716</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)09409568X</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/65</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Bruni, Paolo</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">DB2 10 for z/OS performance topics</subfield><subfield code="c">Paolo Bruni [and others]</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Poughkeepsie, N.Y.</subfield><subfield code="b">IBM, International Technical Support Organization</subfield><subfield code="c">2011</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (408 Seiten).</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">IBM Redbooks</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">"SG24-7942-00.". - Includes index. - Includes bibliographical references and index. - Online resource; title from cover (Safari Books Online, viewed March 16, 2012)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="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.</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">IBM Database 2</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">z/OS</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">IBM Database 2</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">z/OS</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données ; Gestion</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">International Business Machines Corporation.</subfield><subfield code="b">International Technical Support Organization.</subfield><subfield code="e">MitwirkendeR</subfield><subfield code="4">ctb</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">9780738435718</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9780738435718</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/0738435716/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-09409568X |
| illustrated | Not Illustrated |
| indexdate | 2025-01-17T11:22:22Z |
| institution | BVB |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (408 Seiten). |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2011 |
| publishDateSearch | 2011 |
| publishDateSort | 2011 |
| publisher | IBM, International Technical Support Organization |
| record_format | marc |
| series2 | IBM Redbooks |
| spelling | Bruni, Paolo VerfasserIn aut DB2 10 for z/OS performance topics Paolo Bruni [and others] Poughkeepsie, N.Y. IBM, International Technical Support Organization 2011 1 Online-Ressource (408 Seiten). Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier IBM Redbooks "SG24-7942-00.". - Includes index. - Includes bibliographical references and index. - Online resource; title from cover (Safari Books Online, viewed March 16, 2012) 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. IBM Database 2 z/OS Database management Bases de données ; Gestion International Business Machines Corporation. International Technical Support Organization. MitwirkendeR ctb 9780738435718 Erscheint auch als Druck-Ausgabe 9780738435718 |
| spellingShingle | Bruni, Paolo DB2 10 for z/OS performance topics IBM Database 2 z/OS Database management Bases de données ; Gestion |
| title | DB2 10 for z/OS performance topics |
| title_auth | DB2 10 for z/OS performance topics |
| title_exact_search | DB2 10 for z/OS performance topics |
| title_full | DB2 10 for z/OS performance topics Paolo Bruni [and others] |
| title_fullStr | DB2 10 for z/OS performance topics Paolo Bruni [and others] |
| title_full_unstemmed | DB2 10 for z/OS performance topics Paolo Bruni [and others] |
| title_short | DB2 10 for z/OS performance topics |
| title_sort | db2 10 for z os performance topics |
| topic | IBM Database 2 z/OS Database management Bases de données ; Gestion |
| topic_facet | IBM Database 2 z/OS Database management Bases de données ; Gestion |
| work_keys_str_mv | AT brunipaolo db210forzosperformancetopics AT internationalbusinessmachinescorporationinternationaltechnicalsupportorganization db210forzosperformancetopics |