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.

Getting Started

The ibmdbR package works with the following IBM database products and services:

  • Products:
    • IBM® Db2® Warehouse (formerly IBM dashDB® Local)
    • IBM Db2 for z/OS® in conjunction with IBM Db2 Analytics Accelerator for z/OS
  • Managed services:
    • IBM Db2 Warehouse on Cloud (formerly IBM dashDB for Analytics)

Before you start, you must install one of these products or provision an instance of one of these managed services. For more information, see:

If you use a Db2 managed service directly, everything is pre-configured and ready to be used from your web browser. If you connect to a Db2 server or use a Db2 managed service remotely, you must first install the appropriate client driver packages. You can download the packages from the service’s 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.49.0

New features

  • Exported idaAppend function, which appends the contents of a data.frame to an
  • Usage of temporary ids in idaLm, if no valid id column was specified.


  • Added instructions to setup ODBC on Mac.

Bug fixes

  • Fixed an error which could occur when no rules are returned from idaArule.

ibmdbR 1.48.0

New features

  • 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
    • New DB2 for z/OS with IBM DB2 Analytics Accelerator (C) regression algorithm:
      • idaGlm

Bug fixes

  • 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.50.0 by Toni Bollinger, 3 years ago

Browse source code at

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

Documentation:   PDF Manual  

Task views: Model Deployment with R

GPL-3 license

Imports MASS, rpart, rpart.plot, ggplot2

Depends on methods, RODBC, Matrix, arules

Suggests SparkR

See at CRAN