Plugins 〉DB2 Datasource


Developer
Grafana Labs

Sign up to receive occasional product news and updates:



Data Source
grafana
Enterprise

DB2 Datasource

  • Overview
  • Installation
  • Change log
  • Related content

Grafana DB2 Data source

This data source had been deprecated. Use the Grafana Sqlyze data source.

A Grafana data source plugin for IBM DB2

BETA

This plugin is currently in BETA development and subject to change.

The BETA version currently returns all values as text. You can use Grafana Transformations to convert text fields to the proper data type (date, number, etc).

The DB2 data source uses ODBC

This plugin has a dependency on ODBC. Windows/Linux/MacOS all support ODBC. Some dependencies may need to be installed.

Using ODBC with Linux or MacOS

Install or make sure unixODBC is installed

https://www.ibm.com/docs/en/db2/11.5?topic=managers-installing-unixodbc-driver-manager

This plugin requires an ODBC driver. ODBC Drivers for DB2 are available through IBM or 3rd parties.

IBM drivers

  • Can be downloaded from IBM Fix Central where you can choose your DB2 Version and Platform: https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=11.5.*&platform=Mac+OSX&function=all

  • Driver Settings - set the path to where the driver is installed and add required settings (MacOS example below)

SettingExample Value
Driver/Applications/dsdriver/lib/libdb2o.dylib
Timeout (seconds)10
host127.0.0.1
port50000
uiddb2inst1
pwd••••••••••••
databasesample

Third party drivers

Settings vary per driver. This plugin allows any key/value pair to support various DB2 ODBC drivers.

Installing DB2 Datasource:

For more information, visit the docs on plugin installation.

Changelog

v0.0.9 - 2023-06-08

  • ⚙️ Chore: backend libs updated with golang:1.20.5

v0.0.8 - 2023-05-04

  • ⚙️ Chore: Backend binaries are now compiled with golang 1.20.4

v0.0.7 - 2023-04-20

  • ⚙️ Chore: Backend binaries are now compiled with golang 1.20.3

v0.0.6

  • ⚙️ Chore: Update backend dependencies
  • ⚙️ Chore: Backend binaries are now compiled with Go 1.19.4

v0.0.5

  • 🐛 Fix: set exec permission

v0.0.4

  • Add Linux ARM and Windows distributions

v0.0.3

  • 🐛 Fix: more portable linux distribution

v0.0.1

  • Initial release.