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

Posts:

Locks – Timeout vs. Deadlock

So questions in this area most often come from DBAs from other RDBMS’s or from developers. I’ll probably write other posts on locks, but here are the basics on deadlocks vs. timeouts.

Why we get them confused at all

Ah the wisdom that went into grouping these under a single error code with different return/reason codes.… Read the rest

Continue reading »

Managing db2 transaction log files

Logging method

There are two methods of logging that DB2 supports: Circular and Archive. I believe Oracle has similar modes.

Circular

To my extreme disgust, the default that Commerce uses if you don’t change anything is Circular logging. Circular logging is more often appropriate for databases where you don’t care about the data (seen it for databases supporting Tivoli and other vendors) or for a Data Warehousing and Decision Support databases where you have extremely well defined data loading processes that can easily be re-done on demand.… Read the rest

Continue reading »

Commerce 7.0 Build: IBM DB2 Universal Database may not be installed

This was a new one to me, and it took some time of some top level experts to find the tech note on it, so I thought I’d post it here so others can hopefully find it more easily.

The scenario was a new install of Commerce with experienced client DBAs doing the DB2 install, instance creation, and database creation, including installing the DB2 client on the app servers (3 tier environment).… Read the rest

Continue reading »

DB2 vs. Oracle – handling dates

So as I may have mentioned before, I’m learning Oracle. I’ve always been a DB2 DBA, having started out as strictly a Physical/Systems DBA. Thus SQL is a skill I’ve built very slowly, over time. I thought the hardest test for DB2 certification was the ‘Family Fundamentals’ one, because it focused so heavily on SQL and other things I didn’t do day-in and day-out at the time.… Read the rest

Continue reading »

How to completely stop DB2

On Linux and Unix anyway. This is actually a common request during build when OS-level patches are applied or other OS-level work needs to be done, especially any related to disks.

Stop Commerce (and/or any other applications)

I’m not going to go into detail on this one – it is not my area of expertise.… Read the rest

Continue reading »