Articles & Content

Archives

DB2 for z/OS Optimizing Insert Performance - Part I (B06)

Topic: 2010 NA

Subtopic: DB2 for z/OS



DATE: 2010-5-12 (09:45 AM - 10:45 AM)
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: 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



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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.