Articles & Content
Topic: DB2 for LUW
DATE: 2006-10-3 (10:15 - 11:15)
SPEAKERS: Serge Rielau (IBM Canada)
So you think a high bufferpool hit ratio is a sign of healthy SQL and application? Think again.This presentation shows you how to get the job done with minimal CPU and I/O, the shortest transaction times, and the fewest locks. Order queue processing, pivoting, and duplicate elimination are just a few of the problems we will tackle while learning about old and new SQL features along the way.
EXP. LEVEL: Intermediate,Advanced
How to use the transitive closure of SQL to extend it's power beyond mere joins.
Attendees will learn about recursive SQL
The perhaps most powerful new SQL feature introduced in past years: SELECT FROM UPDATE/DELETE/INSERT
MERGE/UPSERT processing will be introduced
Practical scenarios such a order processing applicable to customer shops.
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.