INTRODUCTION

SQL

• SELECT FROM UPDATE or SELECT FROM DELETE function
• INSTEAD OF triggers
• File reference variables
• INTERSECT keyword in a fullselect
• EXCEPT keyword in subselect
• OLAP specifications for RANK, DENSE_RANK, and ROW_NUMBER
  • RANK and DENSE_RANK
  • ROW_NUMBER
  • COLLATION_KEY function
• TRUNCATE TABLE statement
• DECFLOAT built-in data type
• VARBINARY data type
• MERGE and SELECT FROM MERGE statements
• FETCH FIRST n ROWS ONLY and ORDER BY in subselects and fullselects

PERFORMANCE

• Creating an index on an expression
• Reduction in CPU processing time for utilities
• SQL optimization improvements
• Index changes
  • Index compression
  • Index on expression
  • Larger index page sizes
  • Index key randomization
• Varying-length rows
• Sequential key insert
• Data insert

ENVIRONMENT/SYSTEM CHANGES

• XML
• BIGINT data type and function
• BINARY data type and function
• Non logged table spaces
• New language support
• Large object changes
• Cloning Tables
• Universal Tablespaces
• Reordered Row Format
• Log changes

OTHER

• SQL procedures
• Nested compound statements in SQL procedures
• Automatic object creation
• IBM Spatial Support
• Locking Changes
• Changes to DB2 Tools
• Utilities management tools
• DB2 Automation Tool for z/OS
• Performance management tools
• Recovery management tools
• Application management tools
• Business analysis tools
• Information integration tools
• IBM Optimization Service Center
• IBM DB2 Optimization Expert
• Trusted context support
• Trigger Changes