Where do Db2 Containers Come From and How are they Used
In my last post, I wrote an overview of running Db2 in containers. Today, I’d like to talk a bit…
The Developer-DB Love-Hate Relationship
There’s a reason why database administration or engineering remains a separate specialty. There are a large number of rabbit holes…
Accelerating Your Db2 Database
Your Db2 database The IBM mainframe and its Db2 database is the transaction processing workhorse for the world’s biggest banks,…
Db2 for z/OS EXPLAIN: What an Access Path Is, and What it Would Be
The EXPLAIN functionality of Db2 for z/OS, by which the query optimizer’s access path determinations are externalized, has been around…
Db2 12 for z/OS Buffer Pools – Recommendations for PGSTEAL, PGFIX and FRAMESIZE
Not too long ago, I received a note from the leader of a Db2 for z/OS database administration team, asking…
Removing Duplicates From a List in Elixir
Thanks to the Enum module, in Elixir we can trivially remove duplicates from a list. In the following example, we…
Developing with Elixir/OTP Course Review
Ruby was the first programming language I truly fell in love with. Yes, I had used several others before (and…
Sorting Results by Specific Values in SQL with CASE
Recently I rewrote the backend for my service, Any New Books, due to an Amazon API change. Generally speaking, rewriting…