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…
4 Tech Innovations That Could Change Smartphones
Smartphones have gotten so advanced today that it can almost be hard to tell the difference between the top options.…
A Case Study: Measuring the Impact of Db2 for z/OS Buffer Pool Changes
Not long ago, a Db2 for z/OS administrator contacted me with a request. His team had made some changes to…
Db2 12 In-Memory Feature: Fast Index Traversal
Db2 12 is classified as an in-memory data base by Gartner. It is not just a simple in-memory data base…