IBM Database Conversion Workbench (DCW)

IBM® Database Conversion Workbench (DCW) is a no-charge tool and provides an end-to-end solution through UI tooling to facilitate the conversion of Oracle & Teradata databases to DB2 on premise and cloud databases.

Database Conversion Workbench (DCW) provides the following features:
  • SQL evaluation & effort estimation
  • SQL editing & debugging
  • SQL conversion & deployment

These features and processes are based on several leading practices that are identified by IBM data migration consultants. You can download DCW from IBM community page.

To assess the compatibility of your Oracle database or IBM PureData® System for Analytics (Netezza) database with Db2® and convert SQL, you can also use the free tool called IBM Database Harmony Profiler. If you are using Db2 Warehouse, you can download this tool by clicking Connect > Download Tools > Database Conversion Software in the web console. This tool is also included in the Db2 Warehouse client container. If you are using the tool that is in the Db2 Warehouse client container, you must run the tool script (db_harmony_profiler.sh) from inside the client container, from the cli prompt. To obtain the prompt, issue the following command: 
docker exec -it client cli
To run the Database Conversion Workbench or the Database Harmony Profiler GUI tool to help migrate from PureData® System for Analytics to Db2, enter an input file name, select PureData Systems for Analytics as the source database and IBM Db2 Warehouse as the target database, and click Check Compatibility or Convert SQL. If you are using the script version of Database Harmony Profiler, evaluate compatibility or convert SQL by issuing one of the following commands from the location where you installed the tool:
db_harmony_profiler.sh evaluate 6 input_file
db_harmony_profiler.sh convert 6 input_file
The value 6 specifies that you are migrating from PureData System for Analytics to Db2.