Keynote Presentation - DB2 Version 8 and Beyond
Fiona Gleeson – IBM - Director of Development, DB2 UDB for z/OS

Fiona will have a lot of new information about improvements in DB2 for z/OS coming in Vnext. Fiona will cover challenges, growth in the business, delivery plans, new developments in e-business, e-transaction processing and new application areas. Come to hear more about breaking the limits, performance enhancements, continuous availability, index Improvements, very large database, WebSphere & Java, SQL & DB2 family, SAP, PeopleSoft & Siebel.

Fiona will describe the technology improvements and tell how the technology can address customer needs. The key technology improvements include improving the high end e-business server, improving scalability and availability, making DB2 more productive and much easier to use, more secure and improving synergy with the DB2 family and zSeries.

Fiona Gleeson is the Director of Development, DB2 UDB for z/OS and OS/390.Fiona has management responsibility for the team that designs, develops and supports DB2. In this role, she provides leadership for software product strategy, development, and support. During her career, Fiona has held a variety of management and technical roles across IBM's Software Group; primarily in the Data Management Solutions division of Software Group. Prior assignments include development responsibility for DB2 UDB for Linux, Unix and Windows, and development of business intelligence software in the ExtractTranform Load(ETL) space.

Can’t Find What You Need? Try UDFs
Cathy Peck, Highmark Inc.

User Defined Functions were introduced into DB2 with Version 6. This presentation will provide an overview of possible scenarios where creating an UDF might be appropriate. A step-by-step process for creating, testing and deploying User Defined Functions will also be described.
Presentation Key Bullet Points:
- Definition of UDF's
- When / Why to create
- UDF Creation
- UDF Testing
- UDF Deployment

DB2 Goes Totally "Scalar“
Cathy Peck, Highmark Inc.

In the beginning, there were only a handful of scalars available to the DB2 audience. Now with the latest releases of DB2, there has been an explosion of built-in scalar functions added to the DB2 toolset. In addition, IBM has foreseen the need of customers to be able to build their own scalars via DB2 User Defined Functions. This presentation will concentrate on providing work related scenarios pertaining to the use of key new scalars. In addition, DB2 UDF scalars will also be detailed.

Presentation Key Bullet Points:
- Scalars - What is a scalar? - What are the newer DB2 Scalars?
- Date Scalars - Review key new Date Scalars - Provide test case scenarios for each
- Character Scalars - Review key new Character Scalars - Provide test case scenarios for each
- Numeric Scalars - Review key new Numeric Scalars - Provide test case scenarios for each
- User Defined Functions - What are they? What are the various Types? How to create them? How to use them?

Cathy Peck has worked with DB2 since V1.3 and is an Senior Systems Consultant employed at Highmark Blue Cross and Blue Shield headquartered in Pennsylvania. Cathy has been involved with IDUG since 1991 as an attendee, presenter & volunteer organizer. Cathy also leads the Central PA & Pittsburgh Regional DB2 User Groups.

Table and Index Design for High Performance (2 parts)
Susan Lawson, YL&A, Inc.

This presentation will discuss many issues surrounding alternative table designs and performance. We will look at many different alternatives to help design tables for the best performance possible for the type of application process. There are many issues to consider for high volume insert and update transactions, and a balancing act to be achieved for responsiveness to readers. Table issues such as denormalization, non-column attributes, indicator columns, repeating columns, derived data, aggregated columns, table flipping, identity columns, surrogate keys, horizontal and vertical partitioning. We will also look at issues with designing VLTBs (Very Large Tables) and XVLTBs (eXtremely Large Tables).

It will then cover index design issues and query performance for topics such as best use of index matching predicates, and index screening. Index access path issues will also be discussed (Matching Index Scan, Non-Matching Index Scan, IN-List Index Access, Multiple Index Access, One Fetch Index Access, Index-Only Access and Equal Unique Index Access). We will then turn our attention to join performance and index influence to avoid such problems as Death by Random I/O, Death by Sequential I/O and Death by Index Screening and problems with joining on mismatched datatypes. We will take a look as sorts, how to avoid them and when they are appropriate.

This presentation is suitable and of interest to both DBAs and Application developers.

Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration, and is a principal with YL&A. In the past, she has been an IBM Data Sharing advocate where she supported a variety of large DB2 customers. She provided technical expertise for migration to DB2 Data Sharing in a Parallel Sysplex environment, as well as troubleshooting performance problems during post-implementation. She currently works with several clients to help develop, implement and tune some of the world's largest and most complex DB2 databases. Her other activities have included authoring articles, presenting at user group meetings (where she has won best speaker awards), and providing technical editing for trade journals. She is an IBM GOLD Consultant for DB2 and S/390, and is an IBM Certified DBA and Application Developer for DB2 UDB Version 7 for OS/390. She is one of the authors of "DB2 Answers!" published by Osborne/McGraw-Hill, "DB2 High Performance Design and Tuning" published by Prentice-Hall, "DB2 UDB for OS/390 Version 7 DBA Certification Guide" published by Prentice-Hall, “DB2 UDB for OS/390 Version 7 Application Development Certification Guide” and “DB2 UDB V7 Family Reference Guide” published by YL&A.

Tuning DB2 (From the Ground-Up and From the Top Down)
Chuck Hoover, Chuck Hoover, Incorporated

"From the Ground-Up" means that this presentation begins from the perspective of the DB2 subsystem administrator who is responsible for the selection and generation of the basic DB2 subsystem. This deals with decisions for establishing the basic ZPARMS, EDM pool, buffer pool, logging and locking options. Given these decisions, the next section deals with basic measurements to collect for a historical tracking of DB2 performance and throughput. In examining these measurements, the system administrator can use key indicators to spot problems with their basic selections. In addition, there are a series of indicators and characteristics that indicate when the performance problem is not isolated to the DB2 subsystem. The presentation attempts to answer the question of when does one approach MVS/ESA systems programmers, the disk subsystem configurators, the network team, the database administrator, or application owners to resolve performance issues.

“From the Top Down” assumes that the DB2 System Administrator has provided an adequate DB2 subsystem with respect to performance parameters. Thus, the starting point is DB2 Per-formance Monitor Systems Statistics and Application Accounting Reports. These are used to identify peak periods and plans executed during those periods that use excessive system re-sources. A standardized approach for analyzing the make-up of the Class One time for these plans is used to drill-down into the use of various SQL options and database design alternatives.
The presentation also attempts to answer the question of when do you approach MVS/ESA systems programmers, the disk subsystem configurators, the network team, the database administrator or application owners to resolve performance issues.
Chuck Hoover is an independent consultant specializing in data base design, capacity planning, performance forecasting, SQL optimization and system tuning.
Chuck has over 42 years experience in information processing with the IBM Corporation and the Compuware Corporation. He is a member of the IBM Golden Consultants for DB2 for z/OS.

DB2 Recovery …. A to Z
Rick Weaver, BMC Software


Rick Weaver has over 25 years of experience in Systems and Database Administration for IMS, DB2 and Distributed System database systems, and has been involved in developing large, complex, mission critical applications in a variety of business areas. A special area of expertise is support of backup and recovery for enterprise wide applications, exploiting the advances in hardware and software technology to produce cost effective recovery solutions. Rick is currently Product Manager for Enterprise Recovery at BMC Software.

So you want to be a DBA?
Rob Crane, CA

Presentation covering the topics and knowledge a DBA needs to be successful. Technical overview of DB2’s infrastructure from the ground up. Give programmers, sysprogs and new DBAs a chance to learn and review DB2’s layout and critical factors in making a DBA’s life easier.

Presentation Key Bullet Points:
- Understanding DB2’s Infrastructure
- Imbedding Business Logic in the Database
- Data Access and Why a DBA Should Care
- Access Outside of DB2's Control
- Why and What DBA’s Should Review during Design Reviews

A Nuts and Bolts Approach to Plans and Packages
Rob Crane, CA

Gain in-depth understanding of DB2?s use of plans, packages and collections. Participants will gain a better understanding of how to implement and manage their packages and plans. A technical review of DB2?s use and implementation of packages. Suggestions on package standards, problem solving and tuning these objects given. This presentation was selected as one of the top 10 at the Dallas, 2000 IDUG North American Conference, and has been updated for V8.

- Presentation Key Bullet Points:
- Program Preparation & Bind Processes
- System and Catalog Table Overview & V8 Updates
- Recommendations for Implementing and Maintaining
- Problem Resolution & Advanced Package Topics
- SQL to View & Manage Plans, Packages, Collections

Rob Crane has a degree from the UNI in MIS. Accepted a position with State Farm as a programmer/analyst in 1990. Programmed against DB2 using PL/1, COBOL, REXX, and Smalltalk. Converted their billing and Client Information systems from IMS DB to DB2. Became primary DB2 contact for the Client system including application DBA and modeling work. Responsible for all DB2 application recovery and restart logic development.
Rob joined the Principal Financial Group in 1995 as a DBA and team leader. Responsible for application and subsystem tuning, backup and recovery, ddl creation, security, and DB2 training curriculum development. Joined Platinum Technology in July, 1998. On site support at MCIWorldcom supporting CA's DB2 products and assisting CIWorldcom & EDS with various DB2 efforts (V7 exploitation, training, etc.). Fortunate to speak at IDUG 2000, 2001, and 2002. IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390 and DB2 UDB V6/V7 User.

DB2 Performance Analysis In A WebSphere World
Ed Woods, Candle Corporation

Many shops are rapidly implementing sophisticated new WebSphere based applications. DB2 databases are a central component of these WebSphere implementations, and are an integral component of the Websphere infrastructure itself. This presentation will examine the infrastructure and the performance considerations of DB2 in a WebSphere environment.
The presentation will examine the core components of WebSphere, and where DB2 fits within the infrastructure. Examples will be discussed for both z/OS and open systems platforms. The presentation will look at the time line of a typical WebSphere application, and examine where time is typically spent.
WebSphere DB2 applications may exhibit different performance dynamics than traditional ‘legacy’ DB2 applications. WebSphere applications pose additional challenges and considerations from a performance and tuning standpoint. This presentation will look at the relevant performance and tuning information available. This will include the relevant DB2 traces (both on z/OS and open systems), and relevant traces available within WebSphere itself. Recommendations will be made on how to gather, summarize, and analyze the performance data available. This presentation is for anyone interested in acquiring a more in-depth knowledge of the function of DB2 in a Websphere and e-business environment, and how to manage and tune in a WebSphere environment.

- Presentation Key Bullet Points:
- The core components of WebSphere
- The WebSphere application performance timeline
- The performance dynamics of WebSphere applications and DB2
- Performance Analysis And Information
- Recommendations and Summary

DB2 And Workload Manager: Setting Optimal Goals
Ed Woods, Candle Corporation

Workload Manager is an important component of the z/OS operating system. Workload Manager handles system resource allocation and prioritization for z/OS subsystems and applications. Workload Manager has a major effect on DB2 operation and performance. Workload Manager has impact on the DB2 subsystem, DB2 applications, DB2 distributed applications, and DB2 stored procedures.
This presentation will first review the concepts and components of Workload Manager, and how DB2 exploits Workload Manager. The presentation will then look at important aspects of Workload Manager relevant to DB2, such as goals and the setting of goals. The types of goals available will be reviewed, along with why this is important to DB2. The presentation will cover issues relevant to DB2 distributed applications, and DB2 Stored Procedures. Recommendations will be made on DB2 Stored Procedure configuration and tuning. This presentation is relevant to all those who want a better understanding of DB2 and Workload Manager.

Presentation Key Bullet Points:
- Workload Manager Overview
- How DB2 UDB OS/390 Exploits Workload Manager
- WLM Managed Stored Procedures And Application Environments
- DB2 Distributed Priority Management
- Recommendations and Summary

Ed has over 20 years of experience in the data processing industry, primarily in the area of DB2, IMS, and MVS systems programming. He has been a Systems Engineer with Candle Corporation for more than 10 years, supporting the Candle DB2, IMS, and e-Business product lines. Ed has presented at IDUG North America, IDUG Europe, Guide, Share, CMG, and at regional DB2 User groups on DB2 technical and performance topics. In addition, he has presented as a part of Candle Performance Road Shows, and has published articles in Candle Computer Report and IDUG Solutions Journal. At IDUG North America 2000, he was named Best Overall Speaker.

SQL Unleashed on DB2 for Multiplatform (2 parts)
Serge Rielau, IBM – Toronto DB2 UDB Lab

Serge Rielau is a technical manager in the DB2 SQL compiler. In his 6 years with IBM and DB2 he has developed various SQL extensions in DB2 as well as driven SQL extensions the SQL standard.

Multidimensional Clustering
Leslie Cranston, IBM – Toronto DB2 UDB Lab

This presentation will present in detail this very new and exciting feature, which is unique to DB2 for Unix and Windows platforms(so far), and to the industry in general. It is a high availability and high performance enhancement for large to very large databases, especially useful in data warehouse environments.

For the past 5 years, Lesley has been working as a Senior developer on the Index Management team, as has designed and implemented clustering and bidirectional indexes, along with other performance features. Most recently, she has been working on designing and developing the latest data clustering technology for DB2 UDB, multidimensional clustering Lesley has implemented a significant portion of this feature, and led the development team for this project.