IBM Support

100 Tech Tips, #66: Updated DB2 for LUW best practices paper

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: http://www.ibm.com/developerworks/data/bestpractices/databasedesign/

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
We encourage those of you interested in DB2 to download and read the book, and let us know what you think by leaving a comment on this blog or on our Facebook page!
 

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11141822