Articles & Content


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

Topic: DB2 for z/OS

Subtopic: 2008

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

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.