Location: Bank of Montreal Institute for Learning
Leveraging Information Management on Demand: Today and Tomorrow
Platform: DB2 Cross Platform - Audience: All
Information Management is the foundation of every successful enterprise. To remain competitive, you know that for each of your organizations and enterprises, it is essential to leverage ALL the information in your enterprise and beyond. The past 40 years of IT investments have left most of your companies with an enterprise computing infrastructure that is heterogeneous, widely distributed and increasingly complex.
This presentation will review the technology changes in computing that will affect the work you do, and explore the initiatives in IBM's information management technology that correspond to those changes, especially in the areas of performance, scalability and availability.
We will also discuss innovations in IBM's DB2 family of products that will make it faster and easier to do application development and will provide simpler to use but more powerful mechanisms to manage the tremendous growth in digitized information.
Changes that you will see include using autonomic technology to manage this data, extending traditional data management techniques to support new forms of content from many different sources, and exploiting XML, J2EE, business process integration, and web services to support new models for building and executing applications.
This presentation will cover a quick review of what is available in these areas today, and a view of IBM's On Demand software strategy, technology, and product directions for the future.
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 ExtractTranformLoad(ETL) space.
Leon Katsnelson is a Senior Development Manager at the IBM Toronto Lab. Leon is a recognized expert in the areas of DB2 Application Development and DB2 Connect. Leon has 18 years of experience with complex database and network systems. Over the years he has helped many customers to integrate DB2 into their solutions. Leon frequently presents his experiences at user group meetings and industry conferences.
DB2 Memory: Impacts on Application Performance
Platform: DB2 for zOS - Audience: All
SQL tuning is very important to application performance. But you can have a perfectly
tuned SQL statement and still not have good application performance. SQL tuning is one way to good performance. You must also consider the database design and how memory is being used. This presentation discusses the issues regarding memory and the objects that use it.
Application Design for High Performance
Platform: DB2 for zOS - Audience: All
We will cover many alternatives to our normal applications in order to achieve performance. Many techniques to minimize overhead and locking will be explored. We will also take a look at techniques coding efficient SQL and minimizing the amount of data we bring back to process in our applications via optimal predicates, less repetition and better use of indexes. We will also discuss converting legacy programs efficiently.
Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration. 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 development, implement and tune some of the world’s largest and most complex DB2 databases. Her other activities have included authoring articles and presenting at user group meetings.
The Ties That BIND DB2
Platform: DB2 for zOS - Audience: All
No matter how long programmers have worked with DB2 for z/OS and OS/390, they still ask me to tell them the difference between a plan and a package — and what in the heck a collection is. I wrote several columns on this topic so I could just point them to DB2 Magazine. Well one column became two, and two morphed into three. And, now this topic has become a new presentation.
An all new: “Things I Wish They’d Told Me, Best of Parts 1 - 10”
Platform: DB2 for zOS - Audience: All
Bonnie continues the tradition of delivering content-rich sessions with this new offering. War stories, analogies, and examples are used to explain how good (and bad) techniques for application design, object design, program logic and SQL impact application performance. The session topics include: Little-known V8 issues for developers; Coding alternative SQL syntax for performance improvement; Deciphering DB2-SPEAK.
Bonnie Baker, a consultant with Bonnie Baker Corporation, uses her experiences as a programmer, systems analyst, DBA, instructor and consultant to bring a hands-on, from the trenches perspective to this seminar to provide real-life solutions to real-world problems with DB2. She is a frequent speaker at the U.S., European, and Canadian DB2 Technical Conferences and has spoken at SHARE, IDUG, and many DB2 User Groups. She has won the IDUG Best Speaker Award 5 times and is a member of the IDUG Speakers’ Hall of Fame. She writes the “Programmers Only” column in DB2 Magazine. She is also an IBM DB2 Gold Consultant.
SQL Performance Under the Microscope
Platform: DB2 for zOS - Audience: All
Fact #1: SQL can make DB2 fly or crawl.
Fact #2: Large performance gains are achieved by tuning SQL.
In this presentation, we look at how you can make SQL fly. We take an in-depth look at predicate processing, how joins can be made more efficient and also how stage 1 can improve and stage 2 predicates can impact performance. Lastly we discuss DB2 EXPLAIN and how to find SQL problems that cannot be spotted in the PLAN_TABLE
Maria Sarikos has been working with DB2 for over 12 years. Maria worked as an Independent Consultant for a number of years specializing in DB2 Performance Tuning and Database Design before joining PLATINUM technology and subsequently Computer Associates.
Capturing and using dynamic SQL statements
Platform: DB2 for zOS - Audience: All
The absence of a dynamic SQL repository represents a problem for database administrators, performance analysts and system programmers. This presentation will discuss experiences with the various tracing options available to capture dynamic SQL and the challenges involved in making this information usable. As well, relevant new DB2 for z/OS V8 features such as EXPLAIN STMTCACHE will be discussed.
Jim Mourgelas has worked in database technical support at TD Bank for the past 15 years, working with IMS and DB2 for z/OS. For the last 8 years, the focus has been exclusively in the DB2 area. Have participated in migration of several releases of DB2 including the early support program with IBM. Among other responsibilities at TD, involved in identifying gaps in DB2 infrastructure and recommending possible solutions.
DB2 Performance 101
Platform: DB2 for zOS - Audience: All
"DB2 Performance 101” will explore the basics of DB2 Performance and DB2 Performance Monitoring & Tuning. Learn about DB2’s address spaces and how they process your SQL. How important is the DB2 Instrumentation Facility? Learn about the DB2 Optimizer and its access paths. What about monitoring and tuning DB2’s key performance metrics! Do you know where to look and what it means? … AND much more!
Joe Borges is currently a Senior Technical Specialist at BMO Financial Group (one of Canada's top financial companies). BMO employs over 35,000 employees, supporting over 2,500 branches worldwide. Joe has been employed at BMO Financial Group for the past 23 years and has spent the past 20 years working with DB2 in various capacities. He is currently BMO's DB2 Strategist/Planner and Performance Specialist. Most recently, he has architected BMO's DB2 Data Sharing processing strategy. Joe was on the "DB2 System Performance - Panel" at IDUG-NA 93 and has spoken at various conferences and user groups - most recently at IDUG-EU 2002, IDUG-NA 2003, BMO Database Users Group and Central Canada DB2 Users Group.
Performance for DBAs: Make DB2 Utilities Go Faster
Platform: DB2 for Linux, Unix, Windows - Audience: All
Online hours are getting longer and databases are getting larger, but maintenance windows are getting smaller. Using experimental data, we cover ways to improve the performance of DB2 online and offline utilities, such as load, backup/restore, create index and runstats. We look at assessing utility performance, and at the impact of command options and database configuration. Updates on upcoming DB2 releases are included.
Advanced Performance Diagnostics in DB2
Platform: DB2 for Linux, Unix, Windows - Audience: All
DB2 has the tools to help you heal almost any performance ailment, but are you using these tools to best advantage? With customer and laboratory examples, this presentation unlocks the secrets of DB2's performance diagnostic tools, including collecting, filtering, analyzing and even mining the data they provide you. The result is a set of best practices that let you quickly get to the bottom of any performance problem.
Steve Rees joined the IBM Toronto Laboratory in 1991. He was involved with the establishment of the workstation database mission in Toronto, and in several releases of DB2 product development, first in the area of precompilers, and then in the DB2 Unix porting team. He is currently a senior technical manager in the DB2 performance organization, with responsibility for the performance of Java data access, Linux OLTP and SAP.
Steve was rated as IDUG-NA 2004 best overall speaker.
The A-Z of Exploiting SQL PL in DB2 UDB for LUW Version 8.2
Platform: DB2 for Linux, Unix, Windows - Audience: All
If you are a DBA or a programmer short on time to implement applications, needing an SQL scripting language, or who wants to boost the performance of applications, then SQL PL and SQL procedures may be the answer.
This presentation covers the A to Z of SQL PL and SQL procedures including SQL PL language elements, execution model, designing, developing, debugging, deploying, and improving the performance of SQL PL procedures using best practice examples. Content will highlight new features in DB2 Version 8.2.
This presentation was rated as one of the top 10 presentations at IDUG-Europe 2004 in Prague.
Gwyneth Evans is a software developer in the DB2 Solution team at the IBM Toronto Lab where she is dedicated to ensuring that customers are exploiting new DB2 features and getting the most out of them. She has previously worked in the DB2 SQL Compiler Team and as a database application developer. She is an IBM Certified Application Developer and Database Administration Expert, has taught 2 DB2 Educational Seminars,
presented at past IDUG and DB2 Information Management conferences, and regularly contributed articles and tutorials to DB2 developerWorks.
DB2 Internals: The Deep Dive (In 2 Parts)
Platform: DB2 for Linux, Unix, Windows - Audience: All
This session will dive into the internals of DB2 UDB in depth, including details of the latest versions of DB2 on the UNIX, Windows and Linux platforms (V8.2 and beyond). Details such as record formats, page formats, index algorithms, memory management and tuning, storage management, buffer pool algorithm, logging, and the process and threading design will be covered in depth. As each concept explained, key hints, tips and best practice information will be provided. This will enable Dabs and System Administrators to fully exploit the functions and features of DB2 UDB.
This presentation was rated as one of the top 10 presentations at IDUG-Europe 2004 in Prague.
Matt Huras is a lead architect and development manager of the data management group in UDB development at the IBM Toronto Laboratory. His focus is on the DB2 UDB storage engine, including indexing, data management, buffering, OS services, utilities and high availability. Matt joined IBM in 1984 and has been a lead designer with the UDB development team since 1991. He holds a Bask in Computer Engineering from the University of Waterloo ('84) and an Men, also in Computer Engineering, from the University of Toronto ('92). Matt is an IBM Distinguished Engineer.
Experiences with the Design Advisor
Platform: DB2 for Linux, Unix, Windows - Audience: All
The Index Advisor was introduced in DB2 V6 as a component of DB2. Now renamed to the Design Advisor in DB2 v8.2, it has been enhanced to provide support for MDCs, MQTs and partitioning. This presentation shows how the Design Advisor should be a valuable part of every DBA’s toolkit.
The presenter will share his experience from several customer locations including OLTP and data warehousing applications.
Martin Hubel is an independent consultant and has worked extensively with DB2 since 1985. Martin develops and teaches advanced DB2 courses and is recognized as a leading authority in the field. He has been using DB2 Universal Database on Linux, UNIX, and Windows since 1993 and has participated in several beta test programs for these platforms. He is a member of the IBM Gold Consultants Program, and is the Editor of the IDUG Solutions Journal.
Martin has an extensive background in computer systems, including software design and development, project management, disaster recovery planning, data security, systems programming, capacity planning and performance, operations support, charge back systems, end user support, and data and data base administration.
7 Years of UDB Performance Solutions: Life lessons
Platform: DB2 for Linux, Unix, Windows - Audience: All
Seven years of crisis and fine tuning DB2 UDB and its applications (SAP, Siebel, PeopleSoft, to name a few) have yielded many valuable life lessons and performance tuning solutions. This session is loaded with practical, technical, and usable lessons for achieving dramatic and measurable performance improvements on any DB2 UDB database. Attendees will hear anecdotes from actual customer situations, and much more.
Scott Hayes is a well known DB2 UDB performance expert. He is a regular speaker at International DB2 User Group conferences, IBM DB2/Data Management conferences, and is frequently sought as a guest speaker for regional DB2 user group meetings. Scott has authored several published articles on DB2 UDB performance (see http://www.breakthroughdb2.com/resources.shtml ), is an IBM DB2 Gold Consultant, has obtained Advanced IBM DB2 Certifications and is widely regarded by the worldwide DB2 community as the top performance expert for DB2 on distributed platforms (UNIX, Linux and Windows).