In our 14th show, show host Scott Hayes, IBM DB2 GOLD Consultant and Information Management Champion, performed a deep dive into analyzing DB2 Snapshot numbers for a production DB2/Linux 9.7 database located in the UK. This database had STMM turned on, so we did a tangential LIVE demonstration on DB2's Self Tuning Memory Manager. Discover the real truths. Our findings might surprise or shock you...

[ more.. ]

In our 13th show, special guest Paul Zikopoulos, Program Director - DB2 Evangelism, IBM Software Group, provided us with fantastic information on "DB2 LUW Compression Updates". He covered compression in DB2 9.1, 9.5, and 9.7, index compression, temp compression, and even shared competitive information that compares DB2 LUW compression to Oracle and SQL Server. This Episode is a MUST SEE...

[ more.. ]

In our 12th show, special guest Susan Visser, Publishing Program Manager, IBM, introduced us to "The Wild Wonderful World of DB2 Information Resources". I had no idea that there were so many free and inexpensive resources available for quality DB2 information. Watch the replay of this episode to learn about the best blogs, best selling DB2 books, and the best websites for DB2 Information...

[ more.. ]

In our eleventh show, special guest John Hornibrook, Manager, Query Optimization Development DB2 for Linux, UNIX, & Windows, IBM Canada shared with us details of enhancements to the DB2 Optimizer in DB2 9.7 GA and Fixpack 1. The list of enhancements is very impressive! Watch this show to learn more...

[ more.. ]

In our tenth episode, we kicked of the year 2010 by inviting senior IBM executives Sal Vella and Tim Vincent to our show. DB2 LUW users from around the globe submitted letters of praise for DB2 and several enhancement requests. Watch this show and learn about enhancement requests that could become future DB2 LUW product features...

[ more.. ]

In our ninth episode, Scott Hayes, IBM GOLD Consultant and Data Management Champion, published author, frequent blogger, IDUG supporter and worldwide speaker, took a deep dive into DB2 Snapshot Data from a REAL LIVE DB2 LUW database that had been up and running for over a year! With the studio audience watching, we worked through analysis of an OLTP database. In studio audience surveys, many viewers asked for more shows like this one and some even volunteered their data for analysis!

Do you want to learn how to analyze the performance of a DB2 LUW database? Watch this show...

[ more.. ]

In our eighth episode, special guest Paul Bird from the IBM Canada Lab gave us updates on DB2 WLM and provided some best practices tips. However, the real excitement began when Mark Mulligan - a real live DB2 Customer using DB2 Workload Manager - shared with us his experiences and tips for implementing and using WLM. Mark's slides were impressive - he provided a cookbook recipe that others can follow!

Get the download - watch the replay...

[ more.. ]

In our seventh show, special guest Leon Katsnelson, Program Director, IBM Data Servers, IBM Canada, gave us a great comparison of SQL Server versus DB2 LUW. He also talked about FREE DB2 and DB2 LUW in the cloud, and, as a bonus, he even compared DB2 Express-C to Oracle Express. So, if you are interested in learning more about free databases or would like to know how these offerings are different, then this is the show to watch!

Get the download - watch the replay...

[ more.. ]

Oh! The audacity! In our sixth show, we talked about free application development tools for IBM DB2 LUW. We pitted IBM Data Studio against Quest Toad. Our special guests included Deb Jensen, IBM, and Jim Wankowski, Quest Software. Watch this show and listen to these two professionals duke it out for "best free tool"!

Get the download - watch the replay...

[ more.. ]

In our fifth episode, we invited the DB2 LUW community to share their favorite SQL Snapshot commands. Chris Eaton from IBM shared his Top 10 favorite SQL Snapshots, Rebecca Bond shared some DB2 Security SQL, and Scott Hayes also shared some of his favorite SQL Snapshots. If you'd like to learn about SQL Snapshots and see some very useful SQL commands, make sure you watch this show!

Get the download - watch the replay...

[ more.. ]

In our fourth episode, we enjoyed a presentation on the just announced DB2 9.8 PureScale release of IBM DB2 LUW. Our special guests included Matt Huras and Aamer Sachedina from the IBM Canada Lab. Watch this episode to learn about this exciting, highly scalable, release of DB2 LUW!

Get the download - watch the replay...

[ more.. ]

In our third episode, we pitted IBM HADR & HACMP against XKOTO GRIDSCALE. Our special guests included Dale McInnis, STSM - DB2 Availability Architect, IBM, and Arif Kassam, Xkoto’s CTO. If you would like to learn the difference between HADR and XKOTO GRIDSCALE, then watch this show!

Get the download - watch the replay...

[ more.. ]

In our second episode, we had some fun comparing Oracle terminology to DB2 LUW terminology, then Serge Rielau, STSM, DB2 Benchmark & Solutions Development, and Patrick Dantressangle, STSM, Information Management Architect, both from IBM shared with us details and success stories on DB2 LUW 9.7 Oracle enablement.

Get the download - watch the replay...

[ more.. ]

In our kickoff episode, we had some fun with DB2 Top Ten lists. Drew Bradstock, IBM DB2 LUW Product Manager, shared his Top Ten list for the coolest new features of DB2 LUW. Rebecca Bond, Independent DB2 LUW Security Consultant, shared her Top Ten DB2 LUW Security Tips on video locations throughout New Orleans. Scott Hayes, President & CEO of DBI, IBM GOLD Consultant and Data Management Champion, and host of The DB2Night Show shared his Top Ten ways to know your DB2 LUW database is toast.

Get the download - watch the replay...

[ more.. ]

In a continuing effort to improve our service to the DB2 LUW Community, DBI has started a blog for The DB2Night Show™. In blog format, you can pick up RSS feeds of new posts, be the first to know about upcoming show episodes, and find out about the availability of show replays.

Soon we will also create a Linked In group for The DB2Night Show where we can announce upcoming episodes and discuss prior shows. Stay tuned.

In the meantime, if you are not yet following The DB2Night Show on Twitter, please do so. We realize some organizations block Twitter, but you can set it up to follow on your mobile phone. "db2nightshow" is a low volume Tweet account - normally not more than six tweets per month. If you follow on your mobile phone, you will be amongst the first to know about trivia questions for prizes. Visit twitter.com/db2nightshow and follow us for fun!

Cheers,
Your Host,
Scott Hayes