DB2 Large Partitioned Table Space Design Performance

Audience:Application Developers, Database Administrators, Data Warehouse Specialists and Capacity Planners.Prerequisites:A working knowledge of DB2 objects and architecture.Summary:This course places especial emphasis on the design, implementation and performance of large tables; our definition of a large table is one of 500MG or greater. However, the course discusses why smaller tables should be partitioned if they are to be joined with large tables.
As parallelism is a complementary functions, it is discussed as an integral aspect of partitioning.Objectives:Upon completion of this presentation, the participant should be able to design partition tables and related indexes to optimise performance. Additionally, the delegate should be able to use the DB2 EXPLAIN and accounting reports to determine if parallelism goals are being met.