This article is based off the “Boost Your Speed – Index Read Efficiency” presentation for the DB2 Night Show (Episode #129) – DB2’s Got Talent competition held on Friday, March 14th at 11am EST. Progression within the competition is based solely on audience voting. If you found this useful, want to see more like this, and don’t want to see a grown man cry – please vote for Michael Krafick (and Mariana Sanchez) based on the article or on the DB2 Night Show Replay. You will have one week from the original air date to vote.
We interrupt your regular programming for a quick announcement.
I am late to the party on Automatic Storage. Yes, it has been out for a while, but I have not used it in depth. Coming from a complex data warehouse environment, only vendors and tools used automatic storage. It was quick, easy to set up, and required minimum DBA involvement. Being a container snob and aficionado, I needed the flexibility and speed of DMS.
One of the highlights of 2013 for me was winning third place in the DB2’s Got Talent competition. If you’re a long time reader, you may remember me begging for votes the last two years in March. But this contest is for those who are newer to presenting about DB2 topics in the larger DB2 community, so I’m done – I no longer qualify. So don’t worry about me begging you for votes on my behalf! I may make requests for some friends depending on who ends up competing this year.
A friend recently asked me what I thought of certification. I have a number of DB2 related certifications, and even one Oracle certification. I thought I would share my opinions.
I don't want to blog too much about the conference because I know that when my favorite bloggers talk about conferences I did not get to go to, it just feels like they are mocking me. I tweeted a lot instead (@ember_crooks), and am keeping the blog entries down to a minimum.
I’m a big fan of the IDUG conferences, so have generally focused my funding and management-convincing on getting to go to the IDUG North American Technical Conference. But now that I’m starting to present at IDUG conferences, I want to consider presenting at IOD as well. But I have never even been to this conference. I’ve been to all or part of several IDUG conferences since 2005.
I am a DBA. No matter what title my company gives me, my primary job is designing, engineering, and supporting DB2 databases. DBAs sometimes have a bad reputation. I was a bit surprised the first time my engineering colleagues told me how lucky we were to have such great involved DBAs. Don’t get me wrong – I know I am good at my job, but the part that surprises me is the general negative reputation that DBAs sometimes have.
My goal with this series is to provide some tips and tricks you might not be aware of for finding information in the IBM DB2 Information Center.
Twitter debates. I’ve never been in one, nor have I actually heard of them until yesterday. But when @DB2Geek hosted a debate on Tuesday, I decided to pop on and see what it was all about. (Search for hashtag #db2debate).