DB2 is a database management system that offers industry leading performance, scalability, and reliability on your choice of platform from Linux to z/OS. Its Web Control Center offers administrators an easy-to-use interface for maintaining databases, and can be run from any Java-enabled Web browser. For Java developers, DB2 UDB for Linux offers support for JDBC and SQLJ, and Net.Data allows for the creation of dynamic data diven Web applications. DB2 UDB for Linux allows you to harness the power of user-defined types and functions and support for Binary Large Objects.
|Tags||Database Database Engines/Servers|
|Licenses||Proprietary with Free Trial|
|Operating Systems||Windows AIX HP-UX Linux Solaris Mac OS X|
|Implementation||C C++ Java 6 ksh|
|Translations||Brazilian Portuguese Czech Danish Finnish French German Italian Japanese Korean Norwegian Polish Russian Chinese (Simplified) Spanish Swedish Chinese (Traditional)|
Release Notes: A new aggregate function LISTAGG (from Oracle), multiaction triggers, writable BEFORE triggers, default arguments for functions, and non-constant LIKE patterns. DB2 Text Search (based on Lucene) has been updated. It is now faster and more configurable.
Release Notes: Some critical bugs in the SQL optimizer newly introduced in 9.7.3 were fixed. These bugs caused some joins to return incorrect results. The new product DB2® Advanced Enterprise Server Edition was released, which is DB2 ESE packaged with feature packs for compression, performance, replication, security, and data integration.
Release Notes: LOB strings of any length continue to be supported in comparisons using the LIKE, NULL, and the POSSTR function. LOB strings less than 32k are supported as operands in other predicates and the simple CASE expression. Trap resilience functionality, a feature that keeps the instance active if certain traps occur, has now been extended to the load utility.
Release Notes: The new datatypes NCHAR, NVARCGAR, NCLOB, and UDF now support default and named arguments. Transportable tablespaces were implemented. There is no longer any need to tune Linux IPC kernel settings. Code obfuscation is supported for the body of a routine, trigger, or view. A new compatibility feature was added for applications compatible with Sybase ASE.
Release Notes: New features include Oracle PL/SQL procedural language support, shrinkable tablespaces, read support on HADR standby, index compression, online schema change, SQL*Plus compatibility, online table move, read committed isolation level (statement snapshot), scan sharing, the TRUNCATE statement, a statement concentrator (cursor sharing), added modules (Oracle packages), XML support in MDC and DPF tables, local partitioned indexes, weak typing, and CREATE OR REPLACE. LOB and XML can now be inlined and compressed.