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 →