74

DB2 11 for Linux, UNIX, and Windows includes a broad set of enhancements to BLU Acceleration, taking the columnar in-memory database technology to a new level of maturity, performance, and scalability. This sessions provides an overview of new features and improvements in BLU Acceleration, including BLU DPF, native columnar sort and OLAP processing, columnar temporary tables, nested loop joins, richer support for SQL functions, extended codepage support, and other functional and performance enhancements. The new features will be presented through a series of examples with usage guidelines and best practices.

This presentation helps you understand some of the most significant changes and enhancements in DB2 11 for Linux, UNIX, and Windows. We will review the new fixpack strategy for DB2 LUW and discuss how the process for database upgrades has been greatly simplified. Additionally, this session explains new security features as well as reorg enhancements, performance and concurrency improvement, and significant simplifications for workload management and database federation. 

Drill-down on what has been delivered since DB2 V11.1 in the summer of 2016 and a look at what's to come over 2017 and 2018, including a focus on HTAP and Continuous Availability

In the early days of DB2 for z/OS the use of dynamic SQL was minimized at most DB2 installations due to fears over unreliable or unpredictable performance. That approach has been almost completely turned on its head now and it is common to find sites where the vast majority of application SQL is Dynamic rather than Static in nature. There are many reasons for this change, including the increasing use of languages such as Java rather than traditional COBOL and PL/I as well as Dynamic based Packaged Applications such as SAP. However, in order to support this gradual change over the years DB2 has also added many features to allow better Performance as well as Management of Dynamic SQL. Many don’t require application changes to allow you to exploit them, but others do and relatively minor changes in coding practice can produce significant benefits. This presentation will describe a variety of methods to improve the performance of Dynamic SQL and provide useful tips on how to best exploit them. Topics covered include using the Local and Global Statement Cache as well as the new Dynamic Plan Stability feature added in DB2 12 for z/OS and more.

The ability to partition DB2 tables has been available in DB2 since the very earliest releases, but over the past 10 years or so the number of choices available to DBA’s has exploded. During that time we’ve seen increases in the number of partitions, Table based rather than Index based partitioning, Data Partitioned Secondary Indexes, UTS objects which are partitioned by Growth or Range, and now in DB2 12 for z/OS Relative Page Numbering and the capability to create enormous objects. It’s got to the point where almost all DB2 tables are partitioned in one way or another – you just have to decide which option to choose. This session will run through all the options in turn, highlighting the benefits and drawbacks of each. We’ll provide hints and tips on how to get the best performance while minimizing Management and will highlight things you might need to watch out for when managing partitioned objects in your systems.

IBM DB2 Analytics Accelerator is one of the most exciting technologies implemented by DB2 for z/OS and System z in years. It has been widely adopted by numerous customers who enjoy its unprecedented business value. A unique combination of DB2's superb transactional capabilities and PureData for Analytics appliance's industry leading performance of complex queries enables combining transactional and analytical applications as well as optimizing use of System z processing resources. This presentation from the 'father of IDAA' brings the latest news from the IDAA development and shows the trends and directions in which this technology develops.