Dates for the IDUG Db2 Tech conferences in 2023

IDUG: International Db2 User Group

Just in time for the holidays, IDUG (International Db2 User Group) has announced the dates and locations for their user group conferences in North America and in Europe:

• 2023 IDUG NA Db2 Tech Conference will be in Philadelphia and is planned from May 16-19. As a change from previous years, the event will start on a Tuesday. The call for presentations is closing end of this month, December 31st. Check the website for details.
  
• 2023 IDUG EMEA Db2 Techn Conference is planned for October 16-19 Prague. With those dates, the event is back to a start on Monday. The call for presentations is not live yet, but expect it soon.

Enjoy the holidays.

Finally together: Db2 and Zeppelin

United: Db2 and Zeppelin

If you followed my blog, you may have noticed that I wrote about Db2 and about Zeppelins in the past - but not together. Today, I am going to discuss how I configured a JDBC interpreter in an Apache Zeppelin notebook to connect to a Db2 on Cloud database. So, finally, within a single blog post, I can talk about both of them. Let's get started.

IDUG 2022 EMEA conference is over - keep it going

"IDUG 2023 EMEA will be in"

The IDUG 2022 EMEA Db2 Tech Conference is over. What a week it was! Hard work, not much sleep, technical education, in-person networking, fun, and much more. After getting home, I needed two days and especially the nights to recharge, then the last week to reflect. Here are my random thoughts...

Things I learned at IDUG on JSON Web Token support in Db2

JSON Web Token support in Db2

Right now, I am at the IDUG 2022 EMEA Db2 Tech Conference in Edinburgh, Scotland. It's great to have an in-person event again, to network and to discuss. This year, there are many sessions covering Db2 security and they are well-attended. Database security seems to be (more) popular, now. In the past, I have blogged about JSON Web Tokens (JWT) and Db2. They allow a Single Sign-On (SSO) integration of Db2.

Terraform multi-account setup for IBM Cloud

Making progress with Terraform

Today's post is a quick write-up for me, kind of my own documentation. I wanted to access two different IBM Cloud accounts within a single Terraform deployment. But how to proceed? It is relatively simple if you know how to (and found the relevant documentation). Here is what my setup looks like.

New IBM Cloud security features you should know

Custom role for operating Code Engine

Cybersecurity is always in a state of change. There are new security features and new attack methods - or was it the other way? Over the past months, several new security features were added to IBM Cloud. In this blog post, I want to quickly describe them and point you to IBM Cloud blog posts where I discuss them in greater detail.

Database event in Edinburgh: IDUG 2022 EMEA Db2 Tech Conference

IDUG 2022 Db2 Tech Conference

Two months are left before the IDUG 2022 EMEA Db2 Tech Conference is to begin. After two years of virtual-only events, this conference marks a new start for the (mostly) European part of the Db2 community, the International Db2 User Group (IDUG). Last month, the IDUG 2022 NA conference in Boston, USA, showed the value of face-to-face events. Networking, formal and informal exchange of information, education, certification, and some fun. So what to expect from the conference in October?

Use event subscriptions for scheduled scale up and down of your IBM Cloud Code Engine apps

Few lines of scripting

Over the past months, I wrote several blog posts related to IBM Cloud Code Engine. Code Engine is a managed, serverless platform for containerized workloads. You can run (web) apps and (batch) jobs, both types can receive events. Code Engine apps have settings for minimum and maximum scaling and have assigned compute resources within these boundaries. A "scale to zero" is possible, i.e., there isn't any app instance running and, because it is pay per use, nothing is charged during that time. Which brings up the question, how can I schedule different min / max scale values, e.g., scale down to zero over night, but have some higher minimums during the day? 

I heard that built-in support is on the roadmap. For now, I am using a Code Engine cron subscription for the job...

Create a REST API with OpenAPI spec for your database objects

Swagger UI for my events API

Recently, I wanted to create REST API for data managed in a Db2 on Cloud database. It was needed for a chatbot project using Watson Assistant. After looking into my options, I settled on APIFlask. In this blog, I am going to share my experiences and some resources for creating a REST API with an OpenAPI specification for database objects.

Containerize your Db2 Python app

De-containerizing my stuff

By following my blog posts (here or at the IBM Cloud site)  or my code samples, you might know that many of my apps are coded in Python. Moreover, many projects involve IBM Db2 (see "How to connect from Python to Db2"). With Docker and other container technologies around and many projects involving Kubernetes / OpenShift or Knative / IBM Cloud Code Engine, the next question is how to containerize / dockerize your Db2 application written in Python. Well, here I share some of my experience...

Some fun with traefik routing on the edge of a reverse proxy

Path-based routing with Traefik

In a recent blog post, I mentioned that I use the traefik edge router / reverse proxy to put a custom domain in front of my IBM Cloud Code Engine apps. Today, I want to share details on how I configured path-based routing, i.e., depending on the path in the URI a different Code Engine app serves the request. The use case is to implement a microservices-based solution architecture with multiple backend services reachable over a single host name (on a custom domain).

A simple nginx deployment on IBM Cloud Code Engine

HTML files as configmap in Code Engine

Over the weekend I deployed nginx on IBM Cloud Code Engine. It's nothing fancy or earth-moving. But I wanted to note down and share the steps with you on how to deploy this HTTP server and serve few static HTML pages. All is based on using the command line interface (CLI) and is done with few commands.

Custom domain for your serverless Code Engine app

Output of a IBM Cloud Code Engine app

A custom domain, e.g. somethin like myapp.example.com, always puts a nice touch on an app. Often, it is required for corporate identity. Still, not all services offer that capability. As written, I recently migrated some apps from Cloud Foundry to IBM Cloud Code Engine. Right now, Code Engine does not support custom domains out of the box, but I heard that it is planned. Thus, I looked into temporary workarounds for using a custom domain name for my serverless Code Engine apps.

Best practices for successful support cases

Successful support cases

In my day job, I work with latest technology and cloud services. In addition, I work with customers / users and help them succeed. And in my private life, I also use technical equipment. In all three of these scenarios, mostly in the first two, I often create support cases. And I like to get the issues resolved, not just support cases closed. Over the years, I came up with these best practices for successful support cases.

Required IAM privileges for a service ID to update Code Engine app

Remember the steps

This blog post today is one of those written for me. In the past I stated a couple times that I use this blog to remember things. Today, it is about setting up IBM Cloud IAM privileges for a Service ID. That service ID needs to build a new container image, then update an existing Code Engine app.

Blue-green deployment with IBM Cloud Code Engine and Knative

Code Engine app with green revision

From reading my past post on migrating from Cloud Foundry to Code Engine, you probably guessed that I am currently working with IBM Cloud Code Engine. One of the topics I looked into the past few days is advanced configuration of my app using the Knative CLI. Code Engine is using Knative which, again, is based on Kubernetes. All of them are involved in configuring traffic management for my app, so that I could realize blue-green deployment. It allows to gradually move traffic from the current stable to a newer app revision. Not much is needed to get it to work.

From Bluemix to IBM Cloud, from Cloud Foundry to Code Engine

"Bring Your Own Community"

About seven years ago, I started to work with, then blog about Bluemix and Cloud Foundry. Not my first, but one of the first posts is titled "Some fun with Bluemix, Cloud Foundry, Python, JSON and the Weather". Reading that article again I feel nostalgic and it brings back memories of how I learned to deploy my apps to Cloud Foundry. And how I had fun with new cloud technologies.

IDUG EMEA 2022 Tech Conference: Call for presentations open

Submit your Db2 presentation now

This is a rather short (and quick) post. Have you seen that the CfP (Call for Presentations) for the Db2 conference in Scotland scheduled for October is open? The IDUG 2022 EMEA Db2 Tech Conference will be held in Edinburgh, Scotland, from October 22-26 this year (for sure, I promise!). Because IDUG is the International Db2 User Group and hence is organized by users and lives from user participation the conference planning committee is hoping for many submissions by users.

Do you know how to install Db2 or connect to it? Have you successfully retrieved query results, in a program written in Python, Node.js, Cobol, Go or C++? Have you provisioned Db2 on Cloud, pulled the container image with Db2 Warehouse and deployed it? If you answered yes to one of these questions, go ahead and submit a presentation, share your experience!

I expect the CfP to be open until end of April.

If you have feedback, suggestions, or questions about this post, please reach out to me on Twitter (@data_henrik) or LinkedIn.

Get certified for IBM Cloud, new certifications available

This week, I completed another certification, I passed the IBM Cloud Security Engineer exam. It is a natural step when you consider that many of my IBM Cloud blog posts are about security-related topics.

In this blog post, I want to give you a quick overview of IBM Cloud certifications and what it topics are covered for the IBM Cloud Security Engineer certification.

Simple, quick and secure cloud onboarding for workshops and hackathons

Create an external Identity Provider

Short-lived projects like hackathons or workshops often have the following characteristics:

• similar privileges for everyone on the project,
• only few IAM (Identity and Access Management) roles,
• preferred simple administration (setup, running it, cleanup) over tightest security.

Additionally, such projects often are repeated with similar setup, but other participants. So, how do you onboard them efficiently and securely?

With that question in mind, I published two blog posts on the IBM side along with code on GitHub:

• Secure onboarding for your workshops and hackathons and
  
• Bulk creation of users in IBM Cloud App ID.
  

The articles utilize features and services like access groups and trusted profiles, external identity providers based on IBM Cloud App ID. The code is in Terraform and Python for full automation where possible. Enjoy.

If you have feedback, suggestions, or questions about this post, please reach out to me on Twitter (@data_henrik) or LinkedIn.