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 →

Testing: Dynamic Test-NG Tests

In my last few projects, I have used Test-NG.  Uniquely in my current project, I had to generate tests programmatically.  Instead of writing one test for each element in the project, I am able to generate a bunch at-will using the following pattern: Factory package test; import org.testng.annotations.Factory; public class DynamicTestFactory { @Factory public Object[] createInstances() { Object[] result = new Object[10]; for (int i = 0; i < 10; i++) { result[i] = new ExampleProcessorTest(Integer.toString(i * 10)+ “A”,Integer.toString(i*10) + “B”); } return result; } } Test Running Code I can also trigger using testng.xml <class name=”DynamicTestFactory” /> Reference https://testng.org/doc/documentation-main.html

Continue Reading →

Gatsby & Carbon: Build with Github Action

As some of you know, I work on the IBM FHIR Server and with my colleagues, I have started automating some of the actions we take – Build, Test, Deploy, Deploy our website. More specific to the “Deploy our website” automation, our website uses technologies, such as Gatsby, Carbon, Gatsby Carbon Theme. Fundamentally, a static site generation technology, like Jekyll, Gatsby uses Node, Yarn and some nice React code.

Continue Reading →