Migrating user-defined extensions (UDXs) based on R and Python from IBM PureData® System for Analytics (Netezza) to Db2 Warehouse

To migrate UDXs that are written in R, you must first deploy R on the Db2® Warehouse system. UDXs that are written in Python often use functions that are provided by Python packages. Therefore, you must probably first install these packages on the Db2 Warehouse system.

• To migrate UDXs that are written in R, take the following steps:
  1. Deploy R on the Db2 Warehouse system in one of the following ways:
     • By porting R through Spark.
     • For all hardware systems, except for POWER LE, by creating an integrated RStudio environment.
  2. Follow the instructions in Deploying R to Db2 Warehouse.
  3. For more information about how to run R scripts to read and write from Db2 Warehouse, about in-database analytics with R, and about details of the pre-installed R packages on Db2 Warehouse, see Analyzing with R.
• To migrate UDXs that are written in Python, take the following steps:
  1. Install the Python packages on each Db2 Warehouse node that requires them as described in Installing Python packages on Db2 Warehouse.
  2. For more information about how to run Python scripts to read and write from Db2 Warehouse and about in-database analytics by using Python, see Analyzing with Python.

Results

You can now work with UDXs that are based on R and Python on Db2 Warehouse.