Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #84: DB2 LUW HADR Updates and Best Practices

Vikram Khatri, IBM

Special Guest: Vikram Khatri, IBM

DB2 LUW HADR: Updates and Best Practices
Replays available in WMV and MP4 formats!

100% of our audience learned something! Our special guest, Vikram Khatri, shared with our audience his expert advice, experience, and best practices on DB2 LUW HADR, including DB2 10.1 updates! Vikram provided sample commands and outputs! His presentation is your recipe for HADR success! Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #83: DB2 pureScale - WHAT EVERY DBA NEEDS to KNOW!

Maria Schwenger, IBM

Special Guest: Maria Schwenger, IBM

DB2 pureScale: CRUCIAL Things EVERY DBA Must Know!
Replays available in WMV and MP4 formats!

96% of our audience learned something! Our special guest, Maria Schwenger, shared with our audience her expert advice, experience, and best practices on DB2 pureScale. From installation to configuration, hardware, and monitoring, Maria covered "the works"! Several command examples were included as well. Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #82: DB2 LUW 9.7 Fixpack "Pearls" - cool new stuff!

Iqbal Goralwalla, Triton Consulting

Special Guest: Iqbal Goralwalla
Principal Consultant, Triton Consulting, UK

LISTAGG, db2cklog, db2pd, db2caem, db2support, and more!
Replays available in WMV and MP4 formats!

100% of our audience learned something! Our special guest, Iqbal Goralwalla, shared with our audience his advice, tips, and experience with new commands and features delivered via DB2 9.7 Fixpacks. His findings and advice are PRICELESS. Several command examples are presented. Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #81: DB2 LUW V10 Breaking News Part 2 with IBM Guests


Special Guests: Danny Arnold and Glen Sheffield
Destined to be another 2012 Top 10 Downloads Favorite!

DB2 LUW 10.1! Adaptive Compression, HADR, Time Travel Queries, ZigZag Joins, and MORE!
Replays available in WMV and M4V formats!

Again, 100% of our audience learned something! Our special guests, Danny Arnold, IBM Executive IT Specialist, and Glen Sheffield, IBM Toronto Data Warehouse and Big Data Specialist, shared with us Part 2 of our deep dive into What's New in DB2 LUW V10. Adaptive Compression, High Availability Disaster Recovery (HADR) Enhancements, Time Travel Queries, ZigZag joins, and more performance enhancements were discussed, and sample SQL commands were shared to illustrate the concepts! What did you miss? Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #80: DB2 LUW V10 Breaking News Part 1 with IBM Guests


Special Guests: Danny Arnold and Glen Sheffield
Destined to be a 2012 Top 10 Downloads Favorite!

DB2 LUW 10.1! STOGROUPS, WLM, RCAC, and More!
Replays available in WMV and M4V formats!

100% of our audience learned something! Our special guests, Danny Arnold, IBM Executive IT Specialist, and Glen Sheffield, IBM Toronto Data Warehouse and Big Data Specialist, shared with us Part 1 of our deep dive into What's New in DB2 LUW V10. Storage Groups, Workload Manager Enhancements, and Row and Column Access Controls were covered, and many example SQL commands were shared to illustrate the concepts! What did you miss? Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #79: The PROACTIVE DBA with guest Michael Tiefenbacher

Special Guest: Michael Tiefenbacher
Data Management Specialist, IDS Systems, Germany

Several Useful SQL Examples!
Replays available in WMV and M4V formats!

93% of our audience learned something! Our special guest, Michael Tiefenbacher, shared with our audience his advice and tips for reporting key database performance metrics to management. Michael provided several example SQL commands that you can use to report service levels, up-time, and more. Watch and learn...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #68: Problem Determination for SQL/PL, PL/SQL, & Triggers

Special Guest: Serge Rielau
STSM, IBM Canada

Destined for Top 25 of 2012!
Replays available in WMV and M4V formats!

96% of our audience learned something! Our special guest, Serge Rielau, Senior Technical Staff Member at IBM Canada, shared with our audience advanced techniques for problem determination in SQL/PL, PL/SQL, and triggers - complete with demonstrations! And, the source codes are available! If you use these capabilities of DB2 LUW, you must watch this show...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #66: Top 10 Tips for e-Commerce Databases, Ember Crooks

Special Guest: Ember Crooks
Technology Manager, Rosetta

Destined for "Most Popular" of 2012!
Replays available in WMV and M4V formats!

Over the top! Our special guest, Ember Crooks, Technology Manager for Rosetta, under committed and OVER DELIVERED! Each of her Top 10 tips for e-Commerce database success were filled with important ideas and considerations! While her focus was e-Commerce databases, many of her ideas and recommendations are applicable to OLTP databases in general. 97% of our studio audience indicated that they learned something! WHAT DID YOU MISS?? Watch the replay...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #64: Top Things I learned at IDUG EMEA

Special Guest: Norberto Gasparotto Filho, IBM
2011 DB2's GOT TALENT WINNER

In episode #64, our special guest Norberto did a brilliant job of highlighting the top things he learned while attending IDUG EMEA in Prague. It was like "IDUG's Greatest Hits." For each technical session that Norberto attended, he shared excerpts and some of the most important, most valuable tips. He also talked a bit about his IDUG experience and the great value that he received. 94% of our studio audience indicated that they learned something! (I suppose the other 6% attended IDUG EMEA themselves and this show was review) WHAT DID YOU MISS?? Watch the replay...



[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #61: Tips from DB2 Community Experts

90% of our studio audience indicated they learned something! During this show, we had two special guests. Thiru Swamy shared a terrific presentation that talked about how he uses the SAP DB2 DBA Cockpit to successfully analyze and tune DB2/SAP databases. Nadir Doctor offered up some very clever SQL to analyze a database for redundant indexes and the need to run RUNSTATS. Nadir's SQL is available within the IDUG Code Place. Watch and learn!

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #60: Using DB2DART with guest Iqbal Goralwalla, Triton

100% of our studio audience indicated they learned something! Our special guest was Iqbal Goralwalla, Principal Consultant, Triton Consulting, and IBM Information Management Champion. Iqbal shared with us his top tips for using DB2DART to achieve storage reclamation, address index corruption, extract data, and remove backup pending status. Watch and learn...

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #59: DB2 LUW Index Design, Myths, Realities, and Magic

96% of our studio audience indicated they learned something! Our special guest was Martin Hubel, Owner MHC, an IBM DB2 GOLD Consultant, and IBM Information Management Champion. Martin claims to have put THREE children through college by fixing index designs. In Episode #59, you can learn Martin's secrets and advice, and score some very helpful SQL commands to aid your own analysis! Watch and learn...

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #58: Using and Tuning IBM OPM - What you NEED to know

100% of our studio audience indicated they learned something! Show host Scott Hayes wore two hats today - both host and guest speaker. Topics covered included DB2 access paths, index design, using IBM OPM, monitoring IBM OPM, and even tuning techniques to help OPM run more efficiently. For many, the show was a real eye opener. Watch the replay...

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #57: DB2 LUW Vital Statistics - What you NEED to know

94% of our studio audience indicated they learned something! (6% of our audience was IBM people! ha! ) Our special guest, John Hornibrook, STSM, Manager Query Optimization Development, IBM Canada, shared with us a wealth of great information about DB2 LUW statistics including tips, how-to's, and his suggested best practices. Our audience asked several great questions at the end. Watch the replay and learn more...

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #56: DB2 LUW Data Warehouse Tuning

94% of our studio audience indicated they learned something! (6% of our audience was IBM people! ha! ) Kate Kurtz, Gregor Meyer, and Haider Rizvi from the IBM Best Practices Teams shared with us their tips and insights on how to optimize the performance of Data Warehouse databases. What did you miss? Watch the replay...

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #55: DB2 LUW Multi-temperature Data Management

100% of our studio audience indicated they learned something! Kate Kurtz, Jim Seeger, and "Max" Petrenko from the IBM Best Practices Teams shared with us their tips and insights on how to smartly manage data of varying "temperatures". What did you miss? Watch the replay...

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #54: DB2 LUW Data Movement Utilities & Oracle Comparisons

Our special guest, Burt Vialpando, IBM, never disappoints us! 100% of our studio audience indicated that they learned something from today's show! Burt covered several ways to move data in DB2 LUW (for example, db2move, db2relocatedb, export, import, load, and others) and then compared these to Oracle data movement. What did you miss?!?!?! Watch the replay and find out!

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #53: Achieving DB2 LUW Access Plan Stability

96% of our studio audience indicated they learned something! How awesome is that?!!? Our special guest was John Hornibrook, STSM, Manager, Query Optimization Development, from the IBM Canada Lab. John shared with us more advice on how to optimize SQL queries, important ways to collect statistics, and how to "use a bigger hammer" to influence the DB2 optimizer. Learn about DB2 Optimization Profiles (DB2 "hints") and much more. Watch the replay and take advantage of all John's wisdom!!!

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #52: Writing Optimized DB2 LUW SQL Queries

Brilliant! Very Helpful! Outstanding! Participants in the studio audience of Episode #52 gave this show EXCEPTIONAL ratings! Our special guest was John Hornibrook, STSM, Manager, Query Optimization Development, from the IBM Canada Lab. John offered a buffet of outstanding advice on how to get your SQL to run faster and more efficiently! And, John should know the secrets - he IS the mastermind behind the DB2 LUW Optimizer! Watch the replay and take advantage of all John's advice!!!

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #51: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 2

It's another KNOCK OUT! Special guests from Triton Consulting and IBM Canada presented findings from their DB2 LUW versus Oracle Usability study. While you might expect some bias, the methods deployed for the study are quite scientific and objective. Julian Stuhler, Triton, focused today's talk on comparing automatic memory tuning, security administration, and auditing. Which database is "easier"? Watch and learn...

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #50: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 1

It's a KNOCK OUT! Special guests from Triton Consulting and IBM Canada presented findings from their DB2 LUW versus Oracle Usability study. While you might expect some bias, the methods deployed for the study seem rather objective and mathematically quantified. Host Scott Hayes got a little crazy with the boxing sound effects and startled Julian Stuhler out of his chair, but Jules recovered. Which database is "easier"? Watch and learn...

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #49: DB2 LUW Workload Manager - What, Why, How, Tips ...

IBM Developer Keith McDonald, aka "The K Guy", shared with us a fantastic presentation covering the DB2 LUW Workload Manager (WLM). He explained how it works, when and why to use it, and offered several tips, best practices, and helpful references. Watch and learn...

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #39: TOP DB2 LUW Support Issues with Triton Consulting

The DB2Night Show sets new records with TOP DB2 LUW Support Issues

Episode #39 set a new record for studio audience attendee registrations. Attendees also rated this show very highly with comments like "all db2nightshows are great... and today's one was no exception. thank you very much Scott&DBI" Our special guest was Julian Stuhler, Director Triton Consulting and an IBM DB2 GOLD Consultant. Julian, or "Jules" as most people call him, shared with our audience an assortment of DB2 Support issues that he and the Triton team have conquered. Several excellent tips were offered to help people avoid big mistakes...

[ more .. ]

by Scott in DB2 LUW

The DB2Night Show #38: DB2 LUW MDC Tables in the Real World

DB2 LUW MDC Tables in the Real World

In episode #38, special guests Susan Gausden and Terry Mason, both IBM DB2 GOLD Consultants, gave us a deep dive on what they've learned about using MDC tables with their clients. SQL commands were offered to help with analysis, as well as many tips, tricks, and recommendations. Watch the replay and learn...

[ more .. ]

by Scott in DB2 LUW

The DB2Night Show #37: DB2 LUW MDC Tables - Tech Details with IBM Guests

The Inside Scoop on DB2 LUW MDC Tables

IBM Guests Paul Z and Pate Bates Reveal How MDC Works, Best Practices, and Success Stories

In episode #37, special IBM guests Paul Zikopoulos and Pat Bates talked about how MDC tables work, some design best practices, and shared some impressive customer success stories. If you have a Data Warehouse database, this show is a "Must See". If you have an OLTP database, there are situations where MDC can make you a performance rock star. Watch this replay and learn!

On 21 January 2011, The DB2Night Show™ will take another look at MDC tables with "MDC Tables in The Real World". Our guests include IBM DB2 GOLD Consultants from the UK.

[ more .. ]

by Scott in DB2 LUW

The DB2Night Show #36: Comparing Database High Availability Solutions

Special guest Klaas Brant, IBM DB2 GOLD Consultant

Which solution is best? DB2 pureScale, Oracle RAC, or SQL Server Clusters?

In episode #36, special guest Klaas Brant, IBM DB2 GOLD Consultant and owner KBCE b.v., shared with us his expertise on database high availability solutions. High Availability was defined and discussed, then Klaas took us on a deep dive into DB2 9.8 pureScale, Oracle RAC, and SQL Server Clusters. His animated slides did a brilliant job of illustrating how these technologies work. In the end, Klaas convinced me of pureScale's superiority and exposed the scalability flaws of RAC.

Watch the replay of Episode #36 to see for yourself how these database high availability solutions work and learn which may be ideal for your circumstances...

[ more .. ]

by Scott in DB2 LUW

The DB2Night Show #35: One Company's Journey into The Cloud

Special guest Pierce Wetter, PACE Anti-Piracy

Cost savings in the DB2 Cloud? Performance?

In episode #35, special guest Pierce Wetter, Director Web Services with PACE Anti-Piracy, shared with us his company's experiences with DB2 in the Cloud. Pierce did a brilliant job of discussing PACE's motivations, considerations, and experiences. The cost information he shared was very interesting, and so, too, were the performance results of his Cyber Monday testing on Amazon.

Watch the replay of Episode #35 to learn from the experiences of one company that is blazing a trail in the DB2 Cloud...

[ more .. ]

by Scott in DB2 LUW

The DB2Night Show #34: What's NEW and COOL with DB2 and FREE TOOLS!

Special guest George Baklarz, IBM, Receives RAVE Reviews

FREE TOOLS??? Did someone say FREE TOOLS???

In episode #34, special guest George Baklarz, IBM Toronto Lab, shared with us a demonstration of some very cool (and free) tools that can be used to estimate DB2 compression results, simulate DB2 pureScale operation, and learn about the plethora of DB2 features and capabilities. He also shared a few tips and used his crystal ball to gaze into the future of DB2. Not only are we making the REPLAY available, but you can also DOWNLOAD and RUN the FREE DB2 TOOLS!!!

So, watch, learn, download, play, test, evaluate, and learn some more here...

[ more .. ]

by Scott in DB2 LUW

The DB2Night Show #33: 2nd Annual SQL Snapshot Potluck Party

Useful SQL Snapshots and Catalog Queries

Learn how DBAs in Croatia, France, and USA use SQL Snaps

In episode #33, Scott Hayes hosted The DB2Night Show's 2nd Annual SQL Snapshot Potluck Party. Members of the DB2 LUW community were invited to share their favorite SQL Snapshot commands that help them do their jobs well. Contributors will be receiving electronic copies of all SQL Snapshot commands submitted. Watch this episode and learn how your DB2 LUW peers:

  • "find log hogs and PIDs"
  • "monitor space utilization"
  • "learn intimate details about tables"
  • "monitor and resolve locks"
  • "avoid running reorgchk"
  • "find indexes that are harmful to ETL performance, cause lock problems, and burn up excessive CPU"
Also be sure to check out future scheduled episodes at www.DB2NightShow.com!

[ more .. ]
by Scott in DB2 LUW

The DB2Night Show #32: SAP on DB2 LUW - Lessons Learned with Martin Hubel

Tuning DB2 LUW for SAP and Lessons Learned

IBM DB2 GOLD Consultant Martin Hubel shares Lessons Learned and Tips...

In episode #32, special guest Martin Hubel, IBM DB2 GOLD Consultant and Owner MHC Inc., talked about a successful SAP implementation on DB2 LUW at The Wasserstrom Company. Martin shared valuable tips and lessons learned, and some of the tips apply to any OLTP application database. Watch and learn...

[ more .. ]

by Scott in DB2 LUW
Page :  1 2 3 4 5 6