Agenda for 3rd Quarter Meeting - September 15, 2010 

	DB2 FOR z/OS TRACK	DB2 FOR LUW Track
08:30am - 09:00am	Registration - Coffee, juice and rolls	Registration - Coffee, juice and rolls
09:00am - 09:15am	Welcome and IBM Announcements	Welcome and IBM Announcements Debra Eaton, IBM
09:15am - 10:30am	DB2 9 & 10 FOR z/OS SQL Update Sheryl Larsen, SMLI The presentation is all about taking the developer from Version 8 competency to DB2 9 & 10 competency in the area of application development. Sheryl will emphasizes all the new SQL, optimization, table and index features available for DB2 9 & 10. Any differences in the current release of DB2 on LUW will also be discussed	The Business of Database Availability Dale McInnis, IBM Dale will outline the numerous elements that make up database availability to help you on your want to being a more effective advocate for the right level of availability for your business. Understanding all the elements that make up availability, such as planned vs unplanned outages, seamless scalability, availability during upgrades and much more. Each level of availability comes with a cost tradeoff. Dale will help you understand how to position the many types of availability to your business.
10:30am - 10:45am	Break	Break
10:45am - 12:00pm	Lessons Learned from SQL Performance Reviews Sheryl Larsen, SMLI The presentation divulges discoveries and recommendations from various SQL performance review assignments. Come see if you have similar SQL performance issues and get the instructions on how to fix them. Issues discussed include non-optimal index design, access paths gone wild, Stage 2 predicates, misuse of SQL, excessive sorting, delayed filtering, lack of implementation of powerful new SQL features.	Practical Options and Trade-Offs for Database Availability Dale McInnis, IBM Dale will review the practical options to enable your availability plan. Whether it is simply making sure your system will recover from a software restart or achieving continuous availability there is an strategy for DB2 that is the right match between your business goals and the right technology. Dale will also outline options for moving up from simple and quick availability options to comprehensive solutions over time.
12:00pm - 01:15pm	Lunch - on your own	Lunch - on your own
01:15pm - 02:30pm	Advance Features in DB2 for z/OS: Spatial Support and OmniFind Text Search Frank Butt, IBM This session will examine 2 new features of DB2 for z/OS and several customer related examples. 1. Spatial Support allows application to query location information stored in DB2. For example, find all the restaurants within 1 mile of my current location. GPS and map related questions can now be answered by using a spatial query against DB2. 2. OmniFind Text Search allows applications to perform free-form text search rapidly by utilizing text search indexes. Applications no longer need to use the LIKE predicate for search large volume of structure and unstructured text data in various formats.	DB2 pureScale Deep Dive and Live Demonstration Brian Olynyk, IBM Brian will walk you through a deep technical dive and live demonstration of DB2's latest high availability and scalability solution, DB2 pureScale. After explaining the clustering technologies at the heart of DB2 pureScale, Brian will demonstrate how it can easily scale through multiple members in a DB2 pureScale cluster. He will demonstrate how it can recover from hard and soft member failures and how DB2 pureScale keeps running even when the cluster coordinator software is shutdown.
02:30pm - 02:45pm	Break	Break
02:45pm - 04:00pm	DB2 10 for z/OS DBA Improvements Mark Rader, IBM DB2 10 for z/OS offers a number of features that will affect DBAs in the product focus areas, such as Performance, Availability, Reliability, etc.. In addition, DB2 10 for z/OS includes DBA-specific features to improve DBA productivity. This presentation will address both areas to prepare those in the audience for the exciting new release of DB2 for z/OS.	DB2 Health Advisor Service Alex Abrashkevich, IBM Analysis of DB2 PMR data shows that approximately 20% of outages could have been avoided had obvious warning signs been detected and acted upon. Already available in DB2 v9.7 FP1, v9.5 FP6 and v9.1 FP9, the new DB2 Health Advisor is a free early warning detection service that will help alert customers to potential problems before they become outages. It is a proactive/reactive support SaaS (software as a service) technology that is non-intrusive and utilizes up to date analytics from subject matter experts across DB2. The main goal of the service is to leverage the expertise and knowledge back at IBM to productively avoid problems, reduce the bar of adoption, lower total cost of ownership and return on investment when using DB2. It is based on DB2 best practices, recommendations from DB2 subject matter experts and customer knowledge database. DB2 Health Advisor architecture and main components (data collector, analysis engine and reporting engine) built using the latest IBM technology (Cognos, CEP, DWE, etc.) are presented. Usage scenarios for the service are explained in details. Intended usage, business and technical value of the DB2 Health Advisor Service for DB2 customers are discussed.

MWDUG Speakers for September 15, 2010 Meeting 

MWDUG's office has moved to a new location. Our new address and phone information is: 

MWDUG c/o Technical Registration Experts, Inc. (TREX) 
303 West State Street
Geneva, IL 60134  
Phone: 630-578-3991
Fax: 630-262-1520 
E-mail:  mwdug@trexperts.com