Chapter 6. Data Concurrency
Data integrity is the primary concern in any database environment. The database server must guarantee the integrity of the data as it is modified. Every executable SQL statement that is issued is considered to be part of a transaction.
A transaction contains at least one SQL statement. Multiple SQL statements can be grouped together and executed as a single transaction. Any data that has been accessed or modified by SQL statements will be tracked by DB2 and either permanently changed (committed), or returned to their original state (rolled back). This all-or-nothing behavior is known as atomicity. A transaction does not only guarantee atomicity, it also guarantees durability. Durability is provided through transactional ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
