These best practice papers present advice on the most optimal ways
you can utilize some of the exciting new features of InfoSphere Warehouse 10 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 product configurations. By applying
these recommendations, you may improve the value of your warehouse and align yourself with IBM's technical direction for
InfoSphere Warehouse. Additional best practice papers are in development, and more have already been published in the past on many of the features of InfoSphere Warehouse and DB2. You can find a complete listing on developerWorks
Speed up your queries in DB2 10 by using new features
that help you to improve the performance of your SQL and reduce
the complexity of tuning certain types of queries. "DB2 10 query performance enhancements
Get an introduction to
the new permission and mask dependencies in DB2 10 for Linux,
UNIX, and Windows, along with secure functions and secure
triggers. A scenario illustrates how to use row permissions and
column masks to meet required access controls.
"DB2 best practices: Data security in DB2 10, a practical guide to implementing row and column access control"
Achieve maximum storage space savings when you adopt various
compression strategies for your data. In this article, learn about
alternative row formats with value compression, row compression,
index compression, compression of temporary tables, compression of
backup images, and best practices.
"DB2 best practices: Storage optimization with deep compression in DB2 10"
Accurately track information
and data changes over time in order to efficiently address
auditing and compliance requirements using the temporal features
of DB2 10. "DB2 best practices: Temporal data management with DB2"
With the eGA of InfoSphere Warehouse 10.1 on April 30th, 2012, customers can now start putting these best practices in place and leverage the InfoSphere Warehouse 10.1 to move towards real-time operational warehousing and delivering temporal analytics.