The DB2Night Show #135: DB2 DPF Challenges, Solutions, and Successes


Posted by Scott on May 26, 2014, 10:17 am
in DB2 LUW ( The DB2Night Show)







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


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



DB2 DPF Challenges, Solutions, and Successes



100% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he details some of the DB2 DPF challenges he faced, his solutions to these challenges, and his measured successes. Learn how to reduce CPU utilization, make SAS queries run faster, speed up backups, achieve SLAs, smartly automate REORGs, and more. Watch our replay for details...








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


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



DB2 DPF Challenges, Solutions, and Successes



100% of our audience learned something! During today's show, Pavan shares his excellent IDUG presentation in which he details some of the DB2 DPF challenges he faced, his solutions to these challenges, and his measured successes. Learn how to reduce CPU utilization, make SAS queries run faster, speed up backups, achieve SLAs, smartly automate REORGs, and more. Watch our replay for details...






Show Host Scott Hayes Commentary



I need to first thank my co-host Martin Hubel for hosting today's show. As you'll hear, I was rather sick and didn't have very much voice. We've never cancelled an episode of The DB2Night Show™ since inception in 2009, and thanks to Martin this commitment continued successfully.


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.


I just saw the movie Million Dollar Arm and I'm feeling a bit sentimental at this moment. It is an excellent movie about family, overcoming challenges, and pursuing dreams. By and large, I appreciate and admire many of the Indian descendant professionals that I know in the DB2 community. They are polite, helpful, respectful, and hungry to learn and improve themselves. Kshitij Kohli @kohli83 won DB2's GOT TALENT in 2012, has presented two years in a row at IDUG, and made great strides in his career. Pavan is on the same career path of successes and I hope our DB2Night Show viewers will rally around him with tweets and other social media accolades.


I hope you enjoy this replay and learn great ideas from it.


PS- Martin asked me to include this update and I agree:



"WOW! With 92% of the audience voting, 100% learning something! This show was a great testimonial for tuning techniques in ANY environment, not just DPF. A must-see!"



Congratulations!



Aysel Boncu at TAI-TUSAS in Ankara Turkey completed our survey after Episode #134 "DB2 LUW INGEST Utility" and has won a $25 Amazon.com gift certificate! We'll get this sent out within the next few weeks! THANK YOU FOR COMPLETING OUR POST-SHOW SURVEY!!!


And yes, The DB2Night Show truly is watched and enjoyed by DB2 professionals around the world! Sometime this year we'll celebrate over 500,000 downloads of replays!






A message from our sponsor:

DBI Software









Magic Hat Money

Working with DBI is like making money magically appear!


Typical 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="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. 7 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



WMV Format - approximately 75MB


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


Episode #135, 23 May 2014,
DB2 LUW DPF Challenges, Solutions, and Successes!



MP4 Format - standard resolution - 66MB



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



BONUS!! SQL from Pavan!



Update 30 May 2014: Pavan requested that we make these SQL commands available - see replay for details! Get SQLs in TXT format!




Did you learn something from this show?


See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS! icon_biggrin


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!















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