DataGeek.blog

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 »
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 28, 2020 Ember Crooks

How do I Install SQL?

I have seen the question several times on various groups or forums – “How do I install SQL?”. From a DBA standpoint, this isn’t even a properly formed question. From a developer learning standpoint the question makes sense. I needed Python, I went and downloaded Anaconda.… Read the rest
Continue reading »
January 21, 2020 Ember Crooks

SQL+RDBMS Basics: What is a Commit?

This post is cross-platform and applies to all RDBMSes.

It is interesting to see, as a person experienced with a technical tool, some of the disadvantages of the newer ways of learning technical topics. When I started in IT, you learned some of the concepts in college, you learned some things working on the job with other DBAs who knew what they were doing, and you filled in the gaps by going to week-long classes once a year to get some detailed and hands-on official training.… 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 »
November 19, 2019 Ember Crooks

Troubleshooting SQL0803N

SQL0803N is an error message that means the SQL statement just issued failed due to violating a unique constraint within the database. The ‘N’ at the end of this error means that this statement failed and was not executed, but that it is probably not a database system issue.… Read the rest
Continue reading »
July 3, 2019 Ember Crooks

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 Ember Crooks

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

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

Purpose

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

Introduction

How do I Install SQL?

SQL+RDBMS Basics: What is a Commit?

Packaging and Licensing of Db2 for LUW – Version 11.5

Troubleshooting SQL0803N

Why dsmtop isn’t Even Half as Good as db2top

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

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

5 things that made me a better DBA

Hello world!

Instance Creation in WebSphere Commerce 7 (DB2 9.5)