Today we are going to talk about some random DB2 features that can’t stand in a blog of their own, but are worth discussing nonetheless. These are tidbits I had discovered during “DB2’s Got Talent” presentations, IDUG conferences, or “Hey, look what I discovered” moments.
One of the most frustrating things a DBA can experience is troubleshooting due to bad data. The client is upset because rows are missing or incorrect data is returned. The client facing web front end could be displaying gobilty-gook because the data retrieved makes no sense. Resources and energy are burned because of an issue is easily solved with the proper use of constraints.
Sometimes you just have to think out of the box. Sometimes there isn’t an answer on google. Sometimes you have to bend the laws of physics to get the answer. Sometimes you get lucky.
Are you ready yet? Have you started to throttle your work for the week, arrange a backup, even packed a bag? The 2014 IDUG Technical Conference is only a week away.
I’ve been encouraged by a few to tell my story. How I was encouraged into DB2’s Got Talent 2014, what it was like, decisions I made on the fly, any advice, and what I learned from my experience. To tell you how I won, I have to go back and tell you of the friendship I have developed with Ember and what seemed to be a harmless conversation in January of this year.
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.
This article is based off the “DB2 v10.1 – Row and Column Access Control (Column Masking)” presentation for the DB2 Night Show (Episode #128) – DB2’s Got Talent competition held on Friday, March 7th at 11am EST. Progression within the competition is based solely on audience voting. So if you found this useful, want to see more like this, and don’t want to see a grown man cry – please vote for Mike Krafick based on the article or on the DB2 Night Show replay. You will have one week from the original air date to vote.
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.