Articles & Content

Henrik Loeser: Thoughts on IT, Life, DB2, and More

IT Professional (IBM), Information Management Architect / DB2 pureXML / Database Kernel Developer, spent 7 years living in California (Bay Area), now back in Germany, living in a passive house in Friedrichshafen

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

 

 
New performance and security feature in Db2: Authentication cacheNew security feature in Db2The recent release of Db2 11.5.3 (Db2V11.5Mod Pack 3) includes a small gem that impacts both performance and security. It is a cache for User ID and Password-based authentication. That feature is great when your system uses LDAP / Active Directory for authentication becaus…
Use Chromium-based browsers to manage FIDO security keysAdd fingerprint to FIDO keyRecently, I made a discovery that simplified how I manage my FIDO security keys. Instead of using a vendor tool to set a PIN or add fingerprints, I now switched to utilizing a Chrome- / Chromium-based browser for the administration. This works well on my Linux box. In this…
Some advanced SQL to analyze COVID-19 dataLearn to write SQLAll of us are impacted by COVID-19. Looking at daily case numbers, the basic reproduction number or mortality rates has become a routine. But what is behind those numbers? How are they computed and how does SQL help? In this post, I want to discuss how some SQL analytics clauses he…
IBM Watson Studio: Download pandas DataFrame as CSV or Excel fileGist code snippetRight now, I am working with IBM Watson Studio on some analytics side project. It is nice to work with Jupyter Notebooks, Python and pandas and data again. Even Db2 is involved.From working with pandas DataFrames locally, I knew how to turn the data into CSV or Excel files. But work…
All the best combined: Cloud, Db2, Python, Serverless and SecurityAdd a cloud service ID as Db2 userEarlier this year, I wrote about how to use an API key or access token to connect to Db2 (on Cloud). Today, I am going to show you how to set up a service ID (technical user) on IBM Cloud, assign it a Db2 user ID (see screenshot) and grant database privileges. There…
Home office and rubber duck debugging, 5 levelsRubber duck debugging at homeRecently, I shared with you my best practices for working from home. Today, I want to add an angle specific to technical jobs, especially for developers. When you work in co-located teams, you benefit from the direct conversations and exchange. In (software) development …
Key Protect as vault for multi-cloud setupGuard credentials in a vaultIn my previous blog post, I showed how you can easily encode and upload credentials to IBM Cloud Key Protect. Today, I am going to share sample code with you for retrieving the credentials and turning them back into a JSON object. A common use case is a multi-cloud enviro…
Encode credentials and upload to Key ProtectProtect credentials in Key ProtectIf you followed my blog or have used IBM Cloud, then you know that Key Protect (and Hyper Protect Crypto Services) is the solution to manage encryption keys on IBM Cloud. Did you know that you can import your own keys? And did you know that "key" can be (almost) any…
Use an API KEY or ACCESS TOKEN to connect to Db2 on IBM CloudIn the past, I have blogged about how to access a Db2 database on IBM Cloud from your local machine. I cataloged the cloud host and its database. Then, connected to it using the command line processor (CLP) by passing a username and password. Last year, I was delighted to read that Db2 on Cloud and …
Covid19 phone challenge: My old Nokia has Android nowMy reliable Nokia phoneDuring these nasty times, you need a steady, reliable companion. It is my old Nokia phone (pictured). It takes phone calls, has an alarm and the current time. Moreover, it serves as projectile against all kinds of "obstacles". The only things missing are Db2 and a Linux termin…