DataGeek.blog

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 »
March 22, 2018 Ember Crooks

Index of Introductory Db2 Topics

This blog entry is designed to serve as a roadmap for current blog entries directed at those newer to Db2. In my mind, this likely includes anyone who has been working with Db2 for less than 2 years. However, often there are areas we spend more time in than others, so I think of these topics also as "spackle" - to fill in gaps for the self-taught. Note that some of the topics below are not links. This is because they're areas I plan to blog about in the future. 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 »