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.
    For Db2 Warehouse, use the db_migrate command; see Moving data using db_migrate.
  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.