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...

Descripción completa

Detalles Bibliográficos
Autor Corporativo: International Business Machines Corporation (-)
Otros Autores: Bruni, Paolo Author (author), Goolamhussen, Rubina Contributor (contributor), Bracey, Mike Contributor
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] IBM Corporation International Technical Support Organization 2009
Colección:IBM redbooks.
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009755186906719
Descripción
Sumario: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.
Notas:Bibliographic Level Mode of Issuance: Monograph
Descripción Física:1 online resource (484 pages)