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
  • March 11, 2021 Ember Crooks

    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 you can go down. I’m well aware that there’s probably 40% of Db2 LUW alone that I don’t know, even though I’ve spent 20 years working with it, and am an internationally recognized expert.… Read the rest

    Continue reading »
  • February 9, 2021 Ember Crooks

    It Matters Where Your Join Clauses Go

    Explicit Join vs. Implicit Join

    When writing SQL there are two places you can define how tables are joined. The first is explicit, and is specified after the the keyword ON in the join clause like this:

    
    SELECT * 
    FROM table_a as a
        JOIN table_b as b ON a.id=b.id
    … Read the rest Continue reading »
  • November 19, 2020 Ember Crooks

    Overview of Real-Time Monitoring Options For Db2

    I thought I’d share an overview of the real-time monitoring options for Db2 (LUW). This article focuses on comparing the options, with links to deeper information on each tool.

    Types of Monitoring

    First a quick overview of the types of monitoring that every DBA should be doing.… Read the rest

    Continue reading »
  • November 10, 2020 Ember Crooks

    My Journey through Beginner Data Science Content

    When I first started learning about data science, the amount of material out there was daunting. It is hard to find your way in what you should learn and how you should learn. I thought I’d share what has been working for me and what didn’t.… Read the rest

    Continue reading »
  • July 22, 2020 Ember Crooks

    First Look – The New Replacement for db2top and dsmtop – dmctop!

    One topic that comes up at most panels, Technical Advisory Board meetings and other longer interactions I participate with for IBM is DBA’s love of db2top. It is such an easy tool, and one that most DBAs I know choose over all others for real-time monitoring and basic investigation of a database.… Read the rest

    Continue reading »
  • June 17, 2020 Jonathan Gnagy

    Disappearing Data in PostgreSQL

    I recently discovered an interesting (and frustrating) issue while running PostgreSQL in Kubernetes. While the issue technically isn’t specific to Kubernetes, per se, it is certainly easy to encounter in Kubernetes for users of the official PostgreSQL Docker image (and many other images) mounting volumes somewhere other than the default location.… Read the rest

    Continue reading »
  • February 26, 2020 Suresh Sane

    A Single Source of Truth – Even More Elusive in the Cloud Era?

    Introduction

    I would like to begin by thanking Ember for allowing me to be a guest blogger and explaining the motivation behind writing this blog.

    The “need for speed” in today’s world has led to a sweeping reform where old ideas are discarded too rapidly.… Read the rest

    Continue reading »
  • January 2, 2020 Ember Crooks

    Packaging and Licensing of Db2 for LUW – Version 11.5

    Edit 2020-01-02: corrected limit for free Db2 on Cloud to the correct 200 MB. Original text is still in the document, in strikeout.

    This is one of the few blog entries where I include the Db2 version number right in the title.… Read the rest

    Continue reading »
October 22, 2019 Uncategorized

Ember Changing Jobs

I have left XTIVIA. This is nothing against XTIVIA or the wonderful people there, it’s just an evolution on what I want to do.

5 years ago, when I started at XTIVIA, it was the perfect place for me at that time.… Read the rest

Continue reading »
October 2, 2019 Uncategorized

DB2 Administrative SQL Cookbook: Finding Statements in the Package Cache using a lot of Temporary Space

To Continue reading »
September 5, 2019 Uncategorized

Ember Speaking at Midwest Users Groups Meetings September 10 and 11

One of the things I most enjoy in my career is speaking – whether it is at conferences or for Users Groups. I’ll be speaking at Users Groups in St. Louis and Milwaukee September 10 and 11.

Also speaking will be one of my favorite speakers – Pavel Sustr.… Read the rest

Continue reading »
July 3, 2019 Uncategorized

Why dsmtop isn’t Even Half as Good as db2top

I think I’m beginning to better understand why IBM is not fond of tools like db2top. The truth is that the developers really only get exposure to the largest Db2 clients. These are the ones that really pay the developer’s salaries, after all.… Read the rest

Continue reading »
June 20, 2019 Featured

The DBA is Dead? No, the DBA as Gatekeeper is Dead!

I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client. With 3 whole months of experience and a shiny college degree.… Read the rest

Continue reading »
June 19, 2019 Uncategorized

Working with Db2 copies …on Windows

How to investigate Db2 copies installed on a Windows system

According to one of the definitions from the UrbanDictionary, adding the words “in bed” to any sentence can make that sentence “more interesting”. I like to think that the Db2 LUW world equivalent of that is taking a task – such as working with Db2 copies – and adding words “…on Windows”.… Read the rest

Continue reading »
June 11, 2019 Uncategorized

Wrap-Up: IDUG Db2 North American Technical Conference in Charlotte

The IDUG Conference in Charlotte this year was one of the best-run North American Conferences I have been to. They rose close to the high standard that the IDUG European conference committee sets. I had fewer issues with how things ran.… Read the rest

Continue reading »
May 23, 2019 Uncategorized

IDUG NA Technical Conference in Charlotte, NC – June 2019

This is my regular pre-conference blog entry. I write these every year to share details about the conference and to share my excitement for this form of education and networking. The IDUG conferences in the US and Europe are my favorite weeks of the year.… Read the rest

Continue reading »
April 30, 2019 Uncategorized

Db2 Basics: Setting up a Command Line to Work with Db2

I’m a command line gal, and probably always will be. I doubt a GUI will tempt me away from the command line, though I do find myself enjoying using things like Jupyter Notebook to also access the databases I support.

Does Your Database Know Who You Are?

… Read the rest Continue reading »
April 24, 2019 Uncategorized

Interesting Issue with /tmp on a Db2 Server

I learn something new every day. The times I’m most surprised about what I learn is when it happens to be something pretty fundamental about how Db2 uses resources.

Environment

This situation happened on an AIX environment I’m mentoring someone to build.… Read the rest

Continue reading »
March 26, 2019 Uncategorized

DB2 Basics: Beyond Just Taking a Backup – Backup Performance, Utilities, and More!

While I’ve covered this topic in detail, and blogged about a specific backup performance problem, I’ve never talked about this at the basics level.

What is a Backup?

A backup is a binary image of the entire Db2 database.… Read the rest

Continue reading »
March 19, 2019 Uncategorized

SQL Differences Between Db2 and Informix

I have been working with Informix from a user perspective recently. I learned about some of the SQL differences and developed a greater empathy for developers in the process. CTE Support is covered, along with comparing the date and time handling syntax. Continue reading »

Posts navigation

«Previous Posts 1 2 3 4 5 … 46 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