Articles & Content
Topic: DB2 for LUW
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.