IBM PureData System for Analytics (Netezza) and Db2 data type compatibility

Netezza® and Db2® databases share a large common set of data types. To learn about data type incompatibilities and how to manage them when migrating from a Netezza database to a Db2 database, review the following topics.

You can use tools such as IBM® Database Harmony Profiler to assess and migrate data definitions and SQL commands. Database Harmony Profiler can help to identify possible conversion considerations and convert SQL commands. During conversion, Database Harmony Profiler maps Netezza data types to the equivalent Db2 types. These changes typically do not alter the nature of the data nor the queries that process data that is stored in columns of those types. Database Harmony Profiler and similar tools cannot automatically make some data type changes, so manual intervention is required.