8:00 to 09:00 Registration and Continental Breakfast
9:00 to 09:15 Introduction and News
09:15 to 10:30 Keynote presentation – location: Ballroom
Extreme Database Tuning for Maximum Operations Efficiency - Sheryl Larsen
10:30 to 10:45 Break
10:45 to 12:00 CA – location: Ballroom
Jimmy Fulton and Benjamin Scheerer: Managing More With Less - Multi-Database Management
10:45 to 12:00 BMC – location: Oxford
Chad Reiber: SMARTDBA and Utility Automation (40 minutes) and Andy Laredo: MAINVIEW for DB2 and V8 Monitoring (30 minutes)
12:00 to 13:00 Lunch
13:00 to 14:15 IBM – location: Ballroom
Ernie Mancill: "DB2 Performance Expert and OMEGAMON for DB2 - The best of both worlds in a converged product" (60 minutes) and "DB2 Connect monitoring with DB2 Performance Expert" (15 minutes)
13:00 to 14:15 Compuware - location: Oxford
Thomas A. Halinski: Unveiling of DB2’s DDF: SQL Revealed via the Gestalt Perspective
14:15 to 14:30 Break
14:30
to 15:30
Panel Discussion - location: Ballroom
Keynote: Extreme Database Tuning for Maximum Operations Efficiency - Sheryl M. Larsen
Substantial costs savings can be realized by companies when database performance issues are resolved during design and testing and not after production deployment. This presentation will examine traditional and advanced methods for managing DB2 optimizer chosen access paths for DB2 UDB for z/OS and Linux, UNIX, Windows. Native tuning methods as well as industry best practices and technology, will be shown. Methods once effective for simple SQL must now be replaced with advanced methods and technology for today’s complex and extreme SQL.
Managing More with Less - Multi Database Management - Jimmy Fulton and Benjamin Scheerer
SMARTDBA and Utility Automation - Chad Reiber (BMC Software)
The presentation will describe the evolution of utility automation in the DB2 z/OS environment. Software companies have been addressing this function for many years and BMC has taken it to a new level, by introducing full utility automation. Utility Automation uses the new SMARTDBA common interface for BMC mainframe products, this interface will be used by all database products, IMS, DB2 as well as distributed DBMSes. The presentation will describe the methodology and implementation of both the SMARTDBA interface and the Full Utility Automation products. This presentation is taken from a presentation made at the 2005 IBM DB2 Technical Conference. (Chad has over 20 years experience working with database systems covering IMS, IDMS, and DB2. Currently, he has spent the last 8 years working for BMC as a Software Consultant, assisting BMC DB2 customers with all aspects of DB2 and BMC Software.)
MAINVIEW for DB2 and V8 Monitoring - Andy Laredo (BMC Software)
This presentation will touch somewhat on the new features of V8 that particularly concern monitoring products. It will also show monitoring of distributed requests, via stored procedures, dynamic statement cache issues and locking issues. This presentation is taken from a presentation made at the 2005 IBM DB2 Technical Conference. (Andy Laredo, BMC Software - Andy has over 25 years experience working with database systems covering product development, DBA and System programming with IMS and DB2. He currently works for BMC also as a Software Consultant in the New England area.)
DB2 Performance
Expert and OMEGAMON for DB2 -
The best of both worlds in a converged product - Ernie Mancill (IBM)
DB2 Connect monitoring with DB2 Performance Expert - Ernie Mancill (IBM)
(Ernie is a member of IBM’s Database Tools team for DB2. The IBM Database Tools team assists customers with evaluating and implementing IBM’s database tools for DB2. Prior to joining IBM, Ernie was manager of DB2 Database Administration for JM Family Enterprises located in Jacksonville Florida. Ernie has worked with DB2 for over 15 years as a DB2 Systems Programmer. Ernie has over 30 years of Data Processing experience in many different capacities and in a variety of different industries.)
Unveiling of DB2’s DDF: SQL Revealed via the Gestalt Perspective -Thomas A. Halinski (Compuware Corporation)
DB2’s Distributed Data Facility’s (DDF) veil has been lifted from the eyes of the e-business applications personnel. With the ability to view and measure the performance of DDF SQL, which runs outside of the normal DB2 address space, IT personnel finally have insight into their systems. This paper will discuss: the evolution of using DDF - from a Gestalt perspective; DDF’s components and how they interact with MVS - key elements in understanding this process. Using special tools to enter the former “black box” of DDF’s address space, its SQL is revealed and thus tunable. (Thomas Halinski is a Systems Engineer for Compuware Corporation. He supports the Sale Team for the Application Performance Management (APM) software product STROBE, conducting pre-sales demonstrations, Proof of Concepts (POC s) and training. During the past 25+ years, he has worked as a Business Application Consultant for various industries with duties ranging from Enterprise Application Design to roll-up-your-sleeves program development and coding. He has worked in the MVS performance tuning software industry for the past several years, with an emphasis in DB2.)