Articles & Content


Faster MDC inserts & deletes in DB2 V8.2.2 Saturn (F01)

Topic: 2006 NA

Subtopic: DB2 for LUW

DATE: 2006-5-8 (10:20 AM - 11:30 AM)
SPEAKERS: Bishwaranjan Bhattacharjee (IBM Research)

In data warehousing, users tend to do mass inserts (rollin) and mass deletes (rollout)of data. These tend to be time and log intensive activities.In DB2 V8.2.2, for Multi Dimensional Clustering (MDC) tables, new features have been added which help accelarate rollin and rollout.In this presentation we describe these features, present performance figures & discuss how they can be combined with current best practices

EXP. LEVEL: Intermediate


Preliminary Introduction to MDC

Issues of Rollin and Rollout

Faster MDC Deletes in DB2 V8.2.2 (Saturn)

Faster MDC Inserts in DB2 V8.2.2 (Saturn)

Using Faster MDC Inserts in ETL

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.