title="Pavan Kristipati on LinkedIn">  @pkristipati | Special Guest: Pavan Kristipati, Sr. DBA, Huntington Bank
DB2 LUW DPF/MPP for Single Partition DBAs in 10 Tips!
|
title="Pavan Kristipati on LinkedIn"> @pkristipati | Special Guest: Pavan Kristipati, Sr. DBA, Huntington Bank
DB2 LUW DPF/MPP for Single Partition DBAs in 10 Tips!
|
Show Host Scott Hayes Commentary
Once upon a time, way back in the early 90's, it was called DB2 EEE. Then it was called DPF (Data Partitioning Facility). Now IBM wants to call it MPP (Massively Parallel Processing). Changing names helps IBM keep documentation writers employed and gives them the opportunity to possibly charge you more for licenses. But, by whatever name it is called, DB2 for LUW DPF/MPP is massively scalable and wicked fast. Multiple servers, potentially having multiple logical partitions on each, all work together in parallel, in a shared nothing architecture, to compute answers to SQL queries incredibly fast. There are nuances and differences to administering a database like this, and Pavan does a great job of explaining differences and things you need to be aware of. The timing of this presentation is excellent because DB2 LUW V11.1 is now supporting BLU column organized tables in a DPF/MPP database. Cheers to your success!
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!
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! Further, you'll see how DBI uniquely presents performance information for DPF/MPP databases!
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
WMV Format - approximately 79MB
To download a recorded replay of Episode #180 in WMV format, right click on
the link below and choose "Save As..."
Episode #180 DB2 LUW DPF/MPP for Single Partition DBAs in 10 Tips!
MP4 Format - standard resolution - 134MB
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! Make sure you watch the replays too so that you understand the concepts!! 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!
Tweet
Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=691