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 29, 2019 Uncategorized

IBM Moves RFE Process to Aha Platform

I’ve long been both a proponent and a critic of IBM’s RFE(Request For Enhancement) program. For a several years, it was clear that RFEs just went into a black hole. Then, several years ago, IBM started actually paying attention and implementing them. There have been a number of them implemented to date – a couple that come to mind are the un-deprecation of db2_install and the creation of PDF manuals. Continue reading »

January 22, 2019 Uncategorized

What you Need to Do to Support a Db2 Environment

Many of the posts I write focus on either how to do or approach something or a story about something I did. Instead of the How, this post focuses on the What. If you’re new to Db2, you may not even be aware of what you should do to support a Db2 environment in a proactive manner. And by “New to Db2”, I also include those with up to three years of Db2-only experience who are self-taught. Continue reading »

January 15, 2019 Uncategorized

Db2’s Alternate Page Cleaning

The first professional technical presentation I ever gave was on March 31, 2003. I had been a DBA for just less than 2 years. It was at an event called “SDC West Geek Fest”. It was an internal IBM event within Global Services where the technical folks delivering services got together to share technical expertise. The title was something along the lines of “10 ways to improve physical performance in Db2”. This was just after version 8.1 was released. The top three on my 10-item list were Continue reading »

January 10, 2019 Uncategorized

Update on Ember’s Data Science Journey – January 10, 2019

Well, I knew it was going to be slow, and that is part of why my plan is a 20-year plan instead of just a short-term plan. The fall was particularly difficult due to a couple of issues at work and two conferences that I absolutely loved, but that took time away from the already 60-hour work weeks that I needed to be putting in.… Read the rest

December 13, 2018 Uncategorized

The Autumn That Nearly Drowned Me

For more than 5 years I’ve managed to average at least one blog entry a week through fluctuating workloads and even through changing employers. And then came this autumn. The combination of a couple of large clients and going into holiday peak period for a couple of retail clients, collided with the IDUG EMEA conference where I was presenting two new sessions nearly combined to do me in.… Read the rest

August 16, 2018 Uncategorized

Using TSA/db2haicu to Automate Failover Part 5: Additional Configuration Best Practices

IBM has published a document with some additional best practices for configuring TSAMP, so I thought I would add an article to my TSA series covering these settings. My TSAMP series is what I am most often recognized for, I think, and one that I most often refer people to. Check out some of my past articles here: https://datageek.blog/?s=TSA Continue reading »

August 9, 2018 Uncategorized

Hello, Db2 World! PowerShell

I have published several articles on PowerShell. But the “Hello, Db2 World!” series is designed to be a quick and fairly simple way of properly connecting to a Db2 database. Check out the GitHub repository folder for this blog entry.

Db2 Drivers

Note that before starting, you should have a Db2 Client installed on the server you wish to connect from.… Read the rest

July 31, 2018 Uncategorized

Update on Ember’s Data Science Journey – August 1st, 2018

One of the struggles for any well-employed person is to find time for further training and educating themselves. Thus I find that I make a lot of progress toward my data science learning goals on airplanes and from airports. … Read the rest

July 17, 2018 Uncategorized

The Db2 Recovery History File

Critical to recovering a database, but largely invisible, it is a good idea to understand the recovery history file, what it contains, and how to access it.

What is the Recovery History File?

The recovery history file is one of the many files associated with a database, but it is one of the most important.… Read the rest

June 21, 2018 Uncategorized

Hello, Db2 World! – How to Connect to a Db2 (LUW) Database

Connecting to a database is required before most actions can be taken on the database. A Db2 connection is made at the database level, and not at the instance or server level. This entry focuses on how to establish a connection to work with a Db2 database.… Read the rest

June 12, 2018 Uncategorized

What do I Think Data Science is?

This is one of those blog entries that I write and I know it will be obsolete and I will show my own ignorance and cringe at it in five years, but I have to write it anyway. I know that Iam biased.… Read the rest

June 7, 2018 Uncategorized

The db2support Problem with Db2 11.1, Fix Pack 3 (LUW)

IBM released fix pack 3, mod pack 3 for Db2 11.1 earlier this year, and there was a high-severity problem in the initial version of that fix pack. IBM fixed the problem and re-released the fix pack within about a day, but the bug was reported far and wide, while I’m not sure the resolution of the bug was, so I thought I’d cover it quickly.… Read the rest