69

In this session we will take a look at where the market is heading, what questions companies are struggling with and how existing DB2 clients have uniquely positioned themselves to leverage their existing investment to make the transition to a Big Data Analytic Ecosystem and to a Hybrid Cloud Ecosystem a simple one. We will take a look at the roadmap for DB2 and how this can be leverage as part of a Big Data ecosystem, on-premise, in the cloud and how your DB2 investment can be leveraged as you expand your analytic ecosystem to include Hadoop and Spark.

The DB2 for Linux, UNIX, and Windows releases in recent years have provided a rich set of functional improvements. In addition to the major flagship features, numerous small enhancements have found their way into the product as well. Among those are many hidden gems that are largely unknown and underutilized. This session presents 10 highly useful features and functions that are often overlooked and deserve more attention. Examples include the LISTAGG function, multiple-event triggers, usage lists, new options for db2look, and others. Attend this session to see how these gems can be valuable for you! 

How well DB2 handles Log data can be a critical factor in maximizing performance, particularly in a high transaction rate environment. There have been a number of changes in the area of Logging over recent DB2 releases. Some of these have been obvious improvements such as the ability to use DFSMS Striping for Active Log datasets, but there have been Logging implications in some other changes such as the introduction of Reordered Row Format. However, many sites I visit have not really investigated these changes in any detail and the impact they might have on their operations. This presentation provides an update on changes to how DB2 manages logging updates and some useful hints and tips you will be able to take away and use to review your logging environment.

DB2 9 introduced native SQL Procedures. DB2 10 enhanced performance and added SQL PL User Defined Functions. DB2 11 Introduces Autonomous SQL PL Procedures. Come learn more about SQL PL routines, how they work and how they compare with external routines coded in host languages such as COBOL, PL/I, Java, or C/C++. 

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.