Articles & Content
Topic: 2010 EMEA
Subtopic: DB2 for z/OS
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
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
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.