Articles & Content


DB2 for z/OS Optimising Insert Performance (A04)

Topic: DB2 for z/OS

Subtopic: 2009

DATE: 2009-10-6 (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).

EXP. LEVEL: Intermediate


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.