Presented by: Peter Bendel
IBM SVL

"The DB2Night Show z57: IBM DB2 Analytics Accelerator for z/OS - More Than Just Query Acceleration"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Peter insight into the many new features of the IBM DB2 Analytics Accelerator. Watch the replay...

Special Guest: Michael Tiefenbacher
Manager Business Services & Data Management Specialist at ids-System

Using and Optimizing DataStage and DB2

100% of our audience learned something! DataStage is a very popular ETL tool that is used with IBM DB2 LUW. Michael offered some very valuable advice on how to maximize performance in DPF and non-DPF environments. Enjoy the replay ...

All About IDUG Philadelphia

---

DB2's GOT TALENT 2015 Winners!

IDUG Philadelphia 2015 - Get the Insiders Scoop!

100% of our studio audience learned something! IDUG Volunteers Terry Johnson, Conference Chair, and Steve Rosenberger, Thread Chair, shared with us great information about the upcoming IDUG Conference in Philadelphia! Learn about SIGs, Networking Events, Keynotes, Vendors, Receptions, Hands on Labs, Ed Seminars, and the most robust technical session grid that IDUG has ever offered!

2015 DB2's GOT TALENT Winners

• 1st Place: Rajesh Pandhare, IDUG plus $1,500 travel
• 2nd Place: Roberto Carlos Navarro Rios, DB2 Symposium plus $1,000 travel
• 3rd Place: Brandon Holman, Apple iPad
• 4th Place: Rohit Kumawat, $100 Amazon.com gift card

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!

DB2's GOT TALENT 2015
Finals Round #2

Top 8 Finalists Compete for YOUR Votes!

Great DB2 LUW & z/OS presentations!

100% of our studio audience learned something! Today's presentations were GREAT and included topics on MON_GET_DATABASE, Configuring UOW Event Monitor, IBM Performance Analysis Suite, Connecting DB2 LUW to Microsoft Access, SQL Injection and Exception Handling via Stored Procedures, taming a mismatched DB2 z/OS catalog, and solving challenges with IDAA and IBM Data Stage Jobs! This show contains another buffet of useful tips and advice! Enjoy!

DB2's GOT TALENT 2015
Finals Round #1

Top 9 Finalists Compete for YOUR Votes!

Great DB2 LUW & z/OS presentations!

100% of our studio audience learned something! Today's presentations were GREAT and included topics on package cache analysis, trying IBMBLU acceleration, battles with DB2 LUW license administration, DB2 10.5 BLU Data Skipping, DB2 z/OS SQL tuning via temp tables, DB2 z/OS Stored Procedure Analysis, a DB2 LUW Range Partitioning Case Study, and new features in db2pd for DB2 LUW 10.5! 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...

It's the International DB2 Olympics!

Today's Finalist Winners: Cristian, Leila, Akshat, & Rajesh

100% of our studio audience learned something! Today's presentations were again very good considering that we had contestants from Austria, Iran, 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 inline UDFs in DB2 V10/V11, Performance Optimization on SAP/DB2, Solving DBM1 high CPU usage, and lessons learned while upgrading DB2 LUW with avoiding pitfalls. 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 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...

Presented by: Cristian Molaro
IBM Champion and Gold Consultant

"The DB2Night Show z56: What you must know about Distributed access to DB2 for z/OS"
Replays available in WMV and M4V formats!

100% of our studio audience learned something!Cristian provided valuable tips and insight into distributed configuration, DBAT, and many other topics. Watch the replay...

Presented by: Adrian Burke
DB2 Swat Team, IBM SVL

"The DB2Night Show z55: Avoiding L2 Performance PMRs"
Replays available in WMV and M4V formats!

100% of our studio audience learned something! Adrian used RMF data to show several real world examples of DB2 as they show up at the z/OS level. Watch the replay...

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