---
title: "DB2 V11 Top New Features"
description: "New featured added in Db2 version 11 for Zos. Read more."
url: https://srinimf.com/2014/01/31/db2-v11-zos-new-features/
date: 2014-01-31
modified: 2026-10-10
author: "Srini"
categories: ["DB2"]
tags: ["Db2 Tips", "DB2 v11 newly added features"]
type: post
lang: en
---

# DB2 V11 Top New Features

What is new in [DB2 V11](https://srinimf.com/2014/09/17/db2-v11-new-technique-duplicate-removal/) for ZO/s.

- less CPU time on heavy insert, select query workloads, and when running queries against compressed tables.
- Improved data sharing performance and efficiency.
- Improved utility performance and additional zIIP off-load for LOAD and RUNSTATUS
- Cost-effective archiving of warm and cold data with easy access to both within a single query
- Intelligent statistics gathering and advanced optimization technology for efficient query execution in dynamic workloads.
- Additional online schema changes that simplify management, reduce the need for planned outages, and minimize the need for REORG.
- Productivity improvements for DBAs, application developers and system administrators.
- Efficient real-time scoring within your existing transaction environment.
- Enhanced analysis, forecasting, reporting and presentation capabilities, as well as improved storage management, in QMF.
- Expanded SQL, SQL PL, temporal and XML function for better application performance.
- Faster migration with application protection from incompatible SQL and XML changes and simpler catalog migration.
- [DB2 11](https://srinimf.com/2013/11/06/db2-11-advanced-featutres/) is its support of an extended RBA. Read [this Robert Catterall post ](http://robertsdb2blog.blogspot.in/2012/10/db2-for-zos-have-you-checked-your-log.html)for a good explanation of this feature.
- The addition of DROP COLUMN should continue to improve online schema changes. New online data repartitioning is designed to significantly reduce the need for planned outages.

See some more.

- No application changes required for DB2 upgrades
- DB2 11 also brings performance enhancements with long running BIND and DDL threads and improved clone table management and more efficient data sharing.
- DB2 11 applications with SQL or XML will be able to run in compatibility mode, even if they’re incompatible with the new release.
- New functionality “Index Duplicate Removal”
- Suppress Null index- It suppress if all values are Null in Index columns
- Good support for data analytics/integration

Refer [**here**](http://www.mdug.org/Presentations/DB2%2011%20Overview%20UG%20November%202013%20.pdf)for more details.

### 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%2F01%2F31%2Fdb2-v11-zos-new-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%20Top%20New%20Features)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2014/01/31/db2-v11-zos-new-features/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2014/01/31/db2-v11-zos-new-features/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2014/01/31/db2-v11-zos-new-features/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2014/01/31/db2-v11-zos-new-features/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20V11%20Top%20New%20Features&body=https%3A%2F%2Fsrinimf.com%2F2014%2F01%2F31%2Fdb2-v11-zos-new-features%2F&share=email)
-

### Like this:

Like Loading…