407101

SQL Performance Basics for the iSeries

Speaker(s):
Kent Milligan IBM Corporation


If you are thinking about using or have used SQL on the iSeries, here's some performance background on how the iSeries database engine handles SQL requests. This session covers performance concepts that apply to any SQL interface (embedded SQL in applications, JDBC, ODBC, etc.).

In this session, learn:
1. The basics of access plans, open data paths (ODPs), and reusable ODPs.
2. The direct performance effects of these concepts.
3. Other tips on how to code high-performing SQL on the iSeries.


35MO: Tuesday, 02:00-03:15 pm, B214Add To My Personal Grid Handout

One & 1/4 hrs
Course of Study: DB2 UDB for the iSeries

Handout available on web