Chris Straub

Due to circumstances beyond our control, the March 17th Pittsburgh DB2 User Group will be moved to the Highmark Penn Avenue Place Auditorium.

Non-Highmark employees will need to pick up temporary badges at the security desk inside Fifth Avenue Place (the Highmark building). Once you've attained your badge, you will then proceed up the escalators and make a right and walk across the skywalk to the Auditorium (which will be on your left).

Please allow a few extra minutes to pick up your badges.

Hope to see everyone on the 17th.

Here's the agenda for the next Pittsburgh DB2 Regional User Group.
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 Penn Avenue Place Auditorium
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:00 Closing

This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.

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