Projects / DB2 / Releases / 9.7.1

Version 9.7.1 of DB2

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.

Other releases

  •  06 May 2011 23:11

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.

  •  27 Oct 2010 17:09

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.

  •  13 Sep 2010 07:01

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.

Screenshot

Project Spotlight

phpMyAdmin

A tool that handles the basic administration of MySQL over the Web.

Screenshot

Project Spotlight

Mylene

A command line audio MPEG player.