58

The BLU feature of DB2 10.5 is lighting fast. How does it work? Why is it unique? We have a look at its engine and what is (im)possible with BLU

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

• Improve query performance

• Learn how the optimizer calculates filter factors

• Improve sort performance

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!

Objectives:

• Describe changes to DB2 LUW 10.5 packaging and software and operating system requirements.

• Understand DB2 LUW 10.5 changes to DDL, utilities, tools and monitoring.

• Configure a database and instance to implement DB2 LUW 10.5 new features.

• Analyze DB2 LUW 10.5 changes that affect applications and database runtime behavior.

• Develop a DB2 LUW 10.5 upgrade strategy.

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!

Objectives:

• Describe changes to DB2 LUW 10.5 packaging and software and operating system requirements.

• Understand DB2 LUW 10.5 changes to DDL, utilities, tools and monitoring.

• Configure a database and instance to implement DB2 LUW 10.5 new features.

• Analyze DB2 LUW 10.5 changes that affect applications and database runtime behavior.

• Develop a DB2 LUW 10.5 upgrade strategy.

One of the most difficult and time consuming processes in developing a data warehouse is the table and ETL design. Can we use new software technology to bypass this design and get right to processing data using DB2? NoSQL, MapReduce and GraphStore are becoming popular technologies for the storage and processing of what might be called "big data". This presentation will explore the possibility of using this available technology in DB2. Using the provided RDF (Resource Description Framework) NoSQL GraphStore feature of DB2, we will see if the typical complexities associated with data warehouses can be avoided

As with every release of DB2 a large number of features, functions and enhancements have been added to this latest offering. In this presentation I have included my top 20 and will count down to my number one DB2 11 feature. What will it be and will you agree with me?

There is always a lot of talk about the DB2 optimizer and what is the best access path for a particular query. While this is of course important it is also important to know that the optimizer is only part of the story. When a query is submitted one of the first thing that happens is that it goes through query transformation. In this part of the process DB2 interprets the submitted SQL, and rewrites it. Views and UDFs are merged with the query, subqueries possibly transformed to joins, table expressions merged, and much more. If you are a serious query tuner you need to understand what is happening during query transformation and what you can do to influence it. We'll learn about query transformation, how to view query transformation, and how to influence query transformation

Despite compelling business benefits to upgrade to new versions of DB2 for z/OS, many customers are unable to schedule migration projects in a timely manner. Two of the major issues responsible for these delays are scheduling the necessary remedial work to address any application incompatibilities introduced in the new release, and obtaining suitable change slots to allow the upgrade itself to proceed.

This presentation provides an overview of the new features introduced in DB2 11 for z/OS that are intended to address these issues, and allow customers to upgrade their DB2 systems more quickly and with less disruption than before