Articles & Content

Archives

Faster Fetch, Insert, Update (MERGE) - DB2 for z/OS Multiple Row Processing (E05)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS



DATE: 2010-11-9 (11:00 - 12:00)
SPEAKERS: Chris Crone (IBM)

DB2 V8 added Multiple Row Insert and Fetch. DB2 V9 adds Multiple Row processing for INSERT/UPDATE with the MERGE statement. With these enhancements, a single FETCH can be used to retrieve multiple rows of data, an INSERT can insert one or more rows into a table, and in DB2 9, with the new MERGE statement multiple rows can be INSERTed or UPDATEd. This reduces the number of times that the application and database must switch control, as well as reducing the number of network trips required for for distributed requests. For some applications, this can help performance dramatically. This presentation is about this new DB2 V9 and V9 function, highlights the performance advantages of this new function and discusses the implementation issues for customers who wish to take advantage of MRF, MRI, and MRM (in V9)

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Overview of the new syntax needed by traditional applications to use Multiple Row Fetch, Insert, and Merge (V9 only)

Understand how Multiple Row Insert and Merge works

Understand how Multiple Row Fetch works

Understand the power of GET DIAGNOSTICS and where it may be appropriate or necessary to use GET DIAGNOSTICS

Highlight the benefits of DB2 V8 and V9 new function to reduce CPU cost.



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.