The DB2Night Show #166: DB2 LUW Tips, Tricks, SQL, & Scripts for Lazy DBAs


Posted by Scott on December 4, 2015, 2:09 pm
in DB2 LUW ( The DB2Night Show)








title="Pavan Kristipati on LinkedIn">
Pavan Kristipati on LinkedIn


@pkristipati


Special Guest: Pavan Kristipati, Sr. DBA, Huntington Bank



DB2 LUW Tips, Tricks, SQL, and Scripts for Lazy DBAs



96% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he details many of his tricks and techniques to make his DBA job easier and faster! Several examples are given and you can get his PDF! According to Pavan, these time saving techniques save him 30-60 minutes every day! Watch our replay for details...









title="Pavan Kristipati on LinkedIn">
Pavan Kristipati on LinkedIn


@pkristipati


Special Guest: Pavan Kristipati, Sr. DBA, Huntington Bank



DB2 LUW Tips, Tricks, SQL, and Scripts for Lazy DBAs



96% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he details many of his tricks and techniques to make his DBA job easier and faster! Several examples are given and you can get his PDF! According to Pavan, these time saving techniques save him 30-60 minutes every day! Watch our replay for details...






Show Host Scott Hayes Commentary



I've known Pavan for a few years now and it has been a delight to mentor him and watch him grow his skills. Even more impressive, he is becoming a very valuable contributor to our DB2 community. I encouraged him to speak at IDUG, and he ended up giving TWO presentations at his FIRST IDUG conference. In addition, Pavan writes helpful blogs at www.db2talk.com and quips funny, helpful, and insightful tweets via @pkristipati. I've connected him to Susan Visser @susvis at IBM and I'm looking forward to Pavan's published articles in Developer Works and IBM Data Management Magazine.


Pay attention to Pavan's presentation carefully! Follow his tips and tricks and you will save a lot of time every day!


Don't miss our Annual Eggnog Party
and DB2 Experts Panel



On 18 December at 10am CST, The DB2Night Show will run our annual Eggnog Party and MANY DB2 Experts will be in attendance! Our studio audience will be able to ask questions! The roster of IBM DB2 Experts includes Matt Huras, Adam Storm, John Hornibrook, Melanie Stopfer, and Mike Winer! Plus, we have several other top consultants and experts attending!


target="NEW" title="New Window: Click for details and to Register">
Details and Registration >







A message from our sponsor:

DBI Software



3 Years in a Row! Database Trends and Applications (DBTA) names DBI pureFeat™ Performance Management Suite for IBM DB2 a Top 100 Trend Setting Product!



DBTA Trend Setting Products 2014, 2015, and 2016


During today's short commercial break, DBI demonstrated how to find high cost SQL from a trend chart, and then how to get quality index solutions for statements consuming approximately 75% of all database I/O! Advanced Index Benefit Analysis was demonstrated and explained. All of this was done with just a couple of mouse clicks in under a minute!



Typical DBI customers enjoy 30-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="DBI Customer Success Stories - Click PDF links for instant access!">Customer Success Stories!


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!




Get the Download Replays




THEY'RE BAAAAAAACK!!


WMV Format - approximately 63MB


To download a recorded replay of Episode #166 in WMV format, right click on
the link below and choose "Save As..."


Episode #166, 4 Dec 2015,
DB2 LUW Tips, Tricks, SQL and Scripts for Lazy DBAs!



MP4 Format - standard resolution - 103MB



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



BONUS!! PDF from Pavan!



We can't always do this, but Pavan generously requested that we share the PDF of his presentation today! Yay! I can foresee many scriptaholics doing some serious copying and pasting! Hey! Make sure you watch the replays too so that you understand the magic that you are working with!! CLICK for PDF!




Did you learn something from this show?



Share a great show with your friends and followers! Let's get this tweeted and retweeted like crazy in honor of Pavan's contributions to the DB2 community!
















cript type="text/javascript" src="//static.addtoany.com/menu/page.js">
Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=651