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 →