New DBMS Features

DB2 LUW 9.x: TIMESTAMP datatypes now support generated by default option. For more information, see GENERATED BY DEFAULT for DB2 UDB 9.x.

DB2 z/OS 9.x and 10.x: Range-partitioned Universal Tablespaces. For more information, see Range-partitioned Universal Tablespaces for DB2 z/OS 9.x and 10.x.

Netezza 6.0: Organizing keys now supported. For more information, see ORGANIZE ON for Netezza 6.0.

Oracle 10g and 11g: Capacity planning of tables can now be based on the average row size.

Teradata 12 and 13: ST_GEOMETRY datatype is now supported.

COLLECT STATISTICS and CHECKSUM clauses are now supported. For more information, see COLLECT STATISTICS for Teradata 12.0 and 13.x and CHECKSUM for Teradata 12.0 and 13.x

PostgreSQL 8.0 and 9.x: Support has been added for uuid, money, xml, and serial datatypes; uuid is mapped to the UNQUEID logical type; money is mapped to MONEY logical type, xml is mapped to XML logical type; and serial is mapped to SERIAL/INTEGER logical type.