Db2 LUW performance with partitioned databases (CL443G)

• Teams with data warehouses spread across partitions.
• DBAs about to partition a database that has outgrown one box.
• Anyone whose reports cross partitions and take too long.

• Database monitoring
• Database I/O management
• Table space and table design for performance
• Db2 memory management
• Automated memory management
• Performance seen from the application
• The explain tools
• The Db2 optimizer: how it decides
• Using indexes for performance
• Complex SQL performance
• Performance tools and utilities
• Event monitors

• Day 1: monitoring and I/O management
• Day 2: table space and table design, and memory management
• Day 3: performance from the application, explain and the optimizer
• Day 4: indexes, complex SQL and utilities
• Day 5: event monitors and the multiple partition case

• Labs on your own Db2 LUW release, on Linux, AIX or Windows depending on what you run.
• Taught directly by IBM Champion instructors from the SIXE team.
• Credly badges available: credly.com/organizations/sixe/badges
• Flexible format — online, classroom or onsite — in closed groups, priced per attendee, in the language of your choice (ES / EN / FR).

How does it differ from CL413G?
By one day and by scope: CL413G covers the single-partition case and this one extends to databases spread across several partitions. With no partitioning, the four-day course is enough.

Does it cover range partitioning within a partition?
Table and table space design for performance is in both courses. Spreading data across several database partitions is what is specific to this one.

How is it organised and what does it cost?
It runs as a closed group, priced per attendee. Tell us how many you are, which release you run and which dates suit you, and we will send a proposal.

• CL413G — Db2 LUW performance, single partition (four days)
• CL463G — Advanced administration with BLU Acceleration (table partitioning and MDC)
• CL207G — Db2 12.1 administration workshop (the groundwork)