Planning to migrate from IBM PureData System for Analytics to Db2

You should review the migration steps and prepare your environment before you migrate your system.

Procedure

  • Become familiar with the differences between Db2® offerings. For information, see the Db2 overview.
  • Learn about PureData® System for Analytics and Db2 compatibility by reviewing the migration process and the compatibility topics.
  • Evaluate the compatibility of your PureData System for Analytics SQL commands in a Db2 environment by using IBM Database Harmony Profiler. For information about this tool, see the Database Conversion Workbench page. By submitting your evaluation reports to askdcw@ca.ibm.com, you can help IBM to prioritize and plan for the closure of compatibility gaps.
  • Determine your network requirements. For example, for IBM® Db2 Warehouse, review your firewall and port requirements and ground-to-cloud connectivity requirements, and review the "Network prerequisites" section in the applicable prerequisites topic. For the Db2 managed services, decide whether you need a VPN and understand how to set it up.

    You can use the IBM Cloud Integrated Analytics Environment (CIAE) to set up a secure connection between your Db2 system and services such as your business intelligence tool and the source database that feeds your Db2 system.

  • Determine your security requirements.
  • Review your architecture: the products that you are using and where they are located.
  • Size your system.
  • If you are using Db2 Warehouse:
    • Determine your file transfer requirements: your backup requirements, daily transfer volumes, and SLAs for load time.
    • Back up your data. For information, see Snapshot backup and restore on Db2 Warehouse.
      Restriction: You cannot use an IBM PureData® System for Analytics backup to restore to a Db2 database.