DB2 V10.1 Multi-temperature data management recommendations

Using faster, more expensive storage devices for hot data and slower, less expensive storage devices for cold data optimizes the performance of the queries that matter most while helping to reduce overall cost.

In this article

This paper presents a strategy for managing a multi-temperature data warehouse by storing data on different types of storage devices based on the temperature of the data. It provides guidelines and recommendations for each of the following tasks:

  • Identifying and characterizing data into temperature tiers.
  • Designing the database to accommodate multiple data temperatures.
  • Moving data from one temperature tier to another.
  • Using DB2® workload manager to allocate more resources to requests for hot data than to requests for cold data
  • Planning a backup and recovery strategy when a data warehouse includes multiple data temperature tiers

The content of this paper applies to data warehouses based on version 10.1 or later of DB2 Database for Linux, UNIX, and Windows.

For additional best practices to help you implement multi-temperature data management with earlier versions of the DB2 software, refer to the best practice article "Multi-temperature data management" located in the Resources section.


Downloadable resources


Related topics

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=812384
SummaryTitle=DB2 V10.1 Multi-temperature data management recommendations
publish-date=04302012