Physical database design for online transaction processing (OLTP) environments






This article focuses on physical database attributes that are affected by the specifics of DB2 database servers in online transaction processing (OLTP) environments.


Short URL for this page:

Date: March 28, 2012


Share this page with colleagues and friends: Click one of the buttons in the right margin of this page to share this page on your favorite social networks.

Follow IBM DB2 news:

Download: By downloading any file on this site, you agree to the developerWorks terms of use.





Further Reading

About the Authors

Sripriya Srinivasan photo Sripriya Srinivasan is an Advisory Software Engineer in the DB2 for Linux, UNIX, and Windows Advanced Support Team - Down System Division. She has worked in DB2 support for the last 9 years and has in-depth knowledge in various engine areas specializing in DB2 Memory Management and DB2 Internal Architecture. Sripriya has been with IBM for 11 years, and has a Master of Science Degree from University of Kansas.
Weilin Lu photo Weilin Lu is a senior quality assurance specialist with the DB2 for Linux, UNIX, and Windows product team at the IBM Beaverton Lab in Beaverton, Oregon, U.S.A. She holds a Master degree of computing and science from McMaster University, Canada, She also holds a Master degree of computer science and electric engineering from Zhejiang University, China. She was an associated professor at Zhejiang University before she moved to North America, She has been part of the DB2 QA team since 2000.
Amyris Rada photo Amyris Rada is a senior writer with the DB2 for Linux, UNIX, and Windows product team at the IBM Canada Lab in Markham, Ontario. She has been part of the DB2 team since 1998, and has held different positions in partner enablement, quality assurance, and information development. She holds a Bachelor of Computer Engineer from the Simon Bolivar University. She is currently responsible for several content areas for the DB2 Information Center and collaborates with DB2 best practices development. Before working for IBM, Amyris worked at KL Group and INTERGRAPH.
Punit Shah photo Punit Shah has been a member of the DB2 team since 2008 and contributed to the shared disk backup and recovery solution in DB2 Version 9.8 and the HADR development for future releases. He has held a variety of leadership positions while working at IBM over the past 12 years. This includes Storage Group technology evangelism, where he was responsible for enabling IBM and non-IBM (SAP, Oracle, Sybase) enterprise applications to use the latest POWER processor, operating system, and virtualization technologies. Prior to IBM, Punit worked at Informix and Sequent.
Vincent Kulandai Samy photo Vincent Kulandai Samy is a DB2 kernel developer in IBM Beaverton Lab, working on DB2 for Linux, UNIX, and Windows kernel development for the past 10 years. He came to IBM as part of Informix acquisition. Prior to the Informix acquisition, he was working on Informix IDS and XPS database kernel. His areas of expertise are database kernel, DB2 HADR, Multi-Temperature Warehouse, recovery, backup and restore, Linux kernel internals and kernel debugging. He was the technical lead for DB2 HADR Reads on Standby feature, released in DB2 Version 97 Fix Pack 1. For the past three years, Vincent has also been championing several DB2 HADR adoptions and new sale/deployments through on-site customer visits, consultancy, customer advocacy. He had presented DB2 HADR/TSA customer success stories at IOD conferences with Fidelity Investments and PepsiCo in 2008 and 2010.