---
title: "DB2 V11- Analytics and Big Data Features"
description: "DB2 11 also boast s 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 an..."
url: https://srinimf.com/2014/10/28/db2-v11-analytics-and-bigdata-features/
date: 2014-10-28
modified: 2026-10-16
author: "Srini"
categories: ["Analytics", "DB2"]
tags: ["DB2 new features", "Db2 Tips"]
type: post
lang: en
---

# DB2 V11- Analytics and Big Data Features

DB2 11 also boast[s new features](https://srinimf.com/2013/11/27/db2-11-for-zos-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.

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2014%2F10%2F28%2Fdb2-v11-analytics-and-bigdata-features%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2026%2F02%2Fcropped-logo.png%3Ffit%3D96%252C96%26ssl%3D1&description=DB2%20V11-%20%20Analytics%20and%20Big%20Data%20Features)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2014/10/28/db2-v11-analytics-and-bigdata-features/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2014/10/28/db2-v11-analytics-and-bigdata-features/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2014/10/28/db2-v11-analytics-and-bigdata-features/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2014/10/28/db2-v11-analytics-and-bigdata-features/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20V11-%20%20Analytics%20and%20Big%20Data%20Features&body=https%3A%2F%2Fsrinimf.com%2F2014%2F10%2F28%2Fdb2-v11-analytics-and-bigdata-features%2F&share=email)
-

### Like this:

Like Loading…