Articles & Content

Archives

Partitioned Tables: Significant Enhancements in DB2 9.7 (and beyond) (C16)

Topic: 2010 EMEA

Subtopic: DB2 for LUW



DATE: 2010-11-11 (09:45 - 10:45)
SPEAKERS: Mike Winer (IBM)

This session will cover the significant enhancements to Partitioned Tables in DB2 for LUW since they were first introduced in DB2 9.1. To begin with, an overview of the partitioned table architecture, example use cases, ease of use using DDL, and best practices will be presented.New to DB2 9.7, partitioned indexes are now supported, allowing each data partition to be indexed separately compared to the non-partitioned indexes available in prior versions. This session will cover partitioned indexes and how they can improve and increase usability, scalability, performance, etc.In DB2 9.7 FP1, performance and availability on partitioned tables are improved. DETACH of a data partition no longer requires all current access to the table to drain, allowing long running queries to continue without impeding the DETACH operation. In addition, DB2 9.7 FP1 will also allow users to issue REORG operations on a single data partition vs. the entire partitioned table, allowing for faster REORG operations, increasing the availability to other data partitions of the partitioned table.We will share some ideas on a few additional enhancements that are on our white-boards, no commitments of course! The audience will have their own ideas of other things they might like to see from DB2 for partitioned tables. Time permitting, an open discussion will be held.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Receive an overview of Partitioned Tables in DB2 for LUW. Understand fundamentals, ease of use, best practices.

Learn about partitioned indexes introduced in DB2 9.7. Migration strategies for those coming from pre-9.7. Hear when non-partitioned indexes may still be valuable.

DETACH provides a greater availability in DB2 9.7 FP1. Understand the details of this change in behavior and the benefits from prior versions.

Partition level reorg is available in DB2 9.7. Get information on how this improves performance and availability of the table during reorg processing.

Hear what's being discussed internally in a future release, and have the opportunity to provide additional requests.



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.