DB2's GOT TALENT 2015
GRAND FINALE!

Top 5 Finalists Compete for YOUR Votes!

Great DB2 LUW presentations!

100% of our studio audience learned something! Today's presentations included topics on tuning production DB2 LUW Databases (Challenges and Solutions), Getting Connections to DB2 databases in restricted intranets (tunneling in secure environments), Pursuit of Happiness- Achieving Performance beyond SLAs, and "db2pd" - more than just problem determination! This show contains another buffet of useful tips and advice! Enjoy!

DB2's GOT TALENT 2015
Finals Round #3

Top 6 Finalists Compete for YOUR Votes!

Great DB2 LUW presentations!

100% of our studio audience learned something! Today's presentations included topics on IBM DB2 LUW Oracle Compatibility, scheduling db2top via crontab, monitoring enhancements for BLU columnar tables, lessons learned on defining disk storage, where to get, and how to install, free drivers for DB2 10.5 Express-C, and how to connect Java to DB2 via Hibernate for good performance! This show contains another buffet of useful tips and advice! Enjoy!

Special Guests: Mohan Saraswatipura & Kent Collins, Authors

DB2 LUW 10.1/10.5 Certification Crammer,
Part 2

No surprise! Again, 100% of our audience learned something! Mohan and Kent did a great job introducing their new forthcoming DB2 Certification book, plus they taught various topics from the book! The book will be available 24 April 2015, but you can pre-order it now and save money! Watch today's show and learn about DB2 PureScale, DB2 BLU Columnar Storage, DB2_WORKLOAD, capabilities, features, advice, and FACTS you need to know to pass the Certification Test!! Enjoy...

Special Guests: Mohan Saraswatipura & Kent Collins, Authors

DB2 LUW 10.1/10.5 Certification Crammer,
Part 1

No surprise! 100% of our audience learned something! Mohan and Kent did a great job introducing their new forthcoming DB2 Certification book, plus they taught various topics from the book! The book will be available 24 April 2015, but you can pre-order it now and save money! Watch today's show and learn about DB2 9.7 FP3 Database Schema Transport, DB2 10.1 Storage Groups, DB2 10.1 Multi-Temperature Storage, DB2 10.1 System Period Temporal Tables, and DB2 10.5 Shadow Tables! Enjoy...

It's the International DB2 Olympics!

Today's Finalist Winners: Brandon, Roberto, Pratik, Sreeharsha, & Rohit

94% of our studio audience learned something! Today's presentations were surprisingly good considering that we had contestants from New Zealand, Mexico, and India! It fascinates me that we can gather around our computers and learn from industry peers all over the world. You will learn about improved indexes in V10.5, locking analysis and tips, how to improve Federated DB2 performance, a method to achieve high availability for DB2 10.5 using OS Clusters, insights from a DB2 z/OS DBA that experimented with DB2 LUW Express-C, and experiences with testing DB2 10.5 columnar tables with storage and performance results. Truly, this show contains a buffet of useful tips and advice! Enjoy!

Special Guest: Adam Storm, Master Inventor & STSM, IBM Canada Lab

5+ Cool Tricks for DB2 LUW

100% of our audience learned something! Based on his popular and humorous IDUG presentations, Adam treats our audience to his wit and wisdom for DB2 LUW --- and even includes a bonus trick! #6! You will learn about STMM - how it works and ideas for monitoring it, a secret decoder ring for db2diag.log, Workload Manager and how to pull pranks on your friends, how NOT to use db2dart, and more! Enjoy...

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

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

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

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

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

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

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

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

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

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

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!

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!

Today's Finalist Winners: Prasad, Michael, and Raja

It's Day 2 of the DB2 Olympics!

100% of our studio audience learned something! Today's presentations were fantastic! We had seven LUW themed contestants! You can learn about ADMIN_MOVE_TABLE, monitoring and tuning static SQL, reclaiming space with db2dart, solving a complex DB2 DPF performance issue, the change event history monitor, and Q-replication! This show contains a buffet of DB2 tips and advice! 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!

Today's Finalist Winners: Robert, Saurabh, and Mariana

It's the DB2 Olympics!

95% of our studio audience learned something! Today's presentations were fantastic! Ember Crooks was a substitute judge for Klaas Brant. USA, Brazil, and India competed! You can learn about DB CFG CPUSPEED, a solution for purging 1.1TB of data, and get advice on automating DBA tasks. This show contains a buffet of DB2 tips and advice! 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!

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

75 Ways to Save I/O and 25 Ways to Save CPU

92% of our studio audience learned something! During this episode of The DB2Night Show™, Lee Goddard shared priceless thoughts and valuable tips on how to reduce system resource consumption! Odds are very high you are going to learn something helpful! Watch and learn...

Special Guest: Martin Hubel, MHC, IBM DB2 GOLD Consultant and Information Management Champion

Tuning SAP on DB2 LUW

100% of our studio audience learned something! During this episode of The DB2Night Show™, Martin offered many valuable suggestions for tuning SAP in a DB2 LUW environment based on his experiences at several clients. This presentation has "meat on its bones"! Learn about dropping indexes, adding indexes, block based bufferpools, STMM, Vector I/Os and more! Watch and learn...

Special Guests: Ember Crooks, Rosetta, and Fred Sobotka, FRS Consulting

DB2 LUW Potluck - DB2 Experts Review Insights from IBM IOD 2013

88% of our studio audience learned something! 12% attended for the humor! During this episode of The DB2Night Show™, Ember and Fred shared with us what they learned and observed at IBM IOD 2013. Find HADR tidbits and more, plus some great advice if you are thinking about attending IBM Insights in 2014! Watch and learn...

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

Special Guests: Scott Hayes, DBI, and Randall Ibbott, QBE

Feelin' BLU - Beyond the Marketing Hype
DB2 Users Test Drive BLU!

95% of our studio audience learned something! During this episode of The DB2Night Show™, we skipped the marketing BLAH BLAH BLAH and real IBM DB2 BLU users shared their performance science projects and experiences! Watch and learn...

Special Guests: IBM Master Inventors Guy Lohman and Shankar Raman

IBM DB2 BLU Intimate Details!

97% of our studio audience learned something! During this episode of The DB2Night Show™, Guy and Shankar began by sharing the usual "marketing" slides on BLU (it must be an IBM requirement) but then treated us to a deep dive on technical details we've not seen in any other presentations. If you're the sort of person that likes to take things apart to see how they work, then watch and learn...

Special Guest: Kent Collins, Sr. Database Consultant

IBM DB2 10.5 BLU "Real Life" Experiences and Advice!

100% of our studio audience learned something! During this episode of The DB2Night Show™, Kent shared with us many Kent-isms such as "It isn't peanut butter and jelly" along with volumes of practical BLU advice based on his testing and implementation experiences. Kent affectionately called his presentation "A BLU print for BLU!" Watch and learn...