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: https://ibm.biz/Bdx2nr
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.
- Learn more about the cost reduction strategies with DB2 best practices
- Learn more about the database storage best practices
- Learn more about the storage optimization with deep compression best practices
- Learn more about the High Availability Disaster Recovery best practices
- Learn more about the combining IBM DB2 pureScale with Q Replication for scalability and business continuity best practices
- Learn how demoted I/O requests may lead to DB2 performance problems
- Get started with the IBM Infosphere Data Architect
- Learn more about the 15 best practices for pureXML performance in DB2
- Access DB2 database product documentation
- Learn more about database fundamentals
- Get resources to advance your IBM Information Management product skills in the Information Management area on developerWorks
- Stay current with developerWorks technical events and webcasts that are focused on a variety of IBM products and IT industry topics.
- Learn more about the Information Management best practices.
- Learn more about the DB2 for Linux, UNIX, and Windows best practices.
- Visit the DB2 Version 10.1 Information Center.
About the Authors
|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 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 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 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 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.|