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 »
July 14, 2010 Uncategorized

Popping the Stored Procedure Cherry

A first experience with creating stored proceedures. Continue reading »
June 16, 2010 Uncategorized

Stagingprop – SQL0803 “oops, you inserted data directly on production”

So I plan to go through some of the stagingprop problems I've seen - especially the more common ones. This is probably the most common of all, especially if the java developers you're working with have not used Commerce and particularly stagingprop before. Continue reading »
June 15, 2010 Uncategorized

Stagingprop – the high-level explanation

So every client I support has issues with stagingprop at some point. The vast majority of them are due to mistakes made in the development process. Many developers do not fully understand what stagingprop does, so here's a general description that might help. Continue reading »
June 7, 2010 Uncategorized

Registry Variables and DB2_WORKLOAD=WC

I was happy to see the new workload registry variable in Commerce 7/DB2 9. Mostly out of laziness – it requires fewer variables to be set manually, but it also ensures that nothing major is missed (I imagine they may come up with more that won’t be added to the workload registry variable in real time).… Read the rest

Continue reading »
June 4, 2010 Uncategorized

I’m just this guy, you know?

I'm just this guy, you know? Ok, so I'm female, but I don't work for IBM and I'm not trying to sell you anything. Continue reading »
June 4, 2010 Uncategorized

Sticky, gluey, GUIs

DB2 GUIs Suck for a variety of reasons - use the command line. Continue reading »
June 3, 2010 Uncategorized

Fun with IN-lists and GENROW

IN-lists are poor performers. Here's what they look like in explain plans and why they perform poorly. Continue reading »
June 3, 2010 Uncategorized

5 things that made me a better DBA

Several times I've figured things out in my career and thought "how did I ever call myself a DBA without knowing that?" Continue reading »
June 2, 2010 Uncategorized

Hello world!

I am at this point an expert on DB2, and on the aspects of DB2 that interact with Commerce, and frequently train clients and new DBAs on how to do what I do, so it's time to share. Continue reading »
June 2, 2010 Uncategorized

Instance Creation in WebSphere Commerce 7 (DB2 9.5)

SQL30082N Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED"). SQLSTATE=08001 Continue reading »

Posts navigation

«Previous Posts 1 … 44 45 46

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