$1,500.00 per student
Day 1
DPF Overview
Partitioning Strategies
Hash Partitioning
Range Partitioning (New in DB2 9)
DB2 Use of Parallelism
Scaling Out with DPF
Hardware and Software Configurations
DB2NODES.CFG File
TCP/IP Ports
Day 2
Nodegroups
Partitioning Key Best Practices
Partitioning Maps (PMAPs)
Maintenance of PMAPs
Identifying Data Skew
Range Partitioning
Identifying Appropriate Range keys
Maintenance of Range Partitioned Tables
Roll-In/Roll-Out Range Partitions
Day 3
Optimization in Partitioned Databases
Directed Joins
Broadcast Joins
DB2 Explain for partitioned joins
Colocated tables
Table Queues
Day 4
Administering Partitioned Databases
DB2 Commands
Backup and Recovery
Disaster Recovery
Runstats
Problem Determination and Troubles