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

Posts Tagged ‘SoftBase’

Announces SoftBase Db2 Tools (SDT) Availability

All Baseline Posts, Uncategorized

SoftBase, a Fresche Solutions brand, is proud to announce the general availability of the SoftBase Db2 Tools suite 1.1.0 (SDT110). The SoftBase Db2 Tools suite allows developers, DBAs, and performance analysts to focus on meeting their customer demands of developing and maintaining software code.  These code, test, and deployment tools replace redundant code with proven processes that exploit features of z/OS Db2 that would otherwise require a dedicated staff to develop and to maintain.

As announced last year, the SoftBase Db2 Tools suite is a rebranding and renaming of the SoftBase Batch Healthcare flagship products with additional rich features and functionality. Along with the four products from Batch Healthcare, the suite includes the new Db2 Catalog Guide on z/OS and provides z/OS Db2 users with a high level of synergy between all five products:

  • Db2 Catalog Guide on z/OS
    The new product in the SoftBase Db2 Tools suite, Db2 Catalog Guide on z/OS, can be used to query the Db2 Catalog without writing time consuming SQL. A DBA can safely grant privileges to use this tool to application developers, testers, and production staff who need specific information that resides in the Db2 Catalog. No Db2 Locks are held on catalog tables and the SQL is 100% static.

    Db2 v12 Function Levels are key pieces of information that developers and DBAs will need to be aware of as Db2 v12 applications are created and updated.  Db2 Catalog Guide can quickly display this information without writing SQL or using the DISPLAY GROUP operator command.  We know that this light-weight tool will be the talk of your shop, so we are offering a six-month free trial to convince you.

  • Db2 Attach on z/OS
    In addition to allowing a batch application to run as a native z/OS job stream with //STEP EXEC PGM=progname rather than TSO or IKJEFT01, Db2 Attach provides a wealth of additional facilities. For example: LOGRBA, which triggers a read of the active Db2 log and a display of the high used RBA.  The user can specify a display of the high used RBA after the Db2 plan is opened and/or after the plan is opened and after each commit.  “SQL SET CURRENT item” is a facility which dynamically changes Db2 special registers.  SDT110 includes support for “SET CURRENT QUERY ACCELERATION value” which identifies when Db2 sends dynamic SQL queries to an accelerator server and what Db2 does if the accelerator server fails.  Additional Db2 Package options are available in MRF, providing more opportunity for multi-row fetch to be automatically implemented into existing batch Db2 applications without recoding.
  • Db2 Checkpoint on z/OS
    Users can have the product insert COMMITs and CHECKPOINTs into Db2 batch jobs, in many cases without even changing the application program. Db2 Checkpoint can restart Db2 batch jobs at the last CHECKPOINT prior to the point of failure, restore the working storage area, and reopen/reposition sequential files. It supports use of operator commands to ‘quiesce’ a long running job at the next successful checkpoint and restart the job at a later time. The new release also moves checkpoint buffers above the line, providing virtual storage constraint relief. and possible performance improvements.
  • Db2 Batch Analyzer on z/OS
    Helps developers maximize Db2 application tuning efforts by finding the worst performing applications first with almost no overhead. An ISPF interface allows developers to locate their own performance problems rather than using scarce systems and DBA resources. The product uses a drill down technique that allow even a novice user to identify Db2 application performance problems, down to an individual SQL statement.
  • Db2 DeadLock Advisor on z/OS
    (SQLCODE -911, SQLCODE -904) – Identifies the source of deadlock timeouts and resource unavailable conditions and presents that information on the offending and offended batch job’s log. Programmers can quickly identify the cause of deadlocks by examining the joblog of the affected application.

Upgrade Path

Existing customers will be pleased to know the upgrade path from Batch Healthcare to SoftBase Db2 Tools is the same familiar process that starts with the download of a zip file containing all five products. Each product can be installed independently and depending on the combination of products, a single product installation may complete all the installation steps for other SoftBase Db2 Tools products.

For more information, call 1-800-669-7076 or contact us here.


SoftBase Announces Rebranding of Batch Healthcare

All Baseline Posts, Uncategorized

SoftBase is proud to announce the rebranding of Batch Healthcare, our flagship product. The facilities under the Batch Healthcare umbrella will now be known as Db2 Attach, Db2 Batch Analyzer, Db2 Checkpoint / Restart, and Db2 DeadLock Advisor. Over time, each of these Db2 application deployment components have grown to support the increasing functionality of IBM Db2 for z/OS. SoftBase components’ rich features and functionality dictate a new name is needed to reflect current and future enhancements.

This name change not only shows the independence of each component, but also allows us to introduce an additional component, Db2 Catalog Guide. The Db2 catalog is a wealth of information. This information is useful to developers, testers, and production staff. Most tools, however, lock the data in the catalog or users forget to specify FOR QUERY ONLY WITH UR when querying the catalog. Even when they remember to specify it, it is often dynamic SQL which can also obtain locks on the catalog. Db2 Catalog Guide is 100% static SQL that will not lock the catalog. The catalog itself is a very complex database. Db2 Catalog Guide makes navigation of the database easy. There is a Db2 command interface as well as an explain interface for SQL in the catalog.

Please visit the SoftBase website for additional information on the complete family of SoftBase products and components.

Announcing Attach Facility’s MRF General Availability

All Baseline Posts, Multi-Row FETCH

SoftBase today announced the availability of a new product feature, Attach Facility’s Multi-Row FETCH (MRF), enabling DB2 users to automatically retrofit older applications for IBM’s Multi-Row FETCH technology. With Attach Facility’s MRF, DB2 administrators can simultaneously improve application performance by as much as 74 percent while bypassing the expensive recoding and testing process required to upgrade by hand.

IBM introduced Multi-Row FETCH to enable users to process multiple records (rows) simultaneously – saving time and reducing CPU overhead – a significant cost factor for DB2 shops. However, upgrading existing applications from single-row to multi-row requires an expensive manual recoding and testing process. SoftBase’s Attach Facility 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.

“We decided to run some test scenarios using SoftBase Attach Facility’s Multi-Row FETCH feature,” said Jeff Boggess, senior database administrator, NC Farm Bureau. “Because we didn’t have to manually code and test the processes, we were up and running much more quickly than expected. Being deployed so soon enabled us to run a SQL statement in which the CPU time went from 45 seconds to 11 seconds …that is a 74 percent improvement! The time savings translates to immediate dollar savings and reinforces the value we derive from SoftBase DB2 z/OS tools every day. ”

Key benefits of SoftBase Attach Facility’s Multi-Row FETCH includes:

  • the ability to improve legacy application performance, minimizing CPU utilization
  • reduction of mainframe computer usage, thus reducing IT expenses and
  • little-to-no recoding and testing of applications.


Read the rest of the press release here

Countdown to Attach Facility’s MRF General Availability Announcement

All Baseline Posts, Multi-Row FETCH

Next week, we plan to announce the General Availability of SoftBase’s Batch HealthCare version 3.2.1, which includes the much anticipated multi-row FETCH (MRF) feature of Attach Facility. We’re very excited about the launch – we’ve seen quite a bit of interest in the new feature.

The MRF feature is pretty amazing – it allows you to implement multi-row FETCH in your existing DB2 applications without manual recoding and testing. Our beta tests have shown FETCH statements CPU time savings as high as 74%. We’ve developed a savings and ROI calculator that estimates the amount of money your organization can save if it were to implement multi-row FETCH in existing DB2 applications manually or by using Attach Facility. See how much money multi-row FETCH it can save you here.

Or you can learn more about Attach Facility’s new MRF feature here.

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.

Employee Negligence is Top Cause of U.S. Data Breaches According to Symantec Study

All Baseline Posts, Data Security, Uncategorized

A recent Ponemon study sponsored by Symantec has found that employee negligence is the most common cause of data breaches in the US, while malicious attacks are the most expensive. Interestingly enough, the average cost per data breach has dropped from $7.2 million in 2010 to $5.5 million in 2011 – still a price no one wants to pay!

Data breaches are a very real and present threat to the modern organization. Between tangible damage such as direct fines, legal costs and lost customers, to intangible damage to the brand, data breaches cost organizations an average of $194 per record in 2011. The article goes on to detail best practices, and reports that hiring a Chief Information Security Officer (CISO) can help reduce the cost per record by up to $80 or 35%. You can read the rest of the article here.

“Organizations need to focus on processes, policies and technologies that address threats from the malicious insider or hacker.”

Here at SoftBase, we understand the mission-critical importance of data security. That’s why we built our DB2 application testing and test data sub-setting suite, TestBase, to include the most advanced data masking features available on the market. You need good quality test data for development, but you also need to keep your customer data safe with the best processes, policies and technologies available.

TestBase is the safest test data management solution available on the market – contact us or click here to learn more!

Video Replay for Craig Mullins’ Webinar: Improving Application Performance By Fetching Multiple Rows

All Baseline Posts, Baseline Videos, Multi-Row FETCH, Webinars

We had a great turnout at the webinar – 581 database professionals dropped in to listen to Craig talk about implementing muti-row FETCH. He showed some VERY impressive savings. The video below is a replay, the entire video is an hour.

Download Craig’s presentation slide deck at: https://s3.amazonaws.com/SoftBase/Craig+Mullins+MRF+webinar+slide+deck.pdf

The MRF feature of Attach Facility is a very hot topic right now – Craig talks about it in the webinar towards the end. It will allow you to implement multi-row FETCH without making any coding changes! Wouldn’t it be great to save 74% FETCH statement CPU by flipping a switch! Please contact us if you have any questions! Call us at (800) 669-7076 or go here. We’d love to hear from you!


Craig Mullins and SoftBase Present: Improving Application Performance By Fetching Multiple Rows

All Baseline Posts, Multi-Row FETCH, Webinars

Multi-row FETCH, available in DB2 since Version 8, has the capability to dramatically improve the performance of DB2-based database applications. This presentation will introduce and define multi-row FETCH, how to use it, and the performance implications of doing so. The presentation will also touch upon multi-row UPDATE. And it will introduce the new SoftBase Attach Facility MRF Feature, which allows you to implement multi-row FETCH without coding changes.

Time: Thursday, March 15 2:00 PM EDT. If you haven’t registered already, time is running out! Register at: https://www1.gotomeeting.com/register/754473201

Download the presentation slide deck at: https://s3.amazonaws.com/SoftBase/Craig+Mullins+MRF+webinar+slide+deck.pdf

If you do miss the live webinar, check back later soon – we’ll have a video replay available in our blog!


If you have any questions about our MRF product, which has shown CPU savings as high as 74% in FETCH statements during beta testing, click here to contact us now! Or email us at contactus (at) softbase.com or call us at 800-669-7076.

A fresh look at an overlooked DB2 feature…

All Baseline Posts

Multi-row FETCH, available in DB2 since Version 8, has the capability to dramatically improve the performance of DB2-based database applications.

But has YOUR organization taken the time to implement multi-row FETCH yet?

Join Craig Mullins March 15th for a FREE WEBINAR, where you’ll learn how easy it is to implement multi-row FETCH and the significant performance implications of doing so. We’re talking over 50% CPU savings on FETCH statements here! You can’t afford to miss this!

Craig will also introduce you to a new tool which allows you to implement multi-row FETCH automatically and without coding changes. The tool, SoftBase’s Attach Facility MRF feature, is still being beta tested, and our testers have seen FETCH statement CPU savings as high as 74%, without any recoding!

Click here to register for this free webinar, featuring Craig Mullins!

Video: What does quality mean to you?

All Baseline Posts, Baseline Videos

Here at SoftBase, we take pride in the quality of our company and products.

The video below shows several of us SoftBase employees talking about what quality means to us. Have a look!