Articles & Content
Topic: 2008 EU
Subtopic: DB2 for z/OS
DATE: 2008-10-14 (16:45 - 17:45)
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
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
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.