MDUG Seminar

Date: June 12, 2008

Hotel: Baronette Hotel (Novi)

Seminar Program

Presentation Abstracts

This presentation looks at the potential change in the use of virtual storage and real storage as a DB2 for z/OS subsystem is migrated from V7 to V8 to V9. It also provides performance monitoring and tuning tips on virtual storage usage. The zIIP redirect feature is also described.

This presentation provides a look at the performance impact of DB2 9 for z/OS from SQL performance viewpoint, primarily for Select, Open/Fetch, Insert, Update, and Delete.

After working with hundreds of DB2 customers, we consistently see the same design errors. Design patterns provide a template solution to commonly occurring problems. This presentation lays out DB2 patterns covering logical and physical design, application design, configuration, and refactoring to strengthen your implementation.

Many applications enter production with sub-optimal indexing strategies. Regardless of the reasons for this, performance can be substantially improved if indexes are redesigned to better match the needs of the application. This presentation will review index structure, and discuss a number of ways to redesign indexes without affecting application integrity.

More and more DB2 application workload originates off the mainframe utilizing technologies like DB2 Connect, Web Sphere 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.

Dynamic SQL is being used more and more in DB2 shops around the world. Multiple factors are driving this increase in usage. As with most DB2 options, dynamic SQL offers potential benefits as well as new management challenges. This technical session begins with a brief overview on SQL tuning followed by a more detailed discussion on managing and tuning dynamic SQL. Finally, we’ll discuss the dynamic statement cache, a DB2 feature that can help address dynamic SQL performance issues.

Speaker Biographies

Akira Shibamiya currently works in the DB2 for z/OS performance department at the IBM Silicon Valley Laboratory. He has been working on the performance evaluation of DB2 since its inception almost 30 years ago.

Rob Williams is a Certified Advanced DB2 Database Administrator and Application Developer. For the past 8 years, he has worked with MHC solving problems with government institutions and large and medium sized corporations from around the world. He particularly focuses on database performance problems, database design, SOA, migrations, and implementations. He graduated from the University of Waterloo in Computer Science and Business with a strong emphasis on mathematics.

Bill Arledge is an IT veteran with 33 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.