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