DB2 V11- Analytics and Bigdata Features

DB2 11 also boasts new features for supporting big data and analytical processing. Probably the biggest is the ability to support Hadoop access.

DB2 11 can be used to enable applications to easily and efficiently access Hadoop data sources using the generic table UDF capability to create a variable shape of UDF output table. Doing so allows access to BigInsights, which is IBM’s Hadoop-based platform for big data. As such, you can use JSON to access Hadoop data via DB2 using the UDF supplied by IBM BigInsights.

DB2 11 also adds new SQL analytical extensions, including GROUPING SETS, ROLLUP, and CUBE. And a new version (V3) of IBM DB2 Analytics Accelerator (IDAA) is part of the mix too.

IDAA V3 brings about improvements such as 1.3 PB of data storage, Change Data Capture support to capture changes to DB2 data and propagate them to IDAA as they happen, additional SQL functions for IDAA queries, and Work Load Manager integration.

DROP COLUMN Possible now:

DB2 11 also delivers improved online schema change functionality, including the long-awaited DROP COLUMN capability, which can be used to clean up unused columns in DB2 tables.

NEW BIND Option:

There is also the new APREUSE(WARN) BIND option, which causes DB2 to try to reuse previous access paths for SQL statements, but does not prevent the bind (or rebind) when access paths cannot be reused.