More Information

DB2

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

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.