DB2 Best Practices - updated
svisser1 2700018UK9 Visits (2568)
best practices for IBM DB2 for Linux, UNIX, and Windows. Get practical guidance for the most common DB2 9 product configurations and use this knowledge to improve the value of your DB2 data servers.
Notice that updates and additions were made recently:
"Database Storage" (October 2008) Updated!Discover best practices for database storage including guidelines and recommendations for spindles and logical unit numbers (LUNs), stripe and striping, transaction logs and data, file systems versus raw devices, Redundant Array of Independent Disks (RAID) devices, registry variable and configuration parameter settings, and automatic storage.
"Physical Database Design" (May 2008)Learn about all of the design features that relate to the physical structure of the database such as datatype selection, table normalization and denormalization, indexes, materialized views, data clustering, multidimensional data clustering, table (range) partitioning, and database (hash) partitioning.
"Information Modeling with Rational Data Architect Version 7" (October 2008) New!Discover the best practices for information modeling based on the experiences of a team of data modelers using Rational Data Architect with DB2. Rational Data Architect is an information modeling tool that can help you establish and use standards in design based on proven design methodologies to create highly reusable models that satisfy business requirements.
"Data Life Cycle Management" (October 2008) Updated!See the best practices to design and implement scalable solutions that facilitate the continuous feed or roll-in and roll-out of data, with minimal interruption of data access.
"DB2 High Availability Disaster Recovery" (October 2008) New!Get recommendations for setting up and maintaining a DB2 High Availability Disaster Recovery (HADR) environment in ways that balance the protection HADR provides with performance and cost. This best practice explains optimizing for fast failovers, tuning parameters for network and logging performance, and understanding table reorganization methods and load operations in an HADR environment.
"Tuning and Monitoring Database System Performance" (October 2008) Updated!See best practices for the performance evolution of a Data Server. From important principles of initial hardware and software configuration to monitoring techniques that help you understand system performance under both operational and troubleshooting conditions. For troubleshooting performance problems, this paper provide a step-wise, methodical method for determining the problem.
"DB2 Workload Management" (October 2008) New!DB2 Workload Management helps prevent, detect, and resolve conflicting resource requirements on a DB2 data server based on defined business objectives. This paper details the current best practices for DB2 workload manager.