DataGeek.blog

September 3, 2020 Luke Numrych

What does SNAP_GET_DBM return in the COMM_PRIVATE_MEM element

I have been recently tasked with creation of an early warning solution for a memory condition from which some of our DB2 databases have been occasionally suffering. Once the condition is encountered, the only resolution is to restart the instance which can cause an impact.… 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 »
July 20, 2020 Ember Crooks

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
Continue reading »
July 16, 2020 Ember Crooks

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

If you’ve read the blog for a while, you realize I’m a big fan of the IDUG conferences. I’ve gone to the North American one every year for the better part of a decade now, and the European one for several years.… Read the rest
Continue reading »
July 14, 2020 Ember Crooks

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
Continue reading »
June 24, 2020 Ember Crooks

Update on Ember’s Data Science Journey – June 2020

It has been a while since I wrote one of these, and it’s about time!

Recap

In June of 2018, I set a new goal for myself.

Long-term goal (by 2035): Work on data science in a way that makes the world a better place.
… 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 »
May 15, 2020 Ember Crooks

Free Digital Education Opportunity: IBM User Group Days!

What is IBM User Group Days?

On May 19 and 20, IBM is hosting several tracks of great sessions. Some of these come out of content that would have happened at THINK, and others are collaborations with the user groups from various technologies.… Read the rest
Continue reading »
March 10, 2020 Ember Crooks

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
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 »

Content

Today

Recap

What is IBM User Group Days?

Purpose