Simplifying Access to Db2 Databases in Jupyter Notebook

Are you trying to figure out the best way to access Db2 data from within your Jupyter Notebook? Or perhaps you are already using a technique and are looking for ways to simplify things? If so, did you know that there are three ways of connecting to your existing Db2 data?

  1. Use native Python Db2 API calls to connect and manipulate the data
  2. Take advantage of Pandas built-in support of databases
  3. Install extensions to Jupyter notebooks (Magic commands)

Getting access to Db2 data from within a notebook requires that you use the following command to install the appropriate Db2 drivers either from your notebook or from a shell prompt.