58

We always assume thet tuning, and thius saving cpu, will result in actual monetary savings

Well, with IBMs Measured Workload Pricing this is not the case - we need to target our tuning at specific times of the month to see real value

This presentation starts by explaining how IBMs MLC works in practice and what this means to our DB2 world, before looking at some methodolgies for SQL tuning that ill result in paying lower software license charges

IBM DB2 Analytics Accelerator complements DB2's well known transactional workload capabilities with industry leading complex queries performance. With the accelerator DB2 becomes truly universal database management system that provides best performance regardless of the type of workload. New features are added to the accelerator in very short release cycles and 2014 is not an exception. Numerous new functions that enable new use cases, improve performance even further and provide new high levels of usability are added to the product. Come and learn about exciting new features from the product development presented by the IBM DB2 Analytics Accelerator's inventor and chief technologist.

Optimizer Hints have been available since DB2 Version 6 in 1999. This old method was hard to use and prone to error as it relied on the QUERYNO for each statement to link the SQL to the hint. If your program changed causing the QUERYNO to be different then the hint would not operate correctly. To resolve these problems DB2 10 for z/OS introduced a completely new method of providing hints based on the SQL Text and a Repository built into the DB2 Catalog. They can be applied to an SQL statement wherever it appears in the DB2 subsystem. Other advantages the new method provides include the ability to override certain Bind Options at the Statement rather than at the Package level, such as controls over Star joins and Parallelism options. DB2 11 has built on the initial implementation by allowing you to provide Filter Factors for predicates where the Optimizer is not able to calculate them, such as where Host Variables, Parameter Markers or Expressions are being used. This allows the Optimizer to make a more informed decision on the correct access path to use based on your knowledge of the application. This session will describe how to use System Level Access path hints as introduced in DB2 10 for z/OS, along with the additional features that have been added with DB2 11 for z/OS. 

DB2 11 is another testimony of DB2 for z/OS vitality and industry leadership. It brings out of the box CPU savings, numerous continuous availability features and enhanced business analytics capabilities. At the same time migration to the new version has been made simpler, faster and more robust than ever. This presentation will give you an overview of DB2 11 new features and enhancements, including performance improvements, non-disruptive changes and maintenance, extended log addressability, transparent archiving, Hadoop, noSQL and JSON support. 

Industry regulations and competitive pressures are prompting IT managers to maintain more data for longer periods of time and to provide better ways for business users to analyse past, current, and future events. The new temporal table support in DB2 10 for z/OS enables the database to keep track of both business and system events, making application development and maintenance simpler and more cost effective. In this presentation, Julian will provide an overview of DB2 10’s unique temporal capabilities and explore some of the business benefits they can provide

During the design of a DB2 application, there is now a lot more to consider than just “what should the tables look like”. We need to take into onsideration where we should create indexes, and why. We might think about partitioning for performance or for manageability. What about partitioned and non partitioned indexes – they each have their advantages and disadvantages. More recently, we’ve been given the option to create Materialized Query Tables, but when would these be good to use?

This presentation steps through some of the new (and not so new) elements of DB2 database design and highlights pros and cons of each

Unfortunately, as with a lot of DB2 decisions, there are no absolute correct answers – the right answer in your case will always “depend” on circumstances, but opefully this presentation will give you the information you need to make informed choices

This first part of presentation will focus on major DB2 10 trace enhancements and demonstrate how the CA Insight Database Performance Monitor addresses those. The second part will cover the product strategy and explain specific areas the development is working on. Customers will be asked to participate to the session, by providing candid feedback on the presented features and suggesting ideas to the product management

This presentation will explain the roadmap and the long term strategy of the Backup & Recovery suite; followed by explanations and demos of specific features that will be available soon. Customers will be asked to participate to the session, by providing candid feedback on the presented features and suggesting ideas to Backup & Recovery product management.

A walkthrough of how traces and IFCIDS can be used in DB2 performance analysis for applications or DB2 subsystems. The presentation is based on DB2 10.)