The DB2Night Show #189: DB2 LUW Optimized for SAP - The rest of the story!

Martin Hubel  on LinkedIn
@mhubel

Special Guest: Martin Hubel
IBM DB2 GOLD Consultant

DB2 LUW Optimized for SAP - The Rest of the Story!

76% of our audience learned something! For 24%, it was review and validation they were doing the right things to tune and manage SAP on DB2 LUW! You will learn about registry variables for SAP, dropping and adding indexes, and more best practices. What's more, Martin talks about how to defend your DB2 turf from Hana! Please learn from, and enjoy, the replay...


Show Host Scott Hayes Commentary

As IBM Champions and DB2 GOLD Consultants, Martin and I have both been concerned about the relationship between SAP and IBM. Martin sheds some light on interesting tidbits of history. A few years ago, SAP raised the price of DB2 licenses. IBM responded by suggesting SAP customers buy DB2 licenses directly from IBM. SAP began to heavily market Hana, and, as recently as last year, it seemed SAP tech support wanted DB2 to fail - by prohibiting index changes. About two weeks after Martin published this article, SAP issued a tech note that is much more supportive of index changes. All of the details, including the Tech Note, are in the replay. Remarkable.

Here's the bottom line. Vended applications, like SAP and others, are designed for a broad range of customers, akin to "one size fits all" sweaters. To achieve optimized performance, organizations should tailor these applications according to their specific needs and implementations of the applications. What is right for one organization might be wrong for yours. If there is poor performing SQL, or unused indexes, you will need to fix these things even if your vendor resists. Once you fix the issues, measure your success and share the results with your vendor. In many cases, your vendor will then embrace your changes.


A message from our sponsor:
DBI Software

Two of DBI's Customer Success Stories come from SAP clients: Primesource Building Products and Wasserstrom. At Primesource, we helped them run SAP 4X faster in less than 24 hours, thus allowing them to avoid a costly (and unnecessary) hardware upgrade! Wasserstrom successfully runs SAP on half of the SAP recommended hardware. With the right index tuning work, SAP can run screaming fast on DB2 LUW. If you would like your SAP implementation to run faster without hardware and license upgrades, please Contact DBI Now.

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 SUCCESS STORY with HealthPlan Services, do your 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? 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 77MB

To download a recorded replay of Episode #189 in WMV format, right click on the link below and choose "Save As..."
Episode #189, 10 February 2017, DB2 LUW Optimized for SAP - The Rest of the Story with Martin Hubel!

MP4 Format - standard resolution - 97MB

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

Did you learn something from this show?

Share a great show with your friends and followers!