Migrating IBM PureData System for Analytics (Netezza) queries to Db2

Netezza and Db2® queries are generally compatible, but some exceptions apply. You can automatically fix many of the incompatibilities.

Procedure

Use one of the following approaches:
  • If your query was generated by a third-party tool, re-create the query by selecting the Db2 connector option in the tool.
  • If your query was not generated by a third-party tool, perform the following steps:
    1. Evaluate compatibility by using the Database Conversion Workbench or Database Harmony Profiler. For information about how to obtain and use these tools, see the Database Conversion Workbench page and IBM Database Conversion Workbench (DCW) topic.
    2. If the tool flags incompatibilities that it cannot fix, manually fix them.
    3. Automatically fix the remaining incompatibilities by running the Database Conversion Workbench or Database Harmony Profiler again.