Author Details
Certifications and Badges
Twitter

Lead Database Administrator

Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 18 years developing a top-level expertise on Db2 for mid-range servers and more than 7 years blogging about it, Ember is hungry for new challenges and looks to expand her skill set to the Data Engineering role for Data Science. With in-depth SQL and RDBMS knowledge, Ember shares both posts about her core skill set and her journey into Data Science. Ember lives in Denver and work from home

My Tweets

Posts:

January 2, 2020 Featured

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

December 17, 2019 Uncategorized

Practice Good Documentation

Having worked on teams of Db2 DBAs, largely in consulting roles, the value of good documentation is huge. This is once again clear to me as I start a position with a new company. The documentation here happens to be excellent and it makes getting a new person (me!)… Read the rest

December 10, 2019 Uncategorized

Db2 Basics: IBM IDs – How to Sign Up for One

IBM IDs are completely, 100% free. You pay with a bit of your personal information. You have to provide an email address and a first and last name.

Purpose

Those of us who have been working with (or for) IBM for years, really don’t even remember signing up because it is just a minor thing.… Read the rest

December 5, 2019 Uncategorized

DataGeek to Start Offering Some Spanish Language Translations

Welcome readers! I have a friend who has offered to provide Spanish language translations of some blog entries. The list of entries to work through is long, so if you have any articles you’d particularly like to see in Spanish, please comment with them so we can add them to his list.… Read the rest

November 19, 2019 Featured

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

October 22, 2019 Uncategorized

Ember Changing Jobs

I have left XTIVIA. This is nothing against XTIVIA or the wonderful people there, it’s just an evolution on what I want to do.

5 years ago, when I started at XTIVIA, it was the perfect place for me at that time.… Read the rest

October 2, 2019 Uncategorized

DB2 Administrative SQL Cookbook: Finding Statements in the Package Cache using a lot of Temporary Space

To Continue reading »

September 5, 2019 Uncategorized

Ember Speaking at Midwest Users Groups Meetings September 10 and 11

One of the things I most enjoy in my career is speaking – whether it is at conferences or for Users Groups. I’ll be speaking at Users Groups in St. Louis and Milwaukee September 10 and 11.

Also speaking will be one of my favorite speakers – Pavel Sustr.… Read the rest

July 3, 2019 Featured

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

June 11, 2019 Uncategorized

Wrap-Up: IDUG Db2 North American Technical Conference in Charlotte

The IDUG Conference in Charlotte this year was one of the best-run North American Conferences I have been to. They rose close to the high standard that the IDUG European conference committee sets. I had fewer issues with how things ran.… Read the rest

Posts:

Purpose

Scenario