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

IDUG NA Virtual Conference: Day One Complete!

The IDUG Virtual conference kicked off today, and I thought I’d share my excitement and a few observations.

Content

Today

Today was mostly the opening keynote and the spotlight sessions. Recordings of Monday’s sessions will be available on-demand for conference attendees later in the week, so if you haven’t even registered yet, do so and replay them.… Read the rest

Using LDAP for Db2 Authentication in a Docker Container

Db2 is a bit unusual among RDBMSes in that it does not perform authentication. No matter what, you need some external authority to perform authentication. Usually that is either the OS or LDAP, though there are other options. If using LDAP, either transparent LDAP or security plugins can be used.… Read the rest

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

DB2 Administrative SQL Cookbook: List Privileged IDs that do not Have the Connect Authority

Purpose

To list IDs that have one or more privileges, but do not have the CONNECT authority through a direct grant, a group, or a role, either explicitly or implicitly. I used this to find IDs I might need to grant CONNECT to before revoking connect from PUBLIC.… Read the rest

March 1, 2011 Uncategorized

Never do runstats on volatile tables

Ok, so everyone will tell you that it doesn’t matter if you do runstats on volatile tables. The volatile flag is supposed to tell DB2 that the statistics are absolutely not correct, and heavily bias db2 to use indexes over table scans.… Read the rest

February 28, 2011 Uncategorized

DB2 and Transparent LDAP

Ok, so I know I’m in the middle of a multi-part post on Data Movement between Commerce databases (and I will get back to that), but I found this and had to share it because I’m so excited DB2 has finally added support for it.… Read the rest

February 25, 2011 Uncategorized

Data Movement Options for Commerce Databases – Creation of staging database during build

So one of the most common questions I get is about moving data between homogenous Commerce databases. Our standard setup includes 4 environments – Dev, QA, Stage, and Prod. Dev/QA are a stagingprop pair, Stage/Prod are a stagingprop pair, and Prod usually has HADR.… Read the rest

February 17, 2011 Uncategorized

Stagingprop – SQL0803 – a rarer cause

I went through the most common cause of SQL0803 back in a previous post. There’s a rarer cause that can look very similar, and I thought I’d detail it.

What this problem looks like:

The following appears in the stagingprop log.… Read the rest

July 16, 2010 Uncategorized

I tried Data Studio, I really did.

The attempt to like a GUI falls flat again. 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

June 4, 2010 Uncategorized

DataGeek.blog

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

IDUG NA Virtual Conference: Day One Complete!

Content

Today

IDUG NA Tech Conference is 1/10th of Normal Cost, and Online!

Using LDAP for Db2 Authentication in a Docker Container

Update on Ember’s Data Science Journey – June 2020

Recap

Disappearing Data in PostgreSQL

Free Digital Education Opportunity: IBM User Group Days!

What is IBM User Group Days?

DB2 Administrative SQL Cookbook: List Privileged IDs that do not Have the Connect Authority

Purpose

Never do runstats on volatile tables

DB2 and Transparent LDAP

Data Movement Options for Commerce Databases – Creation of staging database during build

Stagingprop – SQL0803 – a rarer cause

What this problem looks like:

I tried Data Studio, I really did.

Popping the Stored Procedure Cherry

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

Stagingprop – the high-level explanation

Registry Variables and DB2_WORKLOAD=WC

I’m just this guy, you know?

Sticky, gluey, GUIs

Fun with IN-lists and GENROW