Skip to Content
Unleashing DB2 10 for Linux, UNIX, and Windows
book

Unleashing DB2 10 for Linux, UNIX, and Windows

by Danny Arnold, Steve Diniro, Vivian Lee, Stan Musker, Jo-Ann Woods
August 2012
Intermediate to advanced content levelIntermediate to advanced
162 pages
4h 25m
English
IBM Redbooks
Content preview from Unleashing DB2 10 for Linux, UNIX, and Windows
106 Unleashing DB2 10 for Linux, UNIX, and Windows
Oracle enforces statement-level isolation. This means that all the data returned
by a query comes from a single point in time, that is, the time that the query
started. As a result, a query never sees changes made by other transactions
during its execution. Only data committed before the query began is available to
the query. Changes made by other transactions that commit during query
execution are invisible. As illustrated in Table 7-1, the phrase often associated
with this behavior is “readers do not block writers and writers do not block
readers.”
Cursor stability is the default isolation ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

High Availability and Disaster Recovery Options for DB2 for Linux, UNIX, and Windows

High Availability and Disaster Recovery Options for DB2 for Linux, UNIX, and Windows

Stanislaw Bartkowski, Ciaran De Buitlear, Adrian Kalicki, Michael Loster, Marcin Marczewski, Anas Mosaad, Jan Nelken, Mohamed Soliman, Klaus Subtil, Marko Vrhovnik, Karol Zimnol
SQL Procedures, Triggers, and Functions on IBM DB2 for i

SQL Procedures, Triggers, and Functions on IBM DB2 for i

Jim Bainbridge, Hernando Bedoya, Rob Bestgen, Mike Cain, Dan Cruikshank, Jim Denton, Doug Mack, Tom Mckinley, Simona Pacchiarini
DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition

DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition

Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul Chong, Michael Gao, Fraser McArthur, Paul Yip
Building Web Services with Java: Making Sense of XML, SOAP, WSDL, and UDDI, Second Edition

Building Web Services with Java: Making Sense of XML, SOAP, WSDL, and UDDI, Second Edition

Steve Graham, Doug Davis, Simeon Simeonov, Glen Daniels, Peter Brittenham, Yuichi Nakamura, Paul Fremantle, Dieter König, Claudia Zentner

Publisher Resources

ISBN: 0738437107Purchase book