Articles & Content

Archives

Quit Calling DB2 So Much! (Part 2 of 2) (C07)

Topic: 2009 NA

Subtopic: DB2 for z/OS



DATE: 2009-5-13 (01:30 PM - 02:30 PM)
SPEAKERS: Daniel Luksetich (YL&A), Susan M Lawson (YL&A)

In this presentation will look at ways reducing the number of calls you make to DB2 z/OS via exploitation of V8/V9 SQL features for SQL call reduction. The quantity of SQL calls made can sometimes be more detrimental to performance than poor quality SQL. Don’t be fooled by low response times per statement and high bufferpool hit ratios! So, here we’ll look at ways of using V8 and V9 SQL and application features to help reduce the number of trips we make across the address spaces in DB2 z/OS.

EXP. LEVEL: Intermediate

OBJECTIVES:

Why to reduce SQL calls

How to reduce quantity of calls with V8 SQL features

How to reduce quantity of calls with V9 SQL features

How to detect SQL problems of this nature

How to improve overall SQL performance



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.