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


Posted by nightshow on February 22, 2019, 2:06 pm
in DB2 LUW ( The DB2Night Show)







title="Klaas Brant on LinkedIn">
Klaas Brant, KBCE, IBM Gold Consultant



@klaas_brant


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








title="Klaas Brant on LinkedIn">
Klaas Brant, KBCE, IBM Gold Consultant



@klaas_brant


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 title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with
HealthPlan Services, do your target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">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?
target="NEW" title="Let's have a conversation - Contact DBI">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! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">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: http://bit.ly/HDB2N212

(The link is fixed now).


Sharing is Caring!


Share a great show with your friends and followers!

















Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=771