Articles & Content


DB2 9 for z/OS Select, Insert, Update, Delete SQL Application Performance (C04)

Topic: 2008 NA

Subtopic: DB2 for z/OS

DATE: 2008-5-19 (04:00 PM - 05:00 PM)
SPEAKERS: Akira Shibamiya (IBM Silicon Valley Lab)

This presentation provides a look at the performance impact of DB2 9 for z/OS from SQL performance viewpoint, primarily for Select, Open/Fetch, Insert, Update, and Delete.

EXP. LEVEL: Intermediate,Advanced


Sort performance improvement

Access path enhancement

Insert/Update/Delete performance enhancement

Data partitioned secondary index, native SQL procedure, and LOB performance enhancement

Varchar, Buffer Pool and I/O, and Declared Global Temp table performance enhancement

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.