Skip to content

DataGeek.blog

Db2 Experts on a Data Science Quest

Search
  • Home
  • About
  • Bloggers
  • Privacy Policy
  • Ask Ember A Question
  • Donate
  • English
  • EspaƱol
  • June 16, 2022 Michael Krafick

    Rollback Statements and the IBM Sterling Order Management System

    There have been a few times in my career where I have been stunned by something I have seen while at work.

    Sometimes it was the good type of stunned. Like the first time first time I observed a truly obnoxiously large workload hit my production database and the database still performed like a champ.… Read the rest

    Continue reading »
  • June 9, 2022 Ember Crooks

    My Early Experience Learning MySQL as a Db2 DBA

    I’m a couple of months into working with MySQL, and thought I’d share some resources and thoughts on what I’m learning and what is working. At least half of that time was dedicated to a very in-depth onboarding process that barely mentioned a database at all in about a month of content, so it’s closer to a month in.… Read the rest

    Continue reading »
  • March 17, 2022 Ember Crooks

    When an Index is More Than an Index: Clustered Indexes

    Many RDBMSes have similar structures and concepts. In this post, I’m going to compare and contrast IBM Db2’s concept of a clustered index and MySQL’s concept of a clustered index.

    Index vs. Clustered Index

    An index is generally a way of organizing data in a way that it will be quicker to access than scanning through all of a table.… Read the rest

    Continue reading »
  • March 11, 2022 Ember Crooks

    A New Turn in Ember’s Career

    I’ve struggled to write this blog entry to appropriately convey all aspects of what I want to say. This is my third attempt, and I finally think it does things justice.

    As part of my publicly shared data science journey, I’ve continued to read job postings, even while reasonably satisfied with my current job.… Read the rest

    Continue reading »
  • March 9, 2022 Ember Crooks

    Db2u on Native Kubernetes!!

    Db2u is here as a technical preview! I’ll cover the basics of how to set it up for a local sandbox, and leave the details and whys to future articles. IBM has stated that db2u will be available in GA later this year on Amazon EKS and Azure EKS, but meanwhile, I’ve got the technical preview up and running on my MacBook Pro!… Read the rest

    Continue reading »
  • December 21, 2021 Ember Crooks

    Advent of Code 2021 in Db2 LUW SQL – Day 03!

    Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 3. It’s posting on December 21.… Read the rest

    Continue reading »
  • December 17, 2021 Ember Crooks

    db2u Without RedHat OpenShift – A Container-Native Database!

    Earlier in 2021, I wrote an article on the big mistake I thought IBM was making by only offering their container-native version of Db2 (db2u) on RedHat OpenShift.

    Well, that article and tirelessly asking questions of EVERY IBMer I could get to listen to me (seriously, I could hear eyes rolling when I asked for the umpteenth time) has finally worked!… Read the rest

    Continue reading »
  • December 2, 2021 Ember Crooks

    Advent of Code 2021 in Db2 LUW SQL – Day 01!

    Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 1.

    AOC Day 1
    My day 1 solutions are available in my GitHub repo.… Read the rest

    Continue reading »
June 16, 2022 Featured

Rollback Statements and the IBM Sterling Order Management System

There have been a few times in my career where I have been stunned by something I have seen while at work.

Sometimes it was the good type of stunned. Like the first time first time I observed a truly obnoxiously large workload hit my production database and the database still performed like a champ.… Read the rest

Continue reading »
June 9, 2022 Featured

My Early Experience Learning MySQL as a Db2 DBA

I’m a couple of months into working with MySQL, and thought I’d share some resources and thoughts on what I’m learning and what is working. At least half of that time was dedicated to a very in-depth onboarding process that barely mentioned a database at all in about a month of content, so it’s closer to a month in.… Read the rest

Continue reading »
March 17, 2022 Featured

When an Index is More Than an Index: Clustered Indexes

Many RDBMSes have similar structures and concepts. In this post, I’m going to compare and contrast IBM Db2’s concept of a clustered index and MySQL’s concept of a clustered index.

Index vs. Clustered Index

An index is generally a way of organizing data in a way that it will be quicker to access than scanning through all of a table.… Read the rest

Continue reading »
March 11, 2022 Featured

A New Turn in Ember’s Career

I’ve struggled to write this blog entry to appropriately convey all aspects of what I want to say. This is my third attempt, and I finally think it does things justice.

As part of my publicly shared data science journey, I’ve continued to read job postings, even while reasonably satisfied with my current job.… Read the rest

Continue reading »
March 9, 2022 Featured

Db2u on Native Kubernetes!!

Db2u is here as a technical preview! I’ll cover the basics of how to set it up for a local sandbox, and leave the details and whys to future articles. IBM has stated that db2u will be available in GA later this year on Amazon EKS and Azure EKS, but meanwhile, I’ve got the technical preview up and running on my MacBook Pro!… Read the rest

Continue reading »
February 1, 2022 Advent of Code / AOC2021

Advent of Code 2021 in Db2 LUW SQL – Day 04!

Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 4. It’s posting on February 1.… Read the rest

Continue reading »
December 21, 2021 Advent of Code / AOC2021 / Featured

Advent of Code 2021 in Db2 LUW SQL – Day 03!

Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 3. It’s posting on December 21.… Read the rest

Continue reading »
December 17, 2021 Featured

db2u Without RedHat OpenShift – A Container-Native Database!

Earlier in 2021, I wrote an article on the big mistake I thought IBM was making by only offering their container-native version of Db2 (db2u) on RedHat OpenShift.

Well, that article and tirelessly asking questions of EVERY IBMer I could get to listen to me (seriously, I could hear eyes rolling when I asked for the umpteenth time) has finally worked!… Read the rest

Continue reading »
December 3, 2021 Advent of Code / AOC2021

Advent of Code 2021 in Db2 LUW SQL – Day 02!

Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 2.

AOC Day 2
My day 2 solutions are available in my GitHub repo.… Read the rest

Continue reading »
December 2, 2021 Advent of Code / AOC2021 / Featured

Advent of Code 2021 in Db2 LUW SQL – Day 01!

Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 1.

AOC Day 1
My day 1 solutions are available in my GitHub repo.… Read the rest

Continue reading »
December 2, 2021 Advent of Code / AOC2021 / Featured

Advent of Code 2021 in Db2 LUW SQL

This year, I’m going to be working through the Advent of Code challenges in SQL and sharing my progress here on the blog. I don’t expect to complete each challenge and the blog entries on them on the same day they are released – I’m not competing on time, I’m just using this to share SQL techniques.… Read the rest

Continue reading »
September 7, 2021 Featured

Db2 Basics: Buffer Pools

What is a Buffer Pool?

A buffer pool is one of the most critical memory areas for a Db2 database. Buffer pools are used to cache data in a way that the data can be reused by other connections. They do not store the results of Query A and Query B, but they store the data pages used to produce those results.… Read the rest

Continue reading »

Posts navigation

1 2 3 … 48 Next Posts»

Search

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy
 

Loading Comments...