Getting Explain to work with IBM Db2 on Cloud

My team has been running more workloads on IBM Cloud, more specifically with IBM Db2. Our daily tools are slightly different to work with in the cloud, less administrative access and tools we can access on the host – db2batch, db2advis, db2expln and other native tools. That’s when I ran across some great references that lead me in a direction that works for my team. Create a User (with Password) Catalog the Remote Database Run db2expln Login to the IBM Cloud console Click Open Console Expand Settings Click Manage Users Click Add Click Add User Enter the relevant details for…

Continue Reading →

Fun with Patent Data: Thomas Edison Jupyter Notebook

Thomas Alva Edison was a famous American inventor and businessman, “described as America’s greatest inventor”, and was one of the most prolific inventors in US history. Thomas Edison was granted/filed 1084 patents from 1847-1931.[1] He’s just one cool inventor – lamps, light bulbs, phonograph and so many more life changing inventions. Google Patents has a wonderful depth of patent history, and the history is searchable with custom search strings: inventor:(Thomas Edison) before:priority:19310101 inventor:(Paul R Bastide) after:priority:2009-01-01 Google provides a seriously cool feature – a downloadable csv. Pandas anyone? The content is provided in an agreement between the USPTO and Google. Google…

Continue Reading →

AppDev: Zookeeper Port Forwarding to all servers from local machine

To simply testing with Zookeeper on a remote Kafka cluster, one must connect to the client application ports on the backend.  When the remote Kafka cluster has multiple nodes and behind a firewall and a SSH jump server, the complexity is fairly high.  Note, the SSH jump server is the permitted man in the middle.    The client must allow application access to Zookeeper on Kafka – listening locally. Current techniques allow for a single port hosted on the developers machine for instance, 2181 listening on the local machine, and a single remote server.  This approach is not reliable –…

Continue Reading →