In our 21st show, we were joined by special guest Mike Winer, IBM STSM, from the Toronto Lab. We ran a special 90 minute show so that Mike could cover his entire IDUG presentation on Locking. This guy is the LOCK MASTER! Mike covered types of DB2 LUW locks, lock memory, lock isolation levels, locking related registry variables (and you need to pay attention to these! ), DB2 9.7 Currently Committed, SQL options for locking, lock avoidance (the new standard! ), lock escalation, timeouts, and deadlocks, and how to monitor locking!

I'd also like to apologize to Mike and our audience. I have multiple computers, microphones, speakers, and headsets going when we produce these shows and I made a goof. The volume was turned down all the way on my headset in the beginning so I couldn't hear Mike speaking and I thought he'd gone for coffee, but, of course, he was there and freaking out because he thought the audience couldn't hear them. You all could hear him, but I couldn't. I chock this up to my most embarrassing show moment in 21 shows and I'm sorry for this goof. I'll try to do better in the future.

With all this said, pop yourself some popcorn and WATCH THIS SHOW...

[ more .. ]

In our 20th show, we were joined by special guest Ergin Babani, IBM Developer, Continuing Engineering Team. Ergin shared with us tips and best practices for using DB2 REDISTRIBUTE. During our lively Q&A session, we were joined by Katherine Kurtz, IBM, on the IBM Smart Analytics Systems Best Practices team. Learn more about DB2 REDISTRIBUTE best practices...

[ more .. ]

In our 18th show, Klaas Brant, IBM DB2 GOLD Consultant and Owner KBCE, Netherlands, shared with us his Top 10 DB2 LUW Mistakes that People Make. I think it was one of our best shows ever! The discussion was lively, and many tips were shared during the conversation! Are you making any of the Top 10 Mistakes? Watch this episode and find out...

[ more .. ]

In our 17th show, Berni Schiefer, IBM DE, Toronto Lab, shared with us the latest news on DB2 LUW Performance achievements and some best practices. DB2 is still winning TPC benchmarks! Berni's talk is peppered with assorted hints, tips, and best practices. What are his favorite DB2 9.7 features? Watch and learn...

[ more .. ]

In our 16th show, we talked about DB2 LUW Autonomic Memory and the Self Tuning Memory Manager (STMM). Our special guest was Adam Storm, Software Developer, DB2 Kernel Development, from the IBM Toronto Lab. Adam did a great job on updating us about Autonomic Memory and STMM, and he fielded some excellent questions too. Watch and listen...

[ more .. ]

In our 15th show, we talked about the new Online Table Move capability in DB2 9.7. Our special guest was Ergin Babani, DB2 LUW Continuing Engineering, from the IBM Toronto Lab. Despite recovering from a cold and having a sore throat, Ergin did a fantastic job for us on covering the options and features of this new capability, along with some insights, tips, and best practices. Of particular note, we hit a new record for studio audience questions - there were a lot of really good questions that you'll want to hear the answers to...

[ more .. ]

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 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 .. ]