Baltimore / Washington DB2 Users' Group - December 8, 2010 Meeting

Henry Nalven

Baltimore / Washington DB2 Users' Group - December 8, 2010 Meeting
BWDB2UG z/OS Quarterly Meeting December 8, 2010

To pre-register, please mail the appropriate fee with attendee's and employer's name to:

P.O. BOX 18554

All pre-registrations must be received by Friday, December 3, 2010. Make checks payable to the Baltimore/ Washington DB2 Users' Group or use the PAYPAL link on the website:

Visit our website,, for more information.

When? Wednesday, December 8, 2010, 9:00AM-3:30PM (registration at 8:30)

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900
Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40
At-the-door for non-members: $50

Meeting Schedule:
8:30 – 9:00 Registration

9:00 – 10:15 DB2 and Work Load Management (WLM)
Mark Rader, IBM

Confused about what exactly the IBM z/OS Workload Manager (WLM) is, how it manages work on your system, and how it relates to IBM DB2? In this session, we review the WLM features, including the types of goals you can set for each service class, importance levels and work classification. This information is the foundation for understanding how IBM DB2 for z/OS uses WLM, including advanced WLM functions such as enclaves and application environments. We also explain the relationship between the different types of DB2 work and WLM.

10:15 – 10:30 Coffee Break

10:30 – 11:45 Enhanced Monitoring support in DB2 v10
Mark Rader, IBM

DB2 10 for z/OS includes several exciting enhancements for monitoring the performance of SQL in your system and for managing your distributed connections and threads. This presentation explains how these capabilities allow you a better view of systems performance and more granularity in managing static and dynamic SQL and distributed threads.

11:45 – 12:45 Lunch

12:45 – 2:00 SMS is Now Mandatory for DB2 V10! SMS Best Practices for DB2
John Iczkovits, IBM

Confused about SMS? Do your Storage Administrators intimidate you when discussing how to best use SMS for DB2? Not sure if your company is conforming to best practises for SMS and DB2? Come and understand what SMS means and how to relate what your DB2 needs to the Storage Administrators.

2:00 – 2:15 Break

2:15 – 3:30 Static SQL and Access Path Review - Tips and Tricks
Paul Walters

Demonstrate an approach for reviewing static SQL and Access Paths for zOS. Identify the impact of System Software, Statistics Changes and Application changes upon an access path at bind time. Review specific sources of information such as the DB2 Catalog, Plan Tables, Real Time Statistics and performance data that identify problems prior to impacting a production environment.

Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He is one of the authors of Redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.

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 an operations background and more than 28 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, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, mini IDUG, and at local DB2 users groups.

Paul Walters has 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration with a focus is on performance and exploitation DB2 features.

* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!

If you need to change settings, is the home of IDUG's Listserv