Migrating from IBM PureData System for Analytics (Netezza) to a Db2 system

Use the information in this topic to understand and perform the end-to-end process of migrating from IBM PureData® System for Analytics (Netezza®) to a Db2 system.

Procedure

  1. Plan your migration.
  2. Acquire your system:
  3. Create database objects, such as tables.
    You do not need to create the Db2 database itself; it is created for you. To create database objects, execute the converted DDL on the web console Analytics or Run SQL tab, or use another command-line interface.
  4. Move your data.
  5. Migrate your users, groups and security configuration.
    For more information, see Security.
  6. Map your system views.
  7. Migrate your queries.
  8. Migrate your routines.
  9. Migrate user-defined extensions.
    See IBM PureData System for Analytics (Netezza) and Db2 user-defined extensions compatibility.
  10. Redirect users and applications to the Db2 database. For example, change drivers or BI tools to point to the database.
  11. Validate your migration.