A survey of more than 900 application developers and DB2 administrators across an array of industries including financial services, insurance, retail and government found that database administrators are frustrated with the lack of performance and associated costs to run and maintain their existing DB2 and SQL servers.
Polling results of note include:
- 20 percent spend more than half of their week or a minimum of 8-12 hours per week addressing SQL performance issues.
- 59 percent agreed that SQL standardization is a recurring problem.
- When asked the best option for DB2 application performance improvement, an overwhelming 84 percent noted performance tuning as a solution.
- Only 8 percent saw a need for hardware/software upgrades as a solution.
“Spending a high percentage of the work week addressing SQL performance issues is outrageous and unnecessary,” said Steve Woodard, CEO, SoftBase. “The polling results, combined with customer feedback have made it very clear: IT is beyond frustrated with the current state of DB2 performance and cost. They are looking for solutions that don’t require manual coding and arduous upgrade cycles. Thus far, a more seamless and automated experience is non-existent, which is why so many developers and DB2 administrators are turning to our proven solutions for better coding, testing, batch analysis and performance tuning, ensuring more reliable DB2 applications and higher performing DB2 software.”
Two polls were conducted during recent SoftBase sponsored webinars. During each session attendees listened to industry leaders discuss how to dramatically improve the performance of DB2-based database applications as well as SQL and application performance improvement best practices.
Additional points of interest stemming from the real-time polling:
- 43 percent of participants noted the importance of mainframes as virtual environments become more prevalent – minimizing hardware expenditures and an organization’s carbon footprint.
- When asked why organizations have not implemented Multi-row Fetch (MRF) capabilities offered by IBM for performance improvement, 34 percent noted lack of developer resources and 29 percent called out other priorities taking precedence – MRF on its own requires expensive manual recoding and testing processes.
- Less than 3 percent felt that the technology did not provide enough benefit, re-iterating a market need.
SoftBase’s Attach Facility (with Multi-Row FETCH capability) sits between the application and DB2, providing an interface that enables administrators to pull multiple rows of data into a temporary memory space, immediately eliminating the need for the application to “go back” and retrieve additional information. It is the most widely used call-attach facility on the market and allows users to execute applications more efficiently, in less time and with greater flexibility.
To watch the two webinars, go to https://www.softbase.com/blog/?cat=4
To learn more about Attach Facility with MRF capabilities, go tohttps://www.softbase.com/batch_healthcare_attach_mrf_feature.php.
Tags: Application Performance, Craig Mullins, Multi-row FETCH, Sheryl Larsen