---
title: "DB2 11 for ZO/S new features"
description: "Summarised DB2v11 developer related enhancements. Read more."
url: https://srinimf.com/2013/11/27/db2-11-for-zos-new-features/
date: 2013-11-27
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2013/11/db2-v11.png?fit=543%2C316&ssl=1
categories: ["DB2 V11"]
tags: ["DB2 Tips and Solutions"]
type: post
lang: en
---

# DB2 11 for ZO/S new features

There are many advanced features included in [DB2 v11](https://srinimf.com/2014/10/28/db2-v11-analytics-and-bigdata-features/). I am giving [here s](https://srinimf.com/2016/01/30/how-to-change-table-column-data-type-in-db2/)ummarised list so that you can refer quickly.

![DB211 new enhancements](http://media.gettyimages.com/photos/kazakhstan-businesswoman-working-on-laptop-in-server-room-picture-id135205597?k=6&m=135205597&s=170667a&w=0&h=xrhGVcTmlzPrkWIztcXpoMdqlrj8Vz9KI62EhOnCvFo=)

1. **Table related change**
   - [ALTER table](https://srinimf.com/2018/10/25/sql-alter-statement-top-examples-useful-to-write-any-complex-query/)-name DROP COLUMN statement is now available in DB2 11
2. **ALTER Expansion**
   - Partition Limit Keys functionality.  This helps all of us expand or contract the partitioning key limits defined within our large table definitions.
3. **JSON introduction**
   - JSON is replacing XML as developers choose the new easy JSON interface for all types of applications.  Web applications, mobile phone applications as well as C, Java and other new developer application languages are embracing JSON as their API to the retrieve data.  HTML5, AJAX, and JSON are the new combination for all types of applications. DB2 11 for z/OS with its new JSON API and data store handles the schema chaos easily.
4. **Data Analytics** Related[DB2 11 for ZO/S new features](https://srinimf.com/2013/11/27/db2-11-for-zos-new-features/)
   - DB211 database is for [Big data](https://srinimf.com/2015/11/09/big-data-and-analytics-with-db2-v11/) analytics

###### Also Read: [Hybrid storage and access details](https://www.ibm.com/developerworks/community/blogs/Keshav/entry/informix_nosql_hybrid_storage_and_access)

### 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%2F2013%2F11%2F27%2Fdb2-11-for-zos-new-features%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2013%2F11%2Fdb2-v11.png%3Ffit%3D543%252C316%26ssl%3D1&description=DB2%2011%20for%20ZO%2FS%20new%20features)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2013/11/27/db2-11-for-zos-new-features/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2013/11/27/db2-11-for-zos-new-features/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2013/11/27/db2-11-for-zos-new-features/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2013/11/27/db2-11-for-zos-new-features/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%2011%20for%20ZO%2FS%20new%20features&body=https%3A%2F%2Fsrinimf.com%2F2013%2F11%2F27%2Fdb2-11-for-zos-new-features%2F&share=email)
-

### Like this:

Like Loading…