Special Guest: Melanie Stopfer, DB2 Brain Surgeon, IBM Software Group

db2pd Party! The Power of db2pd!

99% of our audience learned something! Who knew that there were so many options for the powerful and popular "db2pd" command? Not only did Melanie share dozens of db2pd command examples and tips, but she also compared and contrasted to various MON_GET function calls and SQL commands. Bonus! Melanie also talked about DB2 security, trusted contexts, HADR, locking, indexes, and more! Enjoy...

Special Guests: Cristian Molaro, Ember Crooks, Guy Lohman, Iqbal Goralwalla, Jim Reed, Kelly Schlamb, Klaas Brant, Melanie Stopfer, Michael Krafick, Pavan Kristipati, Steve Rees, Surekha Parekh, Susan Visser, Martin Hubel, Scott Hayes...

Eggnog Party!
Celebrating 2014 with 2015 Insights!

82% of our audience learned something! 18% attended for the eggnog, fun, and insights! We paid tribute to Aamer Sachedina, we sang, we danced, and we learned what was great about DB2 in 2014 and what people are looking forward to in 2015! Watch or listen, and learn...

Special Guest: Ember Crooks, Xtivia
IBM DB2 GOLD Consultant

HADR and TSAMP
Advanced Topics!

100% of our audience learned something! Usually during webinars most people will wander off and peak at their email or do some holiday shopping, BUT NOT TODAY! Our studio audience attendees were super glued to Ember's awesome presentation! Not only did 100% learn something, but Attendees rated the Educational Value a 4.95 on a scale of 1-5! Watch and learn...

Presented by: Julian Stuhler
IBM Gold Consultant, Triton Consulting

"The DB2Night Show z54: Tuning zIIPs for Fun and Profit"
Replays available in WMV and M4V formats!

98% of our studio audience learned something! Jules talked about zIIPs, their use, metrics and more. Watch the replay...

Presented by: Klaas Brant
IBM Gold Consultant, KBCE

"The DB2Night Show z53: Altering objects and the impact it has"
Replays available in WMV and M4V formats!

96% of our studio audience learned something! Some alters are a piece of cake and can also reverted. Others are more complex and have a (big) impact. Some are still impossible and require you to drop and recreate the object. Watch the replay...

Special Guest: Scott Hayes, DBI Software

Sage DB2 LUW Performance Advice
A "New" Way to Analyze Performance

100% of our audience learned something! Based on his IDUG Phoenix Top 10 presentation, Scott presents a new way to think about and analyze DB2 LUW performance. Today's show even includes a 6 minute video clip taken from IDUG in Prague. ATTENDEES will receive all the cool SQL commands electronically! Watch and learn...

Presented by: John Campbell
Distinguished Engineer, IBM DB2 Development

"The DB2Night Show z52: DB2 Thread Reuse and RELEASE(DEALLOCATE)"
Replays available in WMV and M4V formats!

98% of our studio audience learned something! John did a deep dive into thread reuse, Release(Deallocate), and when to use it to maximum advantage. Watch the replay...

Special Guest: Iqbal Goralwalla, Triton Consulting

DB2 V10.5 FP4 "Cancun" Shadow Tables
and pureScale "Lite"
Early Hands-on Experiences

100% of our audience learned something! During today's show, Iqbal gave us an excellent presentation on his early user experiences with IBM BLU CANCUN (aka 10.5.0.4) Shadow Tables and pureScale "Lite". You will see performance results and many excellent recommendations on DB2 configuration settings, registry settings, and physical design. Watch and learn...

Presented by: Willie Favero
IBM Silicon Valley Laboratory

"The DB2Night Show z51: Willie's Winging It Volume 3"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Willie provided insight into a number of topics including service levels, documentation, zIIPs and statistics. Watch the replay...

Special Guest: George Baklarz, IBM

DB2 V10.5 FP4 "Cancun"

100% of our audience learned something! During today's show, George shared with us the significant improvements and enhancements that are delivered via Fixpack 4 of DB2 V10.5 BLU. You will learn about shadow tables, pureScale enhancements, improved Oracle compatibility and compression, improved performance, and more! Watch and learn...

Special Guest: Paul Turpin, Sr. DBA, BB&T Bank

Advanced "db2batch" command Tips and Techniques

98% of our audience learned something! During today's show, Paul shared his excellent IDUG presentation in which he details his experiences, tips, and advice for using the IBM DB2 LUW "db2batch" command. There are many options to consider. By using the right options, you can Run and Explain your SQL, limit outputs, and choose various levels of performance details. Watch our replay to learn all the tricks...

Presented by: Joel Goldstein
Responsive Systems Company

"The DB2Night Show z50: DB2 Buffer Pool Tuning"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Joel provided an in-depth look at buffer pool tuning with many real world examples. Watch the replay...

Presented by: Dan Luksetich
DanL Consulting Inc.

"The DB2Night Show z49: Understanding Query Transformation in DB2"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Dan gave a detailed look at how DB2 performs query transformation, how you can monitor it, and considerations for SQL and application performance. Watch the replay...

Special Guest: Melanie Stopfer, DB2 Brain Surgeon, IBM Software Group

Upgrading to IBM DB2 LUW V10.5 Best Practices and tips!

100% of our audience learned something! Our studio audience was filled with inspiration and gratitude for Melanie's presentation! Watch our replay and you will see a complete cookbook for how to upgrade, what to watch out for, undocumented tricks that will speed up your upgrade, and even a recipe for falling back to your original release if your upgrade has a hiccup! With 34% of our DB2 community currently running V10.5, the timing for this presentation is "just right" and it will undoubtedly be in our top Replays for 2014! Enjoy...

Presented by: Martin Hubel
Martin Hubel Consulting Inc.

"The DB2Night Show z48: Where is the Problem in My z/OS Transaction?"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Martin showed the sources of transaction data both within and outside of DB2, and the considerations for end-to-end problem resolution. Watch the replay...

Special Guest: Leon Katsnelson, Director, Information Management Cloud & Mobile, IBM Canada

IBM CLOUD UPDATE!

100% of our audience learned something! Awesome! IBM has three pillars of priorities: 1) Cloud, 2) Analytics (big data), and 3) Engagement (including mobile). If you check Leon's title again (above), LEON IS THE MAN covering two of the three important IBM priorities! Leon gave us an excellent presentation on Cloud computing plus an impressive demo! Check out our polling questions to see what your peers think about Cloud! Watch our replay for details...

Presented by: Dave Beulke
Dave Beulke and Associates

"The DB2Night Show z47: Big Data Disaster Recovery Performance"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Dave provided a wide variety of recovery options and strategies for backup and disaster recovery. Watch the replay...

Special Guest: Paul Turpin, Sr. DBA, BB&T Bank

Why Wait? DB2 LUW Locking

100% of our audience learned something! During today's show, Paul shared his excellent IDUG presentation in which he details terrific information about DB2 LUW locking! Learn about maxlocks, mon_lockwaits, mon_lw_thresh, mon_deadlock, mon_locktimeout, locktimeout, monreport, mon_get_pkg_cache_stmt, mon_db_summary, mon_lck_msg_lvl and the secret decoder ring, lock behavior, set current lock timeout, secret DB2 registry variables that impact locking, deadlocks, and much more, plus get MANY great SQL and command examples! Watch our replay for details...

Presented by: Sheryl Larsen
World Wide DB2 for z/OS Evangelist, IBM

"The DB2Night Show z46: What's New in DB2 11 SQL Coding and Tuning"
Replays available in WMV and M4V formats!

99% of our studio audience learned something!Sheryl provided intimate details on performance and SQL coding for DB2 11. Watch the replay...

Special Guest: Pavan Kristipati, Sr. DBA, Huntington Bank

DB2 DPF Challenges, Solutions, and Successes

100% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he details some of the DB2 DPF challenges he faced, his solutions to these challenges, and his measured successes. Learn how to reduce CPU utilization, make SAS queries run faster, speed up backups, achieve SLAs, smartly automate REORGs, and more. Watch our replay for details...

Presented by: Cristian Molaro
IBM SVL

"The DB2Night Show z45: Practical DB2 11 for z/OS Performance in a Nutshell"
Replays available in WMV and M4V formats!

98% of our studio audience learned something!Cristian provided tips and insight into application and system performance for DB2 11. Watch the replay...

Special Guest: Mark Gillis, Triton

DB2 LUW INGEST Utility

18% of our audience was running DB2 LUW V10.5 in production and 45% of our audience was running V10.1 in production. The INGEST Utility became available in V10.1 as a client side utility, yet 0% of our audience today was using it. 86% of our audience indicated they learned something from Mark. In our post show survey, many attendees indicated they will now consider evaluating INGEST. Not only did Mark brilliantly introduce the INGEST utility overall, but he also showcased how INGEST can be cleverly and effectively used as an ETL tool. Watch our replay for details...

Presented by: Willie Favero
IBM SVL

"The DB2Night Show z44: DB2 z/OS - Willie's Winging It"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Willie covered many topics from bufferpools, zIIPs, and prefetch to IDAA. This is a must-see for any z/OS DBA. Watch the replay...

Special Guest: Ember Crooks, Rosetta

Why Low Cardinality Indexes Negatively Impact Performance

100% of our studio audience learned something! Based on her popular IBM Developer Works article and blogs, IBM DB2 GOLD Consultant Ember Crooks brings her articles on Index Cardinality to life via her excellent IDUG presentation! Watch our replay for details...

All About IDUG
Phoenix, AZ - May 12-16, 2014

DB2's GOT TALENT Winners Announced!

100% of our audience learned something! IDUG volunteers Bob Vargo and Terry Johnson shared with us important news, updates, and tips for the upcoming IDUG Conference. There's a new process this year to sign up for the Thursday Dine-Arounds with your favorite speakers! Listen to our replay to find out how to get the most value from your IDUG Experience! Also, prepare yourself for emotional tears of joy as our DB2's GOT TALENT 2014 winners are announced! Enjoy...

Top 6 Finalists Compete for YOUR votes!

Grand Finale of the DB2 Olympics!

Almost 100% of our audience learned something! The DB2's GOT TALENT March Finalist shows are amazing, awesome, incredible, phenomenal, terrific, educational, fun, informative, and entertaining! You can learn from and enjoy great presentations by rising stars in our DB2 community! Watch this replay, learn good advice from your peers, then VOTE for your chance to win a $25 Amazon.com gift card!

Top 7 Finalists Compete for YOUR votes!

It's Day 7 of the DB2 Olympics!

100% of our audience learned something! The DB2's GOT TALENT March Finalist shows are amazing! You can learn from and enjoy great presentations by rising stars in our DB2 community! Watch this replay, learn good advice from your peers, then VOTE for your chance to win a $25 Amazon.com gift card!

Top 9 Finalists Compete for YOUR votes!

It's Day 6 of the DB2 Olympics!

100% of our audience learned something! The DB2's GOT TALENT March Finalist shows are amazing! You can learn from and enjoy great presentations by rising stars in our DB2 community! Watch this replay, learn good advice from your peers, then VOTE for your chance to win a $25 Amazon.com gift card!

Top 10 Finalists Compete for YOUR votes!

It's Day 5 of the DB2 Olympics!

A buffet of DB2 tips and advice! The DB2's GOT TALENT March Finalist shows are amazing! You can learn from and enjoy great presentations by rising stars in our DB2 community! Watch this replay, learn good advice from your peers, then VOTE for your chance to win a $25 Amazon.com gift card!

Today's Finalist Winners: Ian and Swapna

It's Day 4 of the DB2 Olympics!

100% of our studio audience learned something! We had some good presentations today on DB2 LUW! Learn how to tune DB2 LUW memory including bufferpools and configuration parameters, a clever way to save yourself a lot of typing for DB2 commands, and a method of transferring DB2 database data from UNIX to Windows systems. Watch this replay, learn good advice from your DB2 community peers, then complete our survey for your chance to win a $25 Amazon.com gift card!