DB2 10 arrives !

IBM announces DB2 10 for Linux Unix and Windows !  Code named Galileo, DB2 10 arrives with some neat features. We all know DB2 V9.7 was loaded with features, especially with Oracle compatibility. IBM has improved upon the Oracle compatibility mode making it almost 98%.
DB2 10 for LUW should be available for general electronic download on April 30, 2012 and for media order on June 11, 2012.
As usual the new DB2 is feature rich. IBM has packed some neat features on DB2 10. Among them some key ones are:

• Adaptive Compression
• Time Travel Query
• Enhanced security
• High performance warehouse features (Zigzag join)
• Multi Temperature data management
• Enhanced Workload Tuner
• Continuous data ingestion
• DB2 pureScale(enhancements)

IBM has also made changes to features available on DB2 editions.

Summary of DB2 10.1 edition changes:

Resource limits for each edition, where applicable, are also listed below.

DB2 Express-C:

• Time Travel Query.
• IBM Data Studio.
• Memory limit has been increased to 4 GB. Processor core limit has been increased to two. Both limits are per physical server, or where partitioned, virtual server.

DB2 Express Edition:

• Row and Column Access Control.
• Label Based Access Control
• Time Travel Query.
• High Availability Disaster Recover (HADR).
• IBM Data Studio.
• Memory limit has been increased to 8 GB. Processor core limit remains at four. Both limits are per physical server, or where partitioned, virtual server.

DB2 Workgroup Server Edition:

• Row and Column Access Control.
• Label Based Access Control.
• Time Travel Query.
• IBM Data Studio.
• Memory limit remains at 64 GB. Processor core limit remains at 16. Both limits are per physical server, or where partitioned, virtual server.

DB2 Enterprise Server Edition:

• Row and Column Access Control
• Label Based Access Control
• Time Travel Query
• Multi-Temperature Data Management
• IBM Data Studio

DB2 Advanced Enterprise Server Edition:

• Row and Column Access Control
• Label Based Access Control
• Time Travel Query
• Multi-Temperature Data Management
• Storage Optimization Feature, including Adaptive Compression
• Continuous Data Ingest
• IBM Data Studio
• InfoSphere Data Architect (10 users)
• InfoSphere Optim Configuration Manager
• InfoSphere Optim Performance Manager Extended Edition
• InfoSphere Optim Query Workload Tuner
• InfoSphere Optim pureQuery Runtime for LUW

IBM Database Enterprise Developer Edition:

• Row and Column Access Control
• Label Based Access Control
• Time Travel Query
• Multi-Temperature Data Management
• Storage Optimization Feature, including Adaptive Compression
• Continuous Data Ingest
• IBM Data Studio
• InfoSphere Data Architect
• InfoSphere Optim Configuration Manager
• InfoSphere Optim Performance Manager Extended Edition
• InfoSphere Optim Query Workload Tuner
• InfoSphere Optim pureQuery Runtime for LUW

Here is a link that gives you a more in-depth look at the features