More Information

DB2

Changes: 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.

Changes: 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.

Changes: 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.

Changes: 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.

Changes: 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.