MDUG Seminar

Date: June 11, 2009

Hotel: The Hotel Baronette (Novi)

Seminar Program

Presentation Abstracts

Workload Manager (WLM) is an essential component of z/OS and manages resource allocation and prioritization for all the applications that run on z/OS, including DB2. Workload Manager has a major effect on DB2 operation and performance. A solid understanding of WLM concepts, and how DB2 depends upon and exploits WLM is essential to DB2 tuning and management. This presentation is designed to be a detailed discussion of how DB2 resources and workloads are defined and managed by WLM. Recommendations for DB2 and WLM best practices will be covered. This presentation is for all users who want a better understanding of the interaction of DB2 and WLM.

Distributed processing is an important workload component of DB2 on z/OS. Understanding network performance and the impact it has on DB2 performance is an important part of formulating an integrated performance and availability management strategy. This session will discuss various aspect of DB2 distributed workload processing, and examine the impact of network performance. Suggestions on how to analyze, assess, and determine the impact of the network on overall DB2 performance will be covered. Technical examples of performance analysis using various IBM OMEGAMON monitoring solutions will be shown. This session is for all who want to gain a better understanding of the impact of the network on DB2 performance.

DB2 9.7 is the next major release of DB2 for UNIX, Linux, and Windows. Learn how the new technologies in DB2 9.7 provide more automated administration, more-efficient storage, and faster performance.

See also how DB2 9.7’s PL/SQL support removes productivity barriers to database migration by enabling interoperability with PL/SQL applications. This session will give you a technology overview of DB2 9.7.

More and more DB2 application workload originates off the mainframe utilizing technologies like DB2 Connect, Websphere Application Server, and others. This shift to increased distributed processing presents new challenges in understanding and managing DB2 application implementation. This session discusses basic issues about distributed applications, including distributed fundamentals, implementation considerations, problem identification, and performance management for your DB2 on z/OS distributed applications.

Metadata information stored in the DB2 Catalog is very well known and easy to interrogate using SQL. However, at run time, DB2 makes extensive use of the other primary DB2 system database, the Directory or DSNDB01. This presentation describes the contents of the Directory, explains how to look at its contents, and discusses how you can improve your overall system performance and recovery times by paying a little more attention to this often forgotten resource.

This session provides a detailed overview of DB2 9 on z/OS and discusses value and implementation considerations for these new features. We’ll look first at infrastructure enhancements and then review application considerations, including new data types and SQL options.

Speaker Biographies

Ed Woods has over 25 years of experience in the data processing industry, primarily in the area of DB2, IMS, and MVS systems programming. He is a Consulting IT Specialist with IBM Corporation, working in the area of performance and availability management. He has been a frequent presenter at IDUG North America, Guide, Share, CMG, the IBM DB2 Technical Conference, the Tivoli Technical Conference, the IMS Technical Conference, and at numerous regional DB2 User groups on technical and performance topics. He has published articles in Candle Computer Report, IDUG Solutions Journal, and CCR2 (CCR2 is available at IBM.COM).

Bob Harbus has been with IBM since 1989 and with the IBM Toronto Lab since 1992. He has worked in a number of areas including DB2 Linux. UNIX, Windows development, DB2 Service, DB2 Certification (where he authored a number of books on DB2) and DB2 Lab Services (specializing in data warehousing), Bob is currently a DB2 Evangelist and member of the Worldwide DB2 Evangelist team out of the IBM Toronto Lab. In addition to his work with DB2 (in the competitive and technical space), Bob has also been focusing on Data Warehousing/Business Intelligence and XML from a competitive perspective.

Bill Arledge is an IT veteran with 34 years experience across a variety of roles, including application development and database administration. Bill’s database experience began in the late 1970’s as an IMS DBA and developer. He began working with DB2 in 1984 as a database specialist at IBM. He worked with DB2 throughout the late eighties, consulting with numerous IBM customers on existing and planned DB2 implementations. Bill joined BMC in 1990 and is currently a technical product manager responsible for BMC’s DB2 data management products. In that capacity he consults extensively with BMC DB2 customers and works closely with BMC’s Research and Development organization to drive product direction.