Articles & Content

Archives

DB2 for z/OS Optimising Insert Performance (A15)

Topic: DB2 for z/OS

Subtopic: 2010



DATE: 2010-11-11 (08:30 - 09:30)
SPEAKERS: John Campbell (IBM DB2 for z/OS Development)

This presentation will introduce the typical performance bottlenecks and tuning (read and write I/O for Index and Data, active Log Write, CPU Time, Lock/latch Contention and Service Task Waits, use of Multi Row Insert, Use of INSERT vs. LOAD utility, and the design point for significant new features of DB2 9 for z/OS to improve performance and how best to use them (Reduced LRSN Spin and Log Latch Contention, Increased Index Look aside, Asymmetric Index Leaf Page Split, Randomized Index Key), Table APPEND option). It will also include a preview of the specific features of DB2 10 for z/OS which can improve insert performance.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Understand typical performance bottlenecks

How to design and optimise for high performance

How to tune for optimum performance

Understand the new features of DB2 V9

Understand how to best apply and use new features



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.