OLTP turbo boost achieved with IBM DB2 for i

Discover how this exciting support allows developers to build high performance applications more easily and flexibly

From the developerWorks archives

Xing Shen and Cai Zhou

Date archived: December 19, 2016 | First published: May 23, 2013

An online transaction processing (OLTP) environment is designed for a software application to facilitate the transactional nature of a business. OLTP applications are data driven. Business transactions are accomplished by inserting and updating rows in database tables. At the same time, other users and processes are continually reading and reporting against the OLTP tables. Jobs doing writing and reading at the same time is the classic driver of concurrency control issues. OLTP applications can take advantage of the new IBM® DB2® for i concurrent access controls to improve application throughput and reduce data contention. The IBM i 6.1 release includes a control called SKIP LOCKED DATA and IBM i 7.1 added support for the USE CURRENTLY COMMITED and WAIT FOR OUTCOME controls. Discover how this exciting support allows developers to build high performance applications more easily and flexibly.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=IBM i
ArticleID=931024
ArticleTitle=OLTP turbo boost achieved with IBM DB2 for i
publish-date=05232013