Toad World

Blogs

Craig Mullins
Follow /9 Jan 2017 at 12:30pm / IBM DB2 Blog

The Tao of DB2 - Part 15: Putting it all together!

We rejoin our soon-to-be-retiring DBA and the intern who is tasked with replacing him as the old DBA continues to teach the young intern about Tao and DB2. "Soon, I will be retiring, and all of this will be yours," said the expert DBA. "Are...
218 0 /
Craig Mullins
Follow /22 Dec 2016 at 1:00pm / IBM DB2 Blog

Happy Holidays 2016

It is that time of year again. When we all take some time to pause and spend time with our family, friends and loved ones. We take time off of work to celebrate and reflect on the past year... and to welcome the new year. No matter what holiday tradition...
215 0 /
Craig Mullins
Follow /15 Dec 2016 at 12:00pm / IBM DB2 Blog

The Tao of DB2 - Part 14: A Short Lesson on Wisdom

After a long day of dealing with problems the DBA and his intern were readying themselves to head home for the evening. The mentor glanced over at his trainee and saw that something was troubling him. "You seem to be troubled," noted the DBA...
234 0 /
Craig Mullins
Follow /5 Dec 2016 at 6:06pm / IBM DB2 Blog

The Tao of DB2 - Part 13: Constantly Learning More

It is time, once again, to look in on our intrepid young DBA as he continues to learn database administration as an intern to an older, wiser, but soon-to-be-retiring DBA. The intern approached his mentor and said "You have taught me a lot in the...
293 0 /
Craig Mullins
Follow /15 Nov 2016 at 1:00pm / IBM DB2 Blog

The Tao of DB2 - Part 12: Dealing with Change

It is time to look in on our friends the intern DBA and his mentor, once again. After spending so much time on performance issues, the mentor decides to check in on his apprentice and make sure that he is not overwhelmed. “Well, not that you mention it...
302 0 /
Craig Mullins
Follow /4 Nov 2016 at 4:26pm / IBM DB2 Blog

The Tao of DB2 - Part 11: Calm Inaction: a Difficult Lesson to Learn

The young intern DBA and his mentor were developing training for the new version of DB2 when the intern became distracted by a hubbub just outside their cubicles. "What is going on out there?" asked the intern, out loud, to nobody in particular...
288 0 /
Craig Mullins
Follow /1 Nov 2016 at 7:11pm / IBM DB2 Blog

The Tao of DB2 - Part 10: Dispelling a DB2 Performance Myth

Once again we join our intrepid duo – the seasoned DBA who is a practitioner of Tao and his young apprentice to whom he is trying to teach the way of DB2… “I have to say,” uttered the young intern, “that there sure is a lot to learn about DB2. Especially...
251 0 /
Craig Mullins
Follow /20 Oct 2016 at 7:48pm / IBM DB2 Blog

Using Extended Indicator Variables in DB2 for z/OS

As you all should know by now, version 10 of DB2 for z/OS greatly expands support for indicator variables. Those of you who write programs that must handle results that could be null should know what an indicator variable is. Basically, DB2 represents...
4342 0 /
Craig Mullins
Follow /12 Oct 2016 at 7:30pm / IBM DB2 Blog

The Tao of DB2 - Part 9: The Five R's

The last time we checked in on our experienced DBA and his young intern the lesson was focused on when to REORG. The intern was sent away to learn all about Real Time Stats and RUNSTATS. Let's see how he is progressing... "So, the Real Time Stats...
289 0 /
Craig Mullins
Follow /4 Oct 2016 at 5:10pm / IBM DB2 Blog

The Tao of DB2 - Part 8: REORG and Statistics

When last we looked in on our Taoist DBA and his young mentor they were dealing with performance issues. They were dealing with performance issues as they arose... reactively. The last question the intern had asked his mentor was a good one: "So...
344 0 /