IDUG 2008– North America
May 18-22, 2008
Hyatt Regency Dallas
Dallas, Texas, USA

IDUG - North America's pre-conference educational seminars provided high-level insight into the latest in DB2.

DB2 LUW Performance Diagnosis Learning Lab

Scott Hayes, Database-Brothers Inc.
Audience focus: DB2 for LUW

This seminar is unlike any other. Bring data from your database and learn, step by step, how to methodically analyze and understand it. Discover where and how your database is experiencing pain and ineffi ciency, and learn the configuration settings and physical design techniques required to improve the performance of your database. Through this seminar discover all this and much more to help you maximize your performance.

Registrants of this seminar should download the prep material as instructed in this link: www.dbisoftware.com/db2mag/GettingReady-IBMDB2LUW-Performance-Diagnosis-Lab.pdf.

DB2 v9 Database Administrator Certification Exam (Exam 731) Preparation

Roger Sanders, Roger Sanders Enterprises, Inc.
Audience focus: DB2 for LUW

Learn the objectives for the 731 exam and become an IBM Certifi ed Solutions Expert. This seminar is designed to introduce the concepts a test candidate must know in order to take and pass the FREE DB2 9 for Linux, UNIX, and Windows Database Administration certifi cation exam (exam 731).

SOA in the Real DB2 World

Robert Catterall, Catterall Consulting
Audience focus: Cross Platform

On paper, Service-Oriented Architecture looks great.It can deliver tangible benefi ts for an organization; however, there are situations that can make implementing SOA a very challenging endeavor. This seminar will address real-world SOA-related issues, while helping to demystify SOA terminology and enabling technology.

High Performing SQL Clauses

Sheryl Larsen, Sheryl M. Larsen, Inc.
Audience focus: Cross Platform

This seminar concentrates purely on SQL clauses from DB2 V1 through DB2 9 and any known future releases. Using real world examples, you will learn secrets for effi ciently
turning your corporate data into explosive information.

DB2 9 for z/OS – In Depth

Phil Grainger, CA
Audience focus: DB2 for z/OS

Although it only seems like yesterday, DB2 Version 8 was released nearly four years ago. Now, we already have its replacement in the form of DB2 9 for z/OS. This seminar will take you step-by-step through all of the changes, new features, and expanded functionality of this latest release of DB2 for the mainframe platform.

Getting Started with XML and DB2

Rav Ahuja, IBM Toronto Lab; Matthias Nicola, Guogen Zhang, Mengchu Cai, Jason Cu, IBM Silicon Valley Lab

Audience focus: Cross Platform

Relational databases have evolved to also manage XML data. DB2 9 for zOS and DB2 9 for Linux, Unix and Windows have a hybrid engine that supports XML to the core along with the existing relational capabilities. This seminar introduces XML, its role in information management, and provides an in-depth view of the pureXML capabilities in DB2 9. You will learn how to use the XML data type in DB2, how to index XML data and how to query it with SQL/XML. Additionally, we’ll discuss best practices for the DBA and give a live demo of key pureXML features in DB2. The majority of the pureXML functionality is identical across the DB2 platforms, and will be presented as such. A break-out session in the afternoon will discuss platform-specific implementation details for zOS and Linux, Unix and Windows respectively. Attend this seminar if you want to become a subject matter expert for DB2 pureXML, irrespective of your current XML skill level.

DB2 for z/OS Advanced Programming: Stored Procedures, UDFs, and Triggers

Daniel Luksetich, YL&A
Audience focus: DB2 for z/OS

Stored Procedures, Triggers, and User-Defi ned Functions are new DB2 features which signifi cantly enhance and expand application design possibilities and require coding techniques quite different from traditional methods. This seminar will cover what these advanced features include as well as how to design, implement, and tune them.

DB2 9 for z/OS DBA Administration Certification Crammer Course

Susan Lawson, YL&A
Audience focus: DB2 for z/OS

This high-level certifi cation preparation course will help you successfully complete IBM’s FREE DB2 9 Family Fundamentals exam (730) and DB2 9 for z/OS Database Administration exam (732). Passing these exams will result in certification as an IBM Certified Solutions Expert - DB2 9 z/OS Database Administration.

An ALL NEW “Things I Wish They’d Told Me…”

Bonnie Baker, Bonnie Baker Corporation
Audience focus: Cross Platform

Bonnie is back with an all new seminar that continues the tradition of delivering content-rich education. War stories, analogies, and examples will be used to explain application design, object design, program logic, and SQL impact application performance.