IBM®
Skip to main content
    Country/region [select]      Terms of use
 
 
    
     Home      Products      Services & industry solutions      Support & downloads      My IBM     
developerworks > My developerWorks >  Dashboard > IBM Database Wiki > ... > Home > Best Practices > Information > Page Comparison
developerWorks
Log In   View a printable version of the current page.
Best Practices
Browse space Browse Space    
Version 21 by torodanhan
on Oct 24, 2008 12:14.

<< Changes from 20 to 21
compared with
Current by jayped
on Oct 27, 2008 15:27.
(show comment)
 
Key
These lines were removed. This word was removed.
These lines were added. This word was added.

View page history


There are 4 changes. View first change.

 These Best Practices present advice on the most optimal ways you can use DB2 to satisfy key business data processing needs. Each Best Practice paper is designed to provide practical guidance for the most common DB2 9 product configurations. By applying these recommendations, you may improve the value of your DB2 data servers and align yourself with IBM's technical direction for DB2.
  
 [*Database Storage*|Best Practice - Database Storage]
 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*|Best Practice - Physical Database Design]
 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*|Best Practice - Information Modeling with Rational Data Architect Version 7]
 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. See Downloads for the sample file associated with this paper.
  
 [*Data Life Cycle Management*|Best Practice - Data Life Cycle Management]
 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.
  
 [*Minimizing Planned Outages*|Best Practice - Minimizing Planned Outages]
 View the best practices for minimizing, or even potentially eliminating, planned database outages. Planned outages can include activities such as routine database maintenance activities or upgrades to your database environment.
  
[*DB2 High Availability Disaster Recovery*|Best Practice - DB2 High Availability Disaster Recovery]
 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.
  
 [*IBM Data Server Security*|Best Practice - Data Server Security]
 This Best Practices roadmap details how to protect data servers against the common data security threats, some uncommon threats, and useful countermeasures for these threats.
  
 [*Deploying IBM DB2 Products*|Best Practice - Deploying IBM DB2 Products]
 Discover best practices for deploying the DB2 9.5 family of products on Linux, UNIX, and Windows platforms across multiple computers quickly, easily, and consistently.
  
 [*Writing and Tuning Queries for Optimal Performance*|Best Practice - Writing and Tuning Queries for Optimal Performance]
 Learn best practices for minimizing the impact of SQL statements on DB2 database performance. This paper focuses on good fundamental writing and tuning practices that can be widely applied to help improve DB2 database performance.
  
 [*Tuning and Monitoring Database System Performance*|Best Practice - Tuning and Monitoring Database System Performance]
 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*|Best Practice - DB2 Workload Management]
 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.
  
 [*Deep Compression*|Best Practice - Deep Compression]
 Compression may reduce the storage requirements for your data server and improve performance. These Best Practices explain how to best use data row compression and table compression in the context of a larger storage strategy.
  
 [*Managing XML Data*|Best Practice - Managing XML Data]
 Get principles and guidelines for using DB2 pureXML™ to solve business problems effectively and to achieve high performance when managing XML data in enterprise applications - illustrated with a real-world example easily adapted to other types of XML applications. See Downloads for the files associated with this paper.
  
 [*Improving Data Server Utilization and Management through Virtualization*|Best Practice - Improving Data Server Utilization and Management through Virtualization]
 Discover best practices for deploying DB2 9 with the IBM System p™ virtualization technology. Select the right blend of virtualization features and their configurations to achieve desired business goals, while improving the utilization of IT resources.
  
 [*DB2 Workload Management*|Best Practice - DB2 Workload Management]
 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.
  
 [*Information Modeling with Rational Data Architect Version 7*|Best Practice - Information Modeling with Rational Data Architect Version 7]
 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. See Downloads for the sample file associated with this paper.
  
  
 [*DB2 High Availability Disaster Recovery*|Best Practice - DB2 High Availability Disaster Recovery]
 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.

    About IBM      Privacy      Contact