TechSpot

IBM DB2 Universal Database for Linux, UNIX and Windows

Free DB2 Universal Database for Linux, UNIX and Windows.

Windows
Freeware
20.5 MB
5,138
4.74.7 15 votes
DB2 UDB, V8.2 builds on its market-proven industrial strength and on demand capabilities with the following key enhancements:

* Reduces deployment and management costs

o The Design Advisor helps by suggesting design alternatives for advanced features like materialized query tables, multi-dimensional data clustering, partitioning, and indexing data. In tests conducted by IBM on a common complex query workload with one terabyte of data, Design Advisor was able to increase the performance of an un-tuned database by 84%.

o DB2 will now automate key maintenance activities based on business policies. Among the tasks that can now be automated are database backups, data defragmentation (table or index reorganization), and data access optimization (collecting statistics).

* Increases programmer productivity

o DB2 is delivering a variety of plug-ins, like database object manipulation and integrated help, to the Eclipse framework to allow developers to easily and efficiently interact with DB2.

o Building on an already extensive integration with Visual Studio, DB2 is now the first relational database to support stored procedures written in Microsoft’s Common Language Runtime (CLR) compliant languages such as Visual Basic and C#.

o There are numerous improvements to the DB2 Universal JDBC Driver for V8.2, including distributed transaction or JTA support, connection pooling support and JDBC 3.0 compliance. Other new features increase the flexibility of iterator use in SQLJ and enhance interactivity with host and iSeries databases.

* Provides a robust infrastructure

o High Availability Disaster Recovery (HADR) provides a new alternative for delivering a high-availability solution by replicating data which includes a wizard allowing complete configuration in minutes. Combined with the new client reroute capability, HADR masks any failures from applications allowing uninterrupted access to data.

o DB2 continues to invest in the Linux platform and now supports distributions based on the new 2.6 kernel. Exploitation of new I/O and memory management features found in the latest Linux distributions is provided, including a variety of 64-bit platforms like Intel, POWER, and zSeries.