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

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

December 4, 2015, 2:09 pm
Posted by Scott in DB2 LUW
Pavan Kristipati on LinkedIn

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 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!
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 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? 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!

Get the Download Replays


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!

Printer friendly