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.
Release Notes: This version adds support for SLES 11, the ability to block nonlogged activity on tables on a system wide basis, unlimited password length, AES password encryption, SSL encrypted connections, and ITMA fixes for Linux. The pureXML feature is now free to use. The new DB2 Text Search (fulltext) component supports searching SQL, XML, and rich text with national languages support. The new DB2TOP monitoring tool is included on Unix systems.
Release Notes: PureXML support, a self tuning memory manager, automatic storage, a workload manager, label based security control, optimistic locking, and support for large tablespaces were added.
Release Notes: The following new development environment licenses are now available: DB2 Warehouse Manager, DB2 Data Links Manager, DB2 Net Search Extender, DB2 Relational Connect, DB2 Spatial Extender, and DB2 Text Information Extender.
Release Notes: Ease-of-administration enhancements (new Index Smart Guide and performance monitor), application development enhancements (enhanced UNICODE support and increased table/column limits), OLE DB container support, providing access to OLE DB data sources such as Microsoft Access, and DB2 connect enhancements, such as connection pooling for deployment of large-scale Web-based applications.
Release Notes: The new beta 6.0 is supposed to be more stable than beta 5.2. 5.2 will be withdrawn on 7th June 1999.