Technical Blog Post
Abstract
100 Tech Tips, #66: Updated DB2 for LUW best practices paper
Body
100 Tech Tips, #66: Updated DB2 for LUW best practices paper
One of our most popular best practices papers for DB2 for Linux, UNIX, and Windows has been significantly updated and is available for download: https://public.dhe.ibm.com/ps/products/db2/info/devWorks_pdfs/Best_practices/DB2BP_Physical_Design_OLTP_0412.pdf
The paper, titled "Best Practices: Physical database design for OLTP environments", was reviewed by a large team of DB2 experts and covers the following topics:
The paper, titled "Best Practices: Physical database design for OLTP environments", was reviewed by a large team of DB2 experts and covers the following topics:
- Introduction to physical database design
- OLTP workload characteristics
- Data modeling
- Storage systems
- Table spaces and buffer pools
- Data types
- Tables
- Indexes
- Database transaction logs
- Data and index compression
- Query design
- Database sizing and capacity management
- Reliability, availability, and scalability
- Operation and maintenance of database systems
- Best practices summary
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
UID
ibm11141822