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.