Tuesday, September 15, 2020

Some fun digging into IBM Cloud access policies


On IBM Cloud, I have an account with multiple other users. To organize teamwork, I followed best practices for organizing users, teams, applications and made use of the IBM Cloud IAM (Identity and Access Management) capabilities. 

With users, service IDs, access groups, and access policies in place, I wondered how to get insights into per-user privileges and the scope of service ID permissions. Sure, I could use the IBM Cloud console (UI) or the Command Line Interface (CLI), but why not test the API (Application Programming Interface) for some customized reporting? The script is available on GitHub.

Wednesday, August 26, 2020

Db2 and S3-compatible Cloud Object Storage

A look at Db2 and S3 storage
A look at Db2 and S3 storage

Recently, I was contacted about an old blog post where I discussed how to access Cloud Object Storage from Db2. Since writing that article, both Db2 and (IBM) Cloud Object Storage have evolved. Thus, it is time for an update on how to backup data to cloud storage, load from external storage and even directly query data somewhere in the Internet...

Monday, August 24, 2020

IDUG EMEA 2020 goes virtual, moved to November 16-19

My favorite database conference, the European IDUG (International Db2 User Group) meeting, just announced to go virtual for the IDUG EMEA 2020. The conference was planned to take place in Edinburgh, Scottland, in October. It is going to be held as virtual conference and was moved to November 16-19. Right now, it is planned to have IDUG EMEA 2021 in Edinburgh from October 17-21, 2021. So mark your calendars and keep your fingers crossed.

The recent meeting of the German Db2 User Group, DeDUG, was also a virtual event.

Update (2020-08-25): Seems the communicated dates were not final and I removed them for now.

Update (2020-08-26): Added information on IDUG EMEA 2021 and re-added November dates.

Monday, August 17, 2020

New JWT-based SSO in Db2 11.5


Another security lock for Db2
In my last blog I quickly pointed out the new Db2 11.5 Mod Pack 4. I mentioned that one of the new features is support for JSON Web Tokens (JWT). Today, I want to take a deeper look at this new security feature in Db2. Probably all of you have used JWTs before, maybe not knowingly - but this is going to change...