[Skip to Content]
Fresche Quadrant Software BCD Software SoftBase NetLert

Posts Tagged ‘Big Data’

DBTA Article: Using Multi-Row Fetch to Lighten the Load of Big Data

All Baseline Posts, Multi-Row FETCH

The explosion of big data has presented many challenges for today’s database administrators (DBAs), who are responsible for managing far more data than ever before. And with more programs being developed and tested, more tools are needed to help optimize data and efficiency efforts.  Using techniques such as DB2’s Multi-Row Fetch (MRF), DBAs are able to cut down on CPU time – and improve application efficiency. This article will explore the benefits of MRF, including the ability for DBAs to improve their application performance and lighten their workloads.

Click here to read the rest of the article


SoftBase’s Attach Facility enables you to implement MRF in your DB2 applications automatically, no recoding required.

Click here to learn more about implementing MRF automatically

Big Data = Big Pressure on DBAs

All Baseline Posts, Big Data, Multi-Row FETCH

Everyone is talking about Big Data. But what is it really? Data is generated by a plethora of activities in today’s digital world and is typically stored for a period for any number of reasons. It can be data from weather sensors, electrical grid sensors, pharmaceutical data, social media posts, purchase transactions, cell phone GPS signals, customer information, insurance claims, etc—the list goes on and on.  But as new data continues to grow at faster and faster rates, IT professionals see a mounting problem. How are they going to manage, store and use this information to create a competitive advantage?

These days, you rarely hear someone talking about Big Data without mentioning analytics or warehousing. While Big Data clearly has its uses for business intelligence, we pay for this insight with ever-increasing workloads and throughput demands. Since DBAs need to ensure that they can meet these new growing demands without compromising mission-critical applications, it’s more important than ever for DBAs to quickly improve application efficiency and keep CPU utilization growth from getting out-of-hand.

We’ve seen significant CPU savings in our customers who’ve implemented multi-row FETCH, and recommend to all our customers that they consider implementing it. Our Attach Facility now implements multi-row FETCH for you, automatically. Contact us today for more information!


Lighten the Load with Multi-Row FETCH

All Baseline Posts, Big Data, Multi-Row FETCH

With the explosion of data and the challenges that Big Data presents, today’s DBAs are managing more data than ever before. With more programs being developed and tested, more tools are needed to help optimize data processing and efficiency. Using tools such as Multi-Row Fetch (MRF), DBAs are able to cut down on CPU time and improve application efficiency, even in facing Big Data.

MRF testing has been shown to provide CPU savings on individual FETCH statements in the 50-60% range. As FETCH statements are an integral part of batch processing, it’s not unreasonable to see TOTAL batch CPU savings in the double digits. As Big Data continues to get bigger and IT budgets continue to tighten, DBAs will need to implement as many CPU saving techniques as they reasonably can. They will have to do a lot more with more data and less resources.

Implementing MRF is a great way to lighten the load, and SoftBase can help you do it without any source code changes. Using the revolutionary, patent-pending Attach Facility MRF feature, SoftBase helped customers automatically implement MRF for CPU savings as high as 74%. Contact us to learn more about how this works.