Connecting to an Informix Database from Jupyter Notebook

There is almost nothing in this blog post about Db2. This is unusual for me. But I had a bear of a time figuring this out, so I need to share. I have a lot of Db2 performance data that is stored in an Informix databse. This means that if I want to apply things I'm learning with Jupyter Notebook and data science to this data, I had to learn the basics of how to connect to an Informix database. Continue reading »

Update on Ember’s Data Science Journey – February 18, 2019

I’ve been moving along well this year on my data science journey. I’ve been thoroughly enjoying an edX class: Python for Data Science from UC San Diego. I started using Jupyter Notebooks (Python Kernel) over a year and a half ago, so I am enjoying the course on three levels:

  1. It seems easy because I have a background in Python, basic programming, and Linux systems
  2. I’m learning more about the Python libraries I use for Db2 health checks, and more about DataFrames that builds on my self-taught knowledge.
Read the rest Continue reading »

Using Windows AD groups in DB2

DB2 has an “interesting” relationship with Windows OS, and one of the areas where that relationship comes to the surface is user authentication and authorization, particularly when one is trying to use Active Domain groups for authorization purposes.

Here are a few pointers:

  1. Don’t use CLIENT authentication – this authentication method is explicitly excluded from the ability to use AD groups for authorization purposes.
Read the rest Continue reading »