On December 12th, I’ll be presenting on the DB2 Night Show on HADR and TSAMP Advanced Topics. Sign up here: http://www.dbisoftware.com/db2nightshow/


I work for a company that provides design, build, and support for WebSphere Commerce environments. I’ve worked there since July of 2008, and worked with Commerce databases for about two years before that in a more limited role as a Physical DBA for IBM Global services. I was with IBM for about 7 years, as a Physical DBA for a number of different DB2 databases both internal to IBM and in support of IBM Global Services’ clients.

In my current role, I write most of the DBA scripts that my company uses. I also do a significant number of builds of new environments and support a number of clients with ongoing DB2 support. I spend time working with and training client DBAs of all different skill levels. I’m involved in everything from backup and recovery design and implementation to performance to a dozen other random topics.

I blog on topics related to DB2 and/or to WebSphere Commerce. I try to come up with both the big and the little topics that I wish I had been able to find better information on or that I think might help others. I’m always happy to get comments and suggestions, so if there’s a topic you’re looking for more information on, let me know.

I don’t make much direct money from blogging. February 2012 was the first month where my little ads managed to pay my most basic hosting costs (literally hosting provider costs, not counting domain registration, premium theme, plugin costs, etc).  I find time to blog on my lunch break and in the evenings, and really am enjoying doing it.

On a personal level, I am a mom to two wonderful young boys, and have been happily married since 1999. My husband is also in a technical field, and is a great supporter. I live in Colorado. My hobbies include reading, sewing, bicycling, and skiing. Not long ago, my older son made a fortune-teller(we called them cootie catchers when I was in school), and the final fortune was “You will get 100 hits on your blog”. I wonder if I’ve been talking about blogging too much…

My current goal is to post 2 times a week. I frequently schedule posts ahead of time to make sure of this. My goal is also for at least one of those to be a deeply technical look at something, including syntax and so forth.


In 2013, IBM named me as an IBM champion!

My LinkedIn Profile: http://www.linkedin.com/pub/ember-crooks/8/a9b/25a

My Twitter ID: @ember_crooks

developerWorks Articles

Mining your package cache for problem SQL in DB2 for Linux, UNIX, and Windows

db2Night Show appearances:

January 6th, 2012 – Top 10 tips for e-commerce DB2 databases.
December 14th, 2012 – Back out strategies for DB2 LUW Database Changes

DB2′s Got Talent 2012:

2012 Audition
2012 Finals Round 1: DB2 9.7 Deadlock and Lock Timeout Analysis – The New Method
2012 Finals Round 2: db2caem: The Untold Story

DB2′s Got Talent 2013:

2013 Contestant Search
2013 Finals Round 1: The Fragmentation of DBADM in DB2 9.7
2013 Finals Round 2: Tips for finding problem SQL from the Package Cache
2013 Finals Round 3: Two Different Methods for Altering Data Types
2013 Finals Round 4: DB2 Success: You Won’t Find it on a Database Server