IBM in-Database Analytics for R

Functionality required to efficiently use R with IBM(R) Db2(R) Warehouse offerings (formerly IBM dashDB(R)) and IBM Db2 for z/OS(R) in conjunction with IBM Db2 Analytics Accelerator for z/OS. Many basic and complex R operations are pushed down into the database, which removes the main memory boundary of R and allows to make full use of parallel processing in the underlying database.

The ibmdbR package works with IBM DB2(C) for Linux and Windows Version 10.5, and with IBM dashDB(C). Before you start, you must install DB2 or provision an instance of dashDB on the cloud (see link below).

If you use dashDB on the web, everything is pre-configured and ready to be used from your web browser. If you connect to a DB2 server or use dashDB remotely, you must first install the appropriate client driver packages. For DB2, the driver packages come with the product; for dashDB, you can download them from the dashDB web console.

After you install the driver packages you must configure an ODBC source. Refer to the documentation of your operating system for information on how to do this.

For an introduction to the package and first steps, see the package vignette "Use IBM In-Database Analytics with R".


ibmdbR 1.48.0

  • Added support for DB2 for z/OS (C) in conjunction with IBM DB2 Analytics Accelerator (C).
    • DB2 for z/OS with IBM DB2 Analytics Accelerator (C) support for:
      • idaArule
      • idaKMeans
      • idaLm
      • idaNaiveBayes
      • idaTree
    • New DB2 for z/OS with IBM DB2 Analytics Accelerator (C) clustering algorithms:
      • idaTwoStep
      • idaDivCluster
  • Calculating idaLm model statistics failed in some cases when categorical variables were present

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.


1.49.0 by Alexander Eckert, 4 months ago

Browse source code at

Authors: Alexander Eckert [aut, cre], Toni Bollinger [aut], Michael Wurst [aut], Craig Blaha [ctb] (documentation), IBM Corporation [cph]

Documentation:   PDF Manual  

GPL-3 license

Imports MASS, rpart, rpart.plot, ggplot2

Depends on methods, RODBC, Matrix, arules

See at CRAN