DB2 9 for z/OS: resource serialization and concurrency control
Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of the serialization mechanisms available in IBM℗ʼ DB2℗ʼ for z/OS℗ʼ. DB2 uses different mechanisms...
Gespeichert in:
Beteiligte Personen: | , , , , |
---|---|
Format: | Elektronisch E-Book |
Sprache: | Englisch |
Veröffentlicht: |
[Poughkeepsie, New York]
IBM Corporation, International Technical Support Organization
2009
|
Schriftenreihe: | IBM Redbooks
|
Schlagwörter: | |
Links: | https://learning.oreilly.com/library/view/-/0738433861/?ar |
Zusammenfassung: | Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of the serialization mechanisms available in IBM℗ʼ DB2℗ʼ for z/OS℗ʼ. DB2 uses different mechanisms for serialization to achieve its goal of maximizing concurrency without losing integrity with a minimum cost in CPU, I/O, and storage resources. In this IBM Redbooks℗ʼ publication, we review and explore the different serialization mechanisms used in DB2, such as transaction (DML) locking, claims and drains, restrictive states, latching, and optimistic serialization. This book was written for application developers in order to help them better understand serialization mechanisms and how they influence application design decisions. |
Beschreibung: | "Part Number: SG24-4725-01.". - Includes index. - Includes bibliographical references (pages 446) and index. - Online resource; title from cover (Safari Books Online, viewed Apr. 13, 2015) |
Umfang: | 1 Online-Ressource. |
Internformat
MARC
LEADER | 00000cam a22000002 4500 | ||
---|---|---|---|
001 | ZDB-30-ORH-094098158 | ||
003 | DE-627-1 | ||
005 | 20240228120119.0 | ||
007 | cr uuu---uuuuu | ||
008 | 230802s2009 xx |||||o 00| ||eng c | ||
035 | |a (DE-627-1)094098158 | ||
035 | |a (DE-599)KEP094098158 | ||
035 | |a (ORHE)0738433861 | ||
035 | |a (DE-627-1)094098158 | ||
040 | |a DE-627 |b ger |c DE-627 |e rda | ||
041 | |a eng | ||
082 | 0 | |a 005.75/65 |2 23/eng/20221122 | |
100 | 1 | |a Bruni, Paolo |e VerfasserIn |4 aut | |
245 | 1 | 0 | |a DB2 9 for z/OS |b resource serialization and concurrency control |c Paolo Bruni, Mike Bracey, Rubina Goolamhussen, Ravikumar Kalyanasundaram, Bart Steegmans |
264 | 1 | |a [Poughkeepsie, New York] |b IBM Corporation, International Technical Support Organization |c 2009 | |
300 | |a 1 Online-Ressource. | ||
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 "Part Number: SG24-4725-01.". - Includes index. - Includes bibliographical references (pages 446) and index. - Online resource; title from cover (Safari Books Online, viewed Apr. 13, 2015) | ||
520 | |a Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of the serialization mechanisms available in IBM℗ʼ DB2℗ʼ for z/OS℗ʼ. DB2 uses different mechanisms for serialization to achieve its goal of maximizing concurrency without losing integrity with a minimum cost in CPU, I/O, and storage resources. In this IBM Redbooks℗ʼ publication, we review and explore the different serialization mechanisms used in DB2, such as transaction (DML) locking, claims and drains, restrictive states, latching, and optimistic serialization. This book was written for application developers in order to help them better understand serialization mechanisms and how they influence application design decisions. | ||
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 | |
700 | 1 | |a Bracey, Mike |e VerfasserIn |4 aut | |
700 | 1 | |a Goolamhussen, Rubina |e VerfasserIn |4 aut | |
700 | 1 | |a Kalyanasundaram, Ravikumar |e VerfasserIn |4 aut | |
700 | 1 | |a Steegmans, Bart |e VerfasserIn |4 aut | |
776 | 1 | |z 9780738433868 | |
776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9780738433868 |
966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/0738433861/?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-094098158 |
---|---|
_version_ | 1821494940215017472 |
adam_text | |
any_adam_object | |
author | Bruni, Paolo Bracey, Mike Goolamhussen, Rubina Kalyanasundaram, Ravikumar Steegmans, Bart |
author_facet | Bruni, Paolo Bracey, Mike Goolamhussen, Rubina Kalyanasundaram, Ravikumar Steegmans, Bart |
author_role | aut aut aut aut aut |
author_sort | Bruni, Paolo |
author_variant | p b pb m b mb r g rg r k rk b s bs |
building | Verbundindex |
bvnumber | localTUM |
collection | ZDB-30-ORH |
ctrlnum | (DE-627-1)094098158 (DE-599)KEP094098158 (ORHE)0738433861 |
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>02702cam a22004812 4500</leader><controlfield tag="001">ZDB-30-ORH-094098158</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228120119.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">230802s2009 xx |||||o 00| ||eng c</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)094098158</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP094098158</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)0738433861</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)094098158</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/eng/20221122</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 9 for z/OS</subfield><subfield code="b">resource serialization and concurrency control</subfield><subfield code="c">Paolo Bruni, Mike Bracey, Rubina Goolamhussen, Ravikumar Kalyanasundaram, Bart Steegmans</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[Poughkeepsie, New York]</subfield><subfield code="b">IBM Corporation, International Technical Support Organization</subfield><subfield code="c">2009</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource.</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">"Part Number: SG24-4725-01.". - Includes index. - Includes bibliographical references (pages 446) and index. - Online resource; title from cover (Safari Books Online, viewed Apr. 13, 2015)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of the serialization mechanisms available in IBM℗ʼ DB2℗ʼ for z/OS℗ʼ. DB2 uses different mechanisms for serialization to achieve its goal of maximizing concurrency without losing integrity with a minimum cost in CPU, I/O, and storage resources. In this IBM Redbooks℗ʼ publication, we review and explore the different serialization mechanisms used in DB2, such as transaction (DML) locking, claims and drains, restrictive states, latching, and optimistic serialization. This book was written for application developers in order to help them better understand serialization mechanisms and how they influence application design decisions.</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="700" ind1="1" ind2=" "><subfield code="a">Bracey, Mike</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Goolamhussen, Rubina</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kalyanasundaram, Ravikumar</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Steegmans, Bart</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">9780738433868</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">9780738433868</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/-/0738433861/?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-094098158 |
illustrated | Not Illustrated |
indexdate | 2025-01-17T11:22:21Z |
institution | BVB |
language | English |
open_access_boolean | |
owner | DE-91 DE-BY-TUM |
owner_facet | DE-91 DE-BY-TUM |
physical | 1 Online-Ressource. |
psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
publishDate | 2009 |
publishDateSearch | 2009 |
publishDateSort | 2009 |
publisher | IBM Corporation, International Technical Support Organization |
record_format | marc |
series2 | IBM Redbooks |
spelling | Bruni, Paolo VerfasserIn aut DB2 9 for z/OS resource serialization and concurrency control Paolo Bruni, Mike Bracey, Rubina Goolamhussen, Ravikumar Kalyanasundaram, Bart Steegmans [Poughkeepsie, New York] IBM Corporation, International Technical Support Organization 2009 1 Online-Ressource. Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier IBM Redbooks "Part Number: SG24-4725-01.". - Includes index. - Includes bibliographical references (pages 446) and index. - Online resource; title from cover (Safari Books Online, viewed Apr. 13, 2015) Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data integrity. However, locking is just one of the serialization mechanisms available in IBM℗ʼ DB2℗ʼ for z/OS℗ʼ. DB2 uses different mechanisms for serialization to achieve its goal of maximizing concurrency without losing integrity with a minimum cost in CPU, I/O, and storage resources. In this IBM Redbooks℗ʼ publication, we review and explore the different serialization mechanisms used in DB2, such as transaction (DML) locking, claims and drains, restrictive states, latching, and optimistic serialization. This book was written for application developers in order to help them better understand serialization mechanisms and how they influence application design decisions. IBM Database 2 z/OS Database management Bases de données ; Gestion Bracey, Mike VerfasserIn aut Goolamhussen, Rubina VerfasserIn aut Kalyanasundaram, Ravikumar VerfasserIn aut Steegmans, Bart VerfasserIn aut 9780738433868 Erscheint auch als Druck-Ausgabe 9780738433868 |
spellingShingle | Bruni, Paolo Bracey, Mike Goolamhussen, Rubina Kalyanasundaram, Ravikumar Steegmans, Bart DB2 9 for z/OS resource serialization and concurrency control IBM Database 2 z/OS Database management Bases de données ; Gestion |
title | DB2 9 for z/OS resource serialization and concurrency control |
title_auth | DB2 9 for z/OS resource serialization and concurrency control |
title_exact_search | DB2 9 for z/OS resource serialization and concurrency control |
title_full | DB2 9 for z/OS resource serialization and concurrency control Paolo Bruni, Mike Bracey, Rubina Goolamhussen, Ravikumar Kalyanasundaram, Bart Steegmans |
title_fullStr | DB2 9 for z/OS resource serialization and concurrency control Paolo Bruni, Mike Bracey, Rubina Goolamhussen, Ravikumar Kalyanasundaram, Bart Steegmans |
title_full_unstemmed | DB2 9 for z/OS resource serialization and concurrency control Paolo Bruni, Mike Bracey, Rubina Goolamhussen, Ravikumar Kalyanasundaram, Bart Steegmans |
title_short | DB2 9 for z/OS |
title_sort | db2 9 for z os resource serialization and concurrency control |
title_sub | resource serialization and concurrency control |
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 db29forzosresourceserializationandconcurrencycontrol AT braceymike db29forzosresourceserializationandconcurrencycontrol AT goolamhussenrubina db29forzosresourceserializationandconcurrencycontrol AT kalyanasundaramravikumar db29forzosresourceserializationandconcurrencycontrol AT steegmansbart db29forzosresourceserializationandconcurrencycontrol |