Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #118: 17 Laws of building very large databases!

November 1, 2013, 12:12 pm
Posted by Scott in DB2 LUW
Lee Goddard
Tabasco is hot! And so is this show!

Special Guest: Lee Goddard, Chief Performance Architect, DBI Software

17 Laws of building Petabyte Level DB and Big Data Systems

96% of our studio audience learned something! During this episode of The DB2Night Show™, Lee Goddard shared invaluable insights on the laws of very large databases! Odds are very high you are going to learn something helpful! Watch and learn...

A message from our sponsor:
DBI Software

Today's "DBI Commercial" was very educational, so don't fast forward through it! Previously on The DB2Night Show and at IDUG conferences (Orlando, Melbourne, and Barcelona 2013), Scott Hayes has presented on DB2 10.1 and the new Index Jump Scans. During our commercial, we compared the performance of DB2 V9.7 versus DB2 10.1 FP3 in a high volume OLTP e-commerce environment. A number of SQL statements in the 4,600+ statement workload benefited from Index Jump Scans. Pay attention! You'll see reduced Index Logical Read costs, lower CPU, and some faster response times.

Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!

Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.

Show Host Scott Hayes Commentary

I think this was a fun and informative show. While it wasn't full of SQL and DB2 commands, you will find "the big picture" insights on large databases invaluable. Lee Goddard, formerly with IBM and now with DBI, shares years of experiences and sage wisdom in his presentation "17 Laws".

At IDUG Barcelona, during the DB2 Experts panel, someone in the room asked intriguing questions about what tools people used. When asked "Who uses db2pd?" all of the hands went up. When asked "Who uses db2top?" all of the hands went up. When asked "Who uses Data Studio for database administration?" no one raised their hand. With as much as IBM has invested in Data Studio, I thought this was surprising and unexpected, so we asked today's studio audience what tools they use. Here are the results:

"Free" DB2 tools used by the DB2 Community

Free DB2 Tools Usage, db2pd 67%, db2top 58%, Data Studio 42%, db2mon 13%, IBM OPM 0%

Perhaps Data Studio is a little more popular in North America where the majority of our live audience was from. Maybe Europe just solidly favors command line. As for IBM OPM coming in with 0%, I'll just politely hold my tongue and let that information speak for itself. icon_wink

Join The DB2Night Show™ LinkedIn Group

The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

Insider Information

Here's another great reason to join The DB2Night Show LinkedIn Group: SECRET INSIDER INFORMATION. Every once in awhile, we run shows where EVERYONE in our studio audience can be a prize winner! JUST SHOW UP and COLLECT! We only announce these special shows within The DB2Night Show LinkedIn group!

Everyone that attended Episode #110 Database Performance Trends and gave us the prize word SLIPPERS won a $10 gift certificate to,, or Starbucks, or we made donations to the American Red Cross or Big Brothers Big Sisters - at the choice of each show attendee! IT PAYS TO LEARN DB2 on The DB2Night Show!

IBM IOD 2013 free FULL Conference Badge Winner!

In The DB2Night Show LinkedIn Group, we announced that we'd be giving away an IBM IOD 2013 Full Conference Badge to someone that attended either show #116 or #117. Congratulations to Manoj Gangwar from SEARS.COM in Hoffman Estates, IL! Manoj is going to IOD with a free badge from DBI and The DB2Night Show!


Congratulations to Joe Ledford at IBM GBS in Concord North Carolina! You've won a $25 gift card! Thank you for completing the survey after show #117 on Feelin' BLU with Scott Hayes, DBI, and Randall Ibbott, QBE!

To all of our winners - please be patient on these gift cards. We issue them every four to five or so shows because bulk gift card orders save time.

Get the Download Replays

WMV Format - approximately 68MB

To download a recorded replay of Episode #118 in WMV format, right click on the link below and choose "Save As..."
Episode #118, 1 November 2013, 17 Laws of building Petabyte Level DB and Big Data Systems with Lee Goddard, DBI

MP4 Format - standard resolution - 98MB

Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!

Did you learn something from this show?

See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS! icon_biggrin

Share a great show with your friends and followers:

Printer friendly