Besides Talking about performance on the night of Sept 28th down at
the airport, make a note for October 6, 2005 at the Holiday Inn in
Ft. Washington

A Full Day of SQL for the iSeries
With IBM's Linda Swan

This one-day seminar explores the issues regarding the development
and deployment of the latest in iSeries SQL. We start with a quick
review of the basics and then hit the ground running.

Our agenda for the day will run like:

Introduction to SQL on iSeries. SQL is IBM's relational database
language that can be used for query and for data definition,
manipulation and retrieval. It is a simple, yet extremely powerful
tool. In this session we will learn: The basic concepts of SQL,
usage for data retrieval and database management, usage in
application programs and finally use of interactive SQL.

SQL Performance Basics for the iSeries. If you are thinking of using
or have used SQL on the iSeries, then you need to understand 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).

SQL Advanced Functionality Sampler. Come and hear an overview of the
functionality contained within the iSeries database. We'll highlight
the state-of-the-art, advanced database functions like referential
integrity, triggers, stored procedures and predictive query
governor. These enhancements make the iSeries relational database
one of the best in the industry.

SQL Stored Procedures. Stored Procedures are a valuable tool for
improving performance in distributed and networked environments. In
addition, they can also be used to improve the flexibility and
design of your applications. SQL Stored Procedures offer a procedure
language that is comparable with stored procedure languages of other
DB Servers such as Oracle and SQL Server. By the end of this
sessions you should know how to: create and invoke an SQL Stored
Procedure, understand error handling techniques in SQL Procedures,
and how to move an SQL Stored Procedure into production.

And we'll end the day with:

Using DB2 Monitors to Analyze and Improve SQL and Query Performance.
Have you ever tried to solve a query or SQL performance problem with
someone else's program and not known where to start? One of the
tools that can help is the iSeries most overlooked performance
monitors, the database performance monitors. The data collected by
the integrated DB2 monitors during runtime can be used to identify
which database requests are causing the biggest performance issues.
In this session we'll go over: Collecting database performance
monitor data, Understanding the data that's being collected and how
it's organized, How to use the data to identify and fix performance
problems.



Linda Swan is a senior software engineer at IBM Rochester. She's
currently the team leader of the optimizer component of the SQL
Query Engine. Linda previously worked in the Database area in the
early 90's as team leader of the SLIC journal and commit recovery
team. In the number of years between her two assignments with in
iSeries Database, Linda worked as a developer on database related
projects involving workflow, Domino and XML.



This course starts at 8:30 AM and ends at 5:00 PM and will be held
on October 6, 2005 at the Holiday Inn in Ft. Washington, PA.
Registration will start at 8:00 AM. Continental breakfast during
registration as well as a working lunch are included in the course
fee.
The course fee is $275 for non-user group members and $250 for user
group members.

To register,

http://www.wash-midrange.org/seminars/swan0510.shtml