Discover the 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.
These Best Practice papers present advice on the most optimal ways you can use DB2 to satisfy key business data processing needs. These papers are authored by leading experts in IBM's development and consulting teams, and have been extensively tested.
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.
Additional Best Practice papers are in development, and will be published here as they become available. If you would like to suggest a new Best Practice topic or you have comments or feedback on the current Best Practices, please send us feedback. Please include the title of the Best Practices you are specifically commenting on in your message.
"
Database
Storage
" (May 2008)
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. (pdf; 478KB; 17 pages)
"
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. (pdf; 1,539KB; 63 pages)
"
Data
Life Cycle Management
"
(May 2008)
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. (pdf; 667KB; 33 pages)
"
Minimizing
Planned Outages
"
(May 2008)
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. (pdf; 524KB; 25 pages)
"
IBM
Data Server Security
"
(May 2008)
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. (pdf; 949KB; 37 pages)
"
Deploying IBM DB2 Products
"
(May 2008)
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. (pdf; 756KB; 46 pages)
"
Writing
and Tuning Queries for Optimal Performance
"
(May 2008)
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. (pdf; 646KB; 38 pages)
"
Tuning
and Monitoring Database System Performance
"
(May 2008)
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. (pdf; 804KB; 58 pages)
"
Deep
Compression
"
(June 2008)
Compression will reduce the storage requirements for your data server
and often will improve performance. These Best Practices explain how to best use data row compression and table compression in the context of a larger storage strategy. (pdf; 523KB; 25 pages)
"
Managing XML Data
"
(May 2008)
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. (pdf; 930KB; 77 pages)
"
Improving
Data Server Utilization and Management through Virtualization
"
(May 2008)
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.
(pdf; 704KB; 35 pages)
"
Frequently
Asked Questions from Problem Management Reports
"
(May 2008)
Get answers to the most common questions that DB2 customers have
about the DB2 data server.
(pdf; 505KB; 21 pages)
| Description | Name | Size | Download method |
|---|
| Sample code for Managing XML data paper | DB2BP_XML_data_code_0508I.zip | 8KB | HTTP |
|---|
| 
