Welcome to the MWDUG Website!


Please take a moment to review our site.  Our next meeting will be held Thursday, December 8, 2011 at the IBM Chicago Technical Exploration Center (TEC). The IBM TEC is located in the Hyatt Building on 71 South Wacker in Chicago.

Click here to register for the 4th Quarter Meeting - December 8, 2011.

Walk-ins are welcome for only $35.00 daily fee applicable to a full year membership.




Agenda for Our Next Meeting

Agenda for 4th Quarter Meeting - December 8, 2011

  DB2 FOR z/OS TRACK DB2 FOR LUW Track
08:30am - 09:00am Registration Registration 

 

09:00am - 09:15am Welcome and IBM Announcements

Welcome and IBM Announcements
David Chiou, IBM

09:15am - 10:30am Gain Insight into DB2 9 and DB2 10 for z/OS Performance Updates and Save Costs
John Tolber, IBM

In this session, we will discuss the latest updates for system and application performance on IBM DB2 9 and DB2 10 for z/OS.  Beginning with performance impact and tuning at the system and application level, we'll have a special focus on topics requested by product representatives and field inquiries. This session will also cover DB2 10 for z/OS and its improved performance and scalability - including general CPU usage reduction and scalability, buffer management, and insert and select functionality - in addition to the reduction of virtual storage constraints. Other topics include improvements to DDF, JDBC, SQLPL and line-of-business performance.  You'll also learn how DB2 9 and DB2 10 interact with IBM z10 and z11 processors.

Achieve Table Maintenance within DB2 - Online and Efficiently
Maciej Mazur, IBM

This session reviews the pros and cons of available reorganization (reorg) options and then discusses the new feature in IBM DB2 9.7 - online table move.  We will discuss best practices to follow for achieving reorg using this utility, including strategies for how and when to take backups in order to maintain recoverability.  This session discusses an optimal way to combine all the reorg options - when to use offline or online reorg, online table move and DB2s automatic reorg facility.  We will also discuss options available with RUNSTATS to minimize its effect on user workload, including strategies to use sampling, throttling, statistics profiles and DB2s automatic RUNSTATS facility. 

 

10:30am - 10:45am Break Break

 

10:45am - 12:00pm

Looking Behind the Curtain of IBM DB2 for z/OS 10 Performance and Scalability Metrics and Storage Analysis
John Tolber, IBM

Two primary focuses for DB2 for z/OS are scalability and performance. In order to maximize the potential of DB2 for z/OS 10, an understanding of storage scalability metrics and DB2 statistics and transaction accounting is a must. This session will cover the critical metrics for maximizing scale and system stability, as well as storage instrumentation. 

 

Demystifying Logging and Recovery in DB2 for Linux, UNIX and Windows
Maciej Mazur, IBM 

For many DBAs, how DB2 captures the changes to a database and uses that capture to recover from failures is a mystery. But because over 20% of the more than 100 configurable database configuration parameters are related to logging and recovery, it is important to understand how this works, how you can be sure that you are logging in an efficient matter and that you are protected from various types of failures. In this session, you will learn about logging strategies, how to properly configure the most important parameters, and how to monitor the logging that is happening in your environment. Topics also include mirrored logging, infinite logging, parallel recovery, log archiving, types of recovery, and methods for limiting what gets logged.

12:00pm - 01:15pm Lunch - Free onsite Lunch - Free onsite

 

01:15pm - 02:15pm

Database Performance Discoveries and Recommendations
Dave Beulke, Dave Beulke and Associates

Is your database application experiencing poor response time, scalability problems, and too many deadlocks or poor application performance? One or a combination of zParms, database design and application coding techniques can cause these performance issues.

There are many new DB2 9 and DB2 10 techniques, system parameters, database design, and application coding methods to avoid problems and revitalize your older databases' performance. This presentation will take you through the discoveries found during recent performance reviews and you will learn about the latest recommendations for fixing your database and application performance problems.

Hadoop, IBM Big Insights and Your Future - What you need to know to succeed 
Michael Nobles, IBM

Hadoop is one of the latest buzz works being thrown around these days. Do you know what it is? Have you seen it in action? How much time should you be devoting to learning it?  What's the easiest path to get there? In this 90-minute session, we will cover the basics of Hadoop, the technical underpinnings of Hadoop, how Hadoop compliments the other areas of Information Management you are potentially performing in your jobs today, a demo of IBM's Hadoop-based product as well as where to get free education and a free product trial to help you get started.
02:15pm - 02:30pm

Break

Break 
02:30pm - 03:45pm

TBD
 

DB2 LUW Editions and DB2 Tools Overview 
David Chiou, Chicago, IL

Are you aware of taking advantage of all the tools that come with DB2? Learn the details on the different editions of DB2 for Linux, UNIX, and Windows and what is included. Features such as Replication, Federation, HADR, pureXML and all the DB2 feature packs including Performance Optimization, Advanced Access Control, Geodectic, Storage Optimization, Workload Management and pureScale will be reviewed. A quick overview of DB2 High Performance Unload, DB2 Merge Backup, DB2 Recovery Expert, Data Studio and Optim tools, including Optim Performance Manager, Optim Performance Manager Extended Insights, Optim Development Studio, Optim Database Administrator, Optim Query Tuner, Optim Query Workload Tuner and Optim pureQuery runtime will be covered. Finally, a review of the various DB2 data warehouse tools including Cubing Services, Intelligent Miner, Text Analytics, Design Studio and Mashup Center will be discussed. If you haven't heard of some of these tools or are looking for a capability and not sure what tool provides it, be sure to attend this session.



Speaker Bios for December 8, 2011 Meeting

Dave Beulke is an internationally recognized DB2 consultant with over 25 years in the industry, performs application performance reviews for Fortune 500 clients. He is known for his extensive expertise in DB2 high performance development and tuning. Dave's expertise is in business intelligence data warehouse, Internet applications, Java architectures and system/application performance. Dave is a frequent speaker at local, national and international conferences, is a co-author of the IBM V8 and V7 z/OS DB2 Certification exams, and the Business Intelligence Certification exam, as well as a columnist for DB2 Magazine and former editor of the IDUG Solutions Journal. Dave has also been an instructor for The Data Warehouse Institute (TDWI) and a past president of the International DB2 Users Group.

Dave is a member of IBM's DB2 Gold Consultants program and a member of IBM's Information Champion program. Through his consulting service experiences,  Dave researches performance and has dramatically reduced CPU demand for his clients, saving them from unnecessary hardware upgrades and millions in processing charges.
 
Dave Chiou is a Certified Consulting Software IT Specialist from Chicago, Illinois. He has over 20 years of experience working in technical presales and assisting IBM clients with database, database tools, data privacy, data archiving, business intelligence and data warehouse implementations. His current responsibility is software presales technical support for customers in the Midwest area.

Maciej Mazur is a member of the IBM WW Information Management Technical Sales Team, providing DB2 technical and competitive insight to IBM customers and IBM technical and sales professionals world-wide. Based out of the IBM Toronto Lab, Maciej previously worked within the User-Centered Design group of the DB2 development team, contributing to feature development in product areas such as High Availability and Disaster Recovery, Installation, and Performance Monitoring/Troubleshooting.

Michael Nobles is a Consulting Solution Specialist at IBM. Having been a part of all aspects of software development since 1992, Michael has had some fun times in the software industry. Back in 2001, he started working in the area of Business Intelligence (BI) for all industries and joined IBM in 2004. More recently, Michael has added Hadoop, Big Data, and real-time BI to his areas of expertise. With IBM's products, named InfoSphere BigInsights and InfoSphere Streams, he is working to help the world, one company at a time, with their "data in motion" and "data at rest" challenges. As a Technical Pre-sales Professional, covering all of North America, on the IBM InfoSphere Warehouse, Advanced Warehousing Team with a focus on Big Data, Michael looks forward to helping his potential customers grow and succeed.

John Tobler is a senior developer and designer for DB2 and z/OS.  He has worked extensively on instrumentation, agent services, and storage management.  He has lead numberous projects focused on autonomics, serviceability, and performance.  John has chaired the DB2 for z/OS Service Advisory Team and Design Review Board.  He currently oversees all development and design for the core engine components of DB2.


We've Moved our Headquarters

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

 
New Contact: Jeffrey Miller or Sue Reed
The following information will remain the same:
Website: http://www.mwdug.org