Articles & Content


DB2 9.5 Partitioned Database (DPF) Enhancements: Get the Details! (C01)

Topic: DB2 for LUW

Subtopic: 2009

DATE: 2009-10-5 (11:30 - 12:30)
SPEAKERS: Melanie Stopfer (IBM Software Group)

Are you familiar with the DB2 9.5 enhancements for DPF Databases? Learn the details about new processing options for the REDISTRIBUTE utility provided by DB2 9.5 FixPak 1. These changes allow tables in partitioned databases to be redistributed in a much more efficient manner that previous DB2 releases. Learn how DB2 Advanced Copy Services support in DB2 9.5 can simplify high performance database backup and recovery operations exploiting hardware based flashcopy functions. Single System View approach to backup and recovery of DPF partitioned DB2 databases and changes to UPDATE DATABASE CFG that simplifies administration for partitioned databases will be covered. This presentation will give you the details on how to implement the new features of DB2 LUW Data Partitioning Feature (DPF).

EXP. LEVEL: Intermediate,Advanced


Implement DB2 9.5 REDISTRIBUTE to efficiently redistribute data to new partitions or remove partitions, reduce need to reorganize tables after redistribution, explain impact on recoverability

Utilize STOP AT and TABLE options to better manage large data redistribution operations for partitioned databases

Plan and implement DB2 Advanced Copy Services for high performance database backup and restore

Utilize Single System View in DB2 9.5 to simplify backup and recovery of DPF databases

Implement new features of DB2 LUW Data Partitioning Feature (DPF)

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.