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

The DB2Night Show #212: Db2 LUW SQL Tuning; Find, Fix, and Prevent Problems

February 22, 2019, 2:06 pm
Posted by nightshow in DB2 LUW
Klaas Brant, KBCE, IBM Gold Consultant


Special Guest: Klaas Brant
Owner, KBCE
IBM Gold Consultant

Db2 LUW SQL Tuning: Find, Fix, and Prevent Problems!

100% of our audience learned something!Klaas gave us another amazing presentation! From monitoring commands to utility recommendations, Klaas covered it all! Watch our replay to learn MON_GET queries, OS commands, configuration settings, and best practices for making your Db2 SQL run crazy fast! Watch and learn...

Show Host Scott Hayes Commentary

Klaas is kind of like the best teacher you had in high school or your favorite college professor. You sit on the edge of your seat eager to hear what enlightenment he is going to share next. As with his prior show #209, this presentation is full of great ideas that will help you succeed with IBM Db2 LUW.

A message from our sponsor:
DBI Software

In the interest of time, we didn't do a commerical today! You're welcome. icon_lol Still, Klaas had a lot to share so this show is nearly 90 minutes duration. Sorry for running long, but every minute is valuable!

Magic Hat Money Working with DBI is like making money magically appear!

Typical customers enjoy 40-60% CPU utilization reductions in the first week, plus measurably faster transaction and query response times. More importantly, your time savings will be substantial! Read our newest SUCCESS STORY with HealthPlan Services, do your due diligence, and speak with as many references as you have time to call.

We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce performance on Black Friday multiple years in a row. 8 of the Top 25 Retailers, plus others, plus top Banks, State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you? Contact DBI

Join The DB2Night Show™ LinkedIn Group

The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

The State of the Db2 Universe Study

Show host Scott Hayes has teamed up with IBM and IDUG to conduct a survey about the use of Db2 around the world. IBM labs contributed several questions. We want to know if the use of Db2 is growing or shrinking, what features are the most popular, how is Db2 being used, and what skills are highest in demand.

Participants can receive a copy of the study findings which may be very helpful to your Db2 career. Also, sponsors are giving away one free badge to the IDUG Conference June 2-6 in Charlotte NC, plus several Amazon gift cards will be given away to lucky random winners.

Please TAKE THE SURVEY now. According to Survey Monkey, the average participant is finished in 6 to 9 minutes.

Get the Download Replays

WMV Format - approximately 85MB

To download a recorded replay of Episode #212 in WMV format, right click on the link below and choose "Save As..."
Episode #212, 22 February 2019, Db2 LUW SQL Tuning with guest Klaas Brant

MP4 Format - standard resolution - 157MB

Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!

NEW! Watch on YouTube!

PDF Handouts

If you would like a copy of Klaas Brant's presentation, Klaas requests that you click here:
(The link is fixed now).

Sharing is Caring!

Share a great show with your friends and followers!

Printer friendly