There are many advanced features included in DB2 v11. I am giving here summarised list so that you can refer quickly.
- Table related change
- ALTER table-name DROP COLUMN statement is now available in DB2 11
- ALTER Expansion
- Partition Limit Keys functionality. This helps all of us expand or contract the partitioning key limits defined within our large table definitions.
- 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.
- Data Analytics
- DB211 database is for Big data analytics