Melanie Stopfer

Speaker Details

Bio

Melanie Stopfer is a IBM Consulting Learning Specialist and Developer and recognized worldwide as a DB2, IBM BLU and Analytics subject matter expert. She has provided in-depth technical customer support in recovery, performance and database upgrade best practices since 1988. In 2009, Melanie was the first DB2 LUW speaker to be inducted into the IDUG Speaker Hall of Fame, selected Best Overall Speaker a record breaking seven times (IDUG EMEA 2009, 2011, 2012, 2015; IDUG NA 2009, 2012, 2016), and included in Top 10 Overall Speakers in all years presenting. She has successfully presented at all IBM IOD, Insight and World of Watson conferences and been recognized as a top presenter. Please connect with Melanie on Twitter at @mstopfer1 and LinkedIn.

In the past few years, there have been times that DB2 has tested customers before they could learn the lesson. Come to this presentation and let me teach you the lessons learned so you are ready for your next DB2 LUW “pop” quiz. By learning from others mistakes, you can learn how to make things right.

Objective 1: Utilizing product enhancements and features that make your life easier.

Objective 2: Tips and Techniques to get the most from DB2 Utilities.

Objective 3: Getting more out of your error messages by decoding the secrets.

Materialized Query Tables (MQTs) are widely used to significantly speed up the response time of decision support queries. A MQT is a table whose definition is based on the result of a query and whose data is in the form of precomputed results. Learn how to deploy MQTs. Through examples, learn steps necessary to create, maintain and use MQTs. MQT maintenance and trade-offs associated with various approaches will be analyzed. Learn about MQT matching, which is the process DB2 uses to transparently answer queries against base tables using precomputed query results stored in MQTs. Advanced uses and the benefits of MQTs with advanced query optimization techniques will be discussed.

Dig into the nuts and bolts of Memory Management. Melanie will describe the details of management of instance-level memory, database-level shared memory and application memory for DB2 databases. Automated Memory Management using Self Tuning Memory Manager will also be addressed. The configuration and use of each memory heap will be described. The monitoring of memory usage using SQL statements, db2mtrk and db2pd command reports will be presented.

Are you responsible for upgrading your database to DB2 LUW 11? Take advantage of the new DB2 great functionality. Unlock the secrets. If you need a detailed step-by-step approach to implement the newest version of DB2 LUW 11, come learn about often overlooked but very important best practices to understand before and after upgrading. Satisfy your ever increasing demands to analyze business data quickly and get insights into your data.

This one-day class is designed to describe the major technical features and enhancements provided by DB2 for Linux, UNIX and Windows database 10.5 software. A key feature of DB2 LUW 10.5 is new support for column-organized tables to provide accelerated analytic processing called BLU Acceleration. Additional new features in DB2 LUW 10.5 will also be covered.
After completing this class, you should be able to:
• Implement column-organized table support for a new or existing DB2 database
• Describe how the column dictionaries used to provide extreme compression of column-organized tables are built and utilized
• Explain the impact of setting the DB2 registry variable DB2_WORKLOAD to ANALYTICS
• List the seven ‘big ideas’ that work together to provide DB2 BLU acceleration
• Describe the different storage used for column-organized table compared to row-organized tables
• Explain how DB2 uses a synopsis table to support data skipping with column-organized tables
• Monitor a DB2 database or application that uses column-organized tables
• Use db2convert or ADMIN_MOVE_TABLE to convert row-organized tables to column-organized tables
• Explain the support for large row sizes with DB2 10.5
• Use DB2 Version 10.5 create an index that contains an expression-based key
• Monitor DB2 10.5 databases and instances using SQL table functions MON_GET_DATABASE and MON_GET_INSTANCE
• Recovery enhancements will also be discussed.

With the comprehensive features for temporal data management in DB2, database administrators and application developers face numerous choices in database and application design. They also encounter new situations for the maintenance of database objects and historic data.

Do you want to better understand and tune your DB2 LUW database? Are you looking for tips to make your life easier? By analyzing EXPLAIN output, Melanie will present analogies and insider advice to help you improve performance and availability. Come learn new DB2 LUW ideas, tips and enhancements that you need to know.

• Gain knowledge on index utilization and improving access

• Analyze the details of predicate processing and the value of column correlations

Are you responsible for upgrading your database to DB2 LUW 10.5? Take advantage of columnar data store integrated into the core DB2 engine which has huge benefits for Business Intelligence workloads. DB2 LUW 10.5 is not just BLU. There is additional new great functionality. Learn the entire story! If you are looking for a detailed step by step approach to implement DB2 LUW 10.5, attend this presentation to learn about often overlooked but very important tips and tricks to understand before upgrading. Planning your upgrade is much easier if you know these best practices.

SHORT ABSTRACT:

Are you responsible for upgrading your database to DB2 LUW 10.5? Attend this presentation to learn about often overlooked but very important tips and tricks to understand before upgrading. Leave with a cookbook to completing a successful upgrade!

Are you responsible for upgrading your database to DB2 LUW 10.5? Take advantage of columnar data store integrated into the core DB2 engine which has huge benefits for Business Intelligence workloads. DB2 LUW 10.5 is not just BLU. There is additional new great functionality. Learn the entire story! If you are looking for a detailed step by step approach to implement DB2 LUW 10.5, attend this presentation to learn about often overlooked but very important tips and tricks to understand before upgrading. Planning your upgrade is much easier if you know these best practices.

SHORT ABSTRACT:

Are you responsible for upgrading your database to DB2 LUW 10.5? Attend this presentation to learn about often overlooked but very important tips and tricks to understand before upgrading. Leave with a cookbook to completing a successful upgrade!