Welcome to the MWDUG Website!


Please take a moment to review our site.  Our next meeting will be held Thursday, June 6, 2013 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 2nd Quarter Meeting - June 6, 2013.

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




Agenda for Our Next Meeting

Agenda for 2nd Quarter Meeting - June 6, 2013

  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
Sheryl Larsen, Sheryl M. Larsen, Inc.

Welcome and IBM Announcements
Jim Strand, IBM

09:15am - 10:30am Eenie Meenie Miney Mo, With Which Table (Space) Type and Page Size Shall I Choose
John Iczkovits , Consulting IT Specialist, IBM.

Eenie Meenie Miney Mo, With Which Table (Space) Type and Page Size Shall I Choose for DB2 on z/OS? Come learn about best practices in choosing the correct types and settings for your data.

 

What’s New in DB2 10.5for Linux, UNIX and Windows
Kevin Street, IBM

Business Strategies are driving applications that are more diverse than ever. Growth and innovation strategies drive the need to explore big data, analytics, mobile, cloud and social. At the same time, funds are not limitless and data management investments must be fast, reliable, affordable, future proof and versatile—even multipurpose. That is why DB2 10.5 with BLU Acceleration is a game changer for businesses looking to accomplish more with less.
Two Morning Sessions will cover:

  1. Analytics at the speed of thought—DB2 with BLU Acceleration is dynamic in-memory technology.
  2. Always Available Transactions—New enhancements IBM DB2 pureScale database clustering technology.
  3. Unprecedented affordability/TCO—Unlike in-memory alternatives, DB2 with BLU Acceleration uses a dynamic in-memory approach. Placing only the most used data in-memory means money is not wasted on RAM for data rarely accessed.
10:30am - 10:45am Break Break

 

10:45am - 12:00pm

What Every DB2 for z/OS Professional Needs to Understand about IBM Disk and Tape Virtualization
John Iczkovits , Consulting IT Specialist, IBM.

Come and find the answers regarding the new technology, and how to best leverage it for your DB2 environment, John Iczkovits, Consulting IT Specialist, IBM.

What’s New in DB2 10.5for Linux, UNIX and Windows (Continued)
Kevin Street, IBM

Business Strategies are driving applications that are more diverse than ever. Growth and innovation strategies drive the need to explore big data, analytics, mobile, cloud and social. At the same time, funds are not limitless and data management investments must be fast, reliable, affordable, future proof and versatile—even multipurpose. That is why DB2 10.5 with BLU Acceleration is a game changer for businesses looking to accomplish more with less.
Two Morning Sessions will cover:

  1. Analytics at the speed of thought—DB2 with BLU Acceleration is dynamic in-memory technology.
  2. Always Available Transactions—New enhancements IBM DB2 pureScale database clustering technology.
  3. Unprecedented affordability/TCO—Unlike in-memory alternatives, DB2 with BLU Acceleration uses a dynamic in-memory approach. Placing only the most used data in-memory means money is not wasted on RAM for data rarely accessed.

12:00pm - 01:15pm

Lunch - free, onsite Lunch - free, onsite 

 

01:15pm - 02:15pm

Application Optimization in DB2 for z/OS V10
Jim Wankowski, Principal Consultant, Technical Sales, CA

Managing the many facets of DB2 performance is a monumental and time consuming task. Most DBAs today simply do not have the time or bandwith to effectively monitor, manage, and maintain their DB2 z/OS environments. Over the last few releases of DB2, IBM has been introducing automatic facilities such as Real-Time statistics to help make application performance, and maintenance management more “hands off”. DB2 V10 introduced several new features focused particularly on managing statistics and assisting in testing and optimizing application performance.

This presentation will discuss real-time statistics and the new maintenance features added in V10 such as autonomic statistics, and statistics profiles. It will also cover application optimization features such as statement level optimization, virtual indexes, bind options, and the new production modeling capability. Key topics covered include:

  • Real-Time Statistics
  • Performance Profiles
  • Maintenance for Performance
  • Reorganization
  • RUNSTATS
  • Autonomic Statistics
  • Application Performance
  • Statement Level Optimization
  • Virtual Indexes
  • Production Modeling

Experience PureData : Meeting Big Data Challenges with Simplicity, Speed and Lower Cost
James Cho, Puredata

When it comes to running transactional workloads, database performance is a key factor in overall application and system performance. At the heart of the PureData System for Transactions is IBM's industry-leading DB2 technology. The IBM® PureData System for Transactions-part of the IBM PureSystems® family -is a highly reliable and scalable database platform designed to help reduce complexity, accelerate time to value and lower ongoing data management costs. The system enables IT departments to easily deploy, optimize and manage transactional database workloads. This expert integrated system sets a new standard in workload-optimized systems, delivering value with: Speed Simplicity Scalability & smartness.

02:15pm - 02:30pm Break Break 

 

02:30pm - 03:45pm

What to Implement First and Next in DB2 10 for z/OS
Damon Anderson, & Steve Loesch, Anixter, Inc.

Abstract:
After migrating to DB2 V10, a wealth of new features becomes available for use. This presentation will detail which of those features Anixter chose to implement first in order to improve the performance, stability and usability of their DB2 Applications and systems. We will also discuss what features we plan on using next.

New Era of Data Warehousing & Analytics
James Cho, Puredata

Data warehousing has become one of the fastest-growing segments of the IT world. The business value of data warehouse applications has been clearly demonstrated in thousands of cases, in organizations of all sizes, in all industries. Success, however, brings new challenges. Once data warehouses are in place, end user demand expands rapidly. Businesses that start with small-scale, compact systems may find that, within a few years, they must deal with terabytes (TB) of data, increasingly sophisticated technologies, complex mixed workloads and hundreds or thousands of users. As this occurs, costs may escalate rapidly. What can be done to control this process?


Speaker Bios

Damon Anderson is the Manager of Data Services at Anixter Inc. He has extensive experience in DB2 and IMS, data replication, ebusiness, Disaster Recovery, REXX, ISPF Dialog Manager, and related third-party tools and technologies. He is a certified DB2 Database Administrator. He has written articles for the IDUG Solutions Journal and presented at IDUG and regional user groups: Application Design, Data Management, Managing Database Resources, and Managing Performance.

James Cho is a Senior Technical Staff Member and Chief Architect for PureData Transaction System and Operational Analytics Solutions. He has been a technical leader of integrated solutions including BCU to Balanced Warehouse, IBM Smart Analytic Systems and the recent PureData solutions. He has over 15 years experience in database solutions including experience as a Data Warehouse DBA, publications of Industry standard TPC performance benchmarks, and BI architecture and deployment. James graduated with a bachelor of science in computer science from the University of Texas in 1996.

John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has 31 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, trade magazine articles, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, IBM System z Technical Symposium, CMG, IDUG, and at local DB2 users groups.

Steve Loesch is a Sr. Technical Database Administrator at Anixter Inc. DB2 Database Administration and Programming since 1988. All versions of DB2. Motorola, 1998-1992 DB2 DBA, Platinum Technology, Inc, 1992-1999, DB2 Internal Application using DB2 C/S Applications and Peoplesoft, CA Technology 2000-2009 DB2 DBA Manager, Managed DB2 SAP 2005-2009. DB2 Consultant 2009-2010, Database Design and Performance Management, Migrated DB2 V8-V9. Anixter Inc, 2010-2012 DB2 DBA, Database Design and Performance Management, Migrated DB2 V9-V10.

Kevin Street is currently working in the IBM Toronto Software Development Lab, in the home of DB2 for the Linux, UNIX and Windows platforms. In his role as a DB2 Technical Evangelist, Kevin spends most of his time travelling and talking with customers about new and future DB2 releases. Kevin also spends time helping the IBM technical field people understand the DB2 technologies so that they can help their customers to use DB2 effectively. Kevin has been with IBM for nearly 30 years and before joining the Lab held a variety of positions in IBM sales and marketing in Canada and the US.

Jim Wankowski has more than 28 years of development and database administration experience with DB2 for both z/OS and LUW. Jim started his DB2 career by participating in the original DB2 beta program in 1984 with Northrop Aircraft in Los Angeles. Jim is currently a principal consultant with CA Technologies supporting their DB2 z/OS tools. Prior to joining CA, Jim spent 10 years as the DB2 product manager for Quest Software and nine years as a DB2 product specialist at Platinum Technology. Jim is a well-known international speaker who has written articles for DB2 Magazine, and Z/Journal, and has regularly presented at IDUG NA, IDUG EMEA, IDUG AP, IBM Technical conference (IOD), regional DB2 user groups, and vendor seminars worldwide.


MWDUG Headquarters
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
Website: http://www.mwdug.org