Agenda - PITT DUG - March 17th - sign up now!!!

Chris Straub

Agenda - PITT DUG - March 17th - sign up now!!!

Here's the agenda for the next Pittsburgh DB2 Regional User Group. The
meeting will be held at the Highmark Caring Place on Stanwix Street on
Tuesday, March 17th. Sign up now by sending Chris Straub or Marlene Gaydos
an email (see below for email addresses).

Pittsburgh Regional DB2 User Group
Date: Tuesday, March 17th, 2009
Place: Highmark Caring Place 620 Stanwix Street (next to Max & Erma’s)
Cost: FREE
Reservations: Email or call:
*[login to unmask email] 412.544.5352
*[login to unmask email] 412.544.7006

Agenda for March 17th, 2009
8:45 - 9:00 Welcome

9:00 – 10:15 DB2 Performance Tuning Roadmap
Presenter: Craig Mullins, NEON Enterprise Software, Inc
This presentation will discuss DB2 for z/OS performance management and
tuning issues. It offers multiple guidelines and tips for achieving optimal
performance broken down into specific categories. The presentation will
touch on many aspects of DB2 performance that span the application, the
databases, and the overall system. Refresh your knowledge of DB2
performance with these handy DB2 oppor-TUNE-ities.

Key topics covered include:
* The Tuning Progression: development versus maintenance
* Application Tuning: application code and SQL
* Database design and implementation: DDL, indexing, and organization
* System Tuning: DB2 subsystem issues
* The Environment: OS, TP, Network

10:15 - 10:30 Break

10:30 - 11:45 DB2 9 for Developers Only
Presenter: Craig Mullins, NEON Enterprise Software, Inc
This presentation highlights the DB2 9 for z/OS enhancements that directly
impact DB2 application developers. Every release of DB2 is chock full of
new features and functionality and that can make it hard to focus on those
things that are most helpful for programmers. So instead of scanning
volumes of manuals, this presentation covers what should be most important
to programmer/analysts.

Examples of areas this presentation will cover include:
* A brief overview of DB2 9 XML capability
* New data types and functions
* New SQL statements like INTERSECT, EXCEPT, MERGE, and TRUNCATE
* The ability to SELECT FROM and UPDATE, DELETE, or MERGE statement
* Improvements to existing SQL

If you are a programmer wanting to learn more about DB2 9, or a DBA looking
for the programmer’s perspective on DB2 9, this presentation should have
something to offer you.

11:45 - 12:30 Closing

Welcome to the DB2 User Group - Pittsburgh list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG Listserv FAQ is at The DB2 User Group - Pittsburgh List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at