Articles & Content

Archives

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

Topic: DB2 for LUW

Subtopic: 2006



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

OBJECTIVES:

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



Click Here to Download

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