Date: September 13, 2007

Hotel: The Hotel Baronette (Novi)

Seminar Program

Program Details

DB2 Universal Database® (UDB) for z/OS® continues to deliver rich function for scalable and highly available data for your enterprise-scale e-business applications. Combine the power and capacity of IBM zSeries® , the high performance and high availability of the z/OS operating system, and this enriched version of DB2® to expand and extend your applications in the increasingly competitive e-business environment. DB2 UDB for z/OS, V8 is the most comprehensive and feature-rich version to date. With a major emphasis on 64-bit addressing, one of the keys to reengineering is breaking through the limits of the current architecture.

DB2 UDB for z/OS, V8 also includes dozens of changes in SQL, improving family consistency while pushing DB2 SQL beyond current boundaries for enhanced application portability. The purpose of this presentation review is to review changes and enhancements to: SQL, utilities, optimizer behavior, RUNSTATS and Visual Explain.

The purpose of this presentation is to provide an “end-to-end” overview of distributed connections to DB2 z/OS. Given distributed transactions cross many different business organizations, gaining an understanding the “big picture” of a distributed transaction is difficult. The goal of this presentation is to provide a high level view of distributed transactions and to try and de-mystifying the behavior of DB2 z/OS distributed workloads.

DB2 9 (code named Viper) brought the initial functionality and capability of Deep Compression. Significant storage savings and in many cases, performance benefit, is possible. Viper II will bring additional enhancements to the compression story in DB2 including, autonomics. This session will provide an overview and roadmap of Deep Compression in DB2 as well as share best practices and insights into successfully deploying this functionality.

Objectives: The goals of this presentation are to provide an overview of the compression functionality and the new enhancements in Viper II, best practices and guidelines for deploying compression, discuss storage benefits and performance aspects associated with compression, and future compression features and strategic Data Management direction.

This session will go over the details of locking, including a number of new features and capabilities introduced in V8.2, V8.2.2, and DB2 9. We will describe the different methods available which affect or control the locking behavior within DB2, including registry variables, configuration parameters, table attributes, special registers, and statement options. Information will be presented to describe how locks can be monitored and the impact of locking to the database system.

The cost of disk storage represents a significant portion of the overall expense associated with large database systems. Once purchased, managing that storage can significantly add to the total cost of ownership. Effective management and utilization of disk space is instrumental in keeping your database Real Estate costs in check. This presentation will provide insights into DB2 Data Management with a detailed focus on table and index reorganization. The role of Reorg in DB2 features such as Table Partitioning, Row Compression, Schema Changes and Large RIDs will be included. Best practices, monitoring, tuning, autonomics and troubleshooting will also be highlighted.

The application DBA and developer learn the common Java performance pitfalls and how to avoid them. This presentation will take the attendee through the application architecture and discusses the Java application pattern choices. The presentation highlights the common pitfalls and how to avoid performance problems related to Java sessions, messages and application persistence issues. The presentation also highlights the best practices for database connections, SQL access and error checking within a high performance environment. Discussing these areas along with common Java JSP and servlet programming traps and debugging can help your application developers improve your application scalability and overall performance significantly. We will discuss some of these issues as it relates to the upcoming JLinq (code name) technology from IBM.

About the Speakers

Paul Wirth is a Senior Data Management Technical Sales Specialist with IBM Corporation located in Grand Rapids, Michigan. Paul has been involved in database administration and storage management for the past twenty years. Over the years Paul has worked in database administration with IMS, DB2 and Oracle. Paul has also worked extensively with enterprise storage subsystems for both Open Systems and zOS.

Bill has a BSc degree from the University of Waterloo as well as MSc and Ph.D. degrees from McMaster University (Theoretical Physics). Bill began his IBM career with the DB2 LUW Customer Advanced Support group. Since 2000, his DB2 development career has been based in data management. Some of the features he has contributed to include: object reorganization, locking and concurrency controls, larger RIDs, partitioned tables and compression.

Mike Winer has an Honors degree in Computer Science from the University of Western Ontario, and has worked on DB2 for LUW at the IBM Toronto Software Lab since 1992. Working in and owning various components, along with managing a development team, he has contributed towards numerous features and capabilities over the years, including table spaces, sequences and identity columns, table reorg, Append - MDC - partitioned tables, single database page size, large RIDs, compression, and many others. Mike has experience in performance and development, along with a deep understanding of locking, logging, concurrency, and recovery, which has propelled him into his current role as one of the lead architects within the database kernel group.

David Beulke is an internationally recognized DB2 consultant, author and lecturer. He is known for his extensive expertise in database performance, data warehouse designs and internet java applications. He is currently a member of the IBM DB2 Gold Consultant program, co-author of the IBM V8 and V7 z/OS DB2 Certification exams, co-author of the Business Intelligence Certification exam, past president of the International DB2 Users Group (IDUG), columnist for DB2 Magazine, and former instructor for The Data Warehouse Institute (TDWI). Dave has 22+ years of experience tuning mainframe and UNIX systems, restructuring database designs, improving applications and providing more efficient SQL to solve business problems. He specializes in performance reviews and tuning of large complex operational and data warehousing systems saving his clients millions of dollars in CPU charges, hardware upgrades and software licensing costs. He can be reached at DaveBeulke@cs.com for any help, questions or comments.