Articles & Content

Archives

First DB2 Cobra Experiences: Index Compression in SAP BI/BW (C13)

Topic: 2009 EU

Subtopic: DB2 for LUW



DATE: 2009-10-7 (15:45 - 16:45)
SPEAKERS: Stefan Hummel (IBM Software Group), Joachim Stumpf (IBM Software group)

Data and index compression becomes more and more important with the increase of database sizes. There is not only the advantage of lower disc usage. As important is the positive effect of less I/O operations, thus the response times of user transactions and administrative tasks are lower.This session will explain the concepts of the new DB2 Index Compression feature and gives experiences made with DB2 Cobra during the beta test in a real customer environment.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

The architecture of a DB2 Storage Optimization

Analyze the database (data and indexes) in terms of compression candidates (tools and approach)

Technique to compress indexes and release physical disc space

Compression within a SAP system copy (homogenous/heterogenous)

Performance impacts



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.