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:
    • IBM provisions the Db2 managed service environment. For information, see the Getting started page.
  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 the Db2 managed service, use IBM Lift CLI. When you use Lift, you can set up processes to keep the moved data synchronized with the source during the activities in the following steps.
  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.