Fresche Quadrant Software BCD Software SoftBase NetLert ExcelSystems Software Development

Archive for the ‘Baseline Videos’ Category

Webinar Replay: 6-Steps to Determining if DB2 Multi-Row Fetch is Right for Your Shop

All Baseline Posts, Baseline Videos, Webinars

We had  a great turnout yesterday for our webinar 6-Steps to Determining if DB2 Multi-Row Fetch is Right for Your Shop. Scott did an excellent job explaining how to identify the programs and cursors with the highest potential savings from MRF and how to calculate the overall potential CPU savings from implementing MRF. Our DB2 Tech panel also did a terrific job answering attendee questions during the Q&A session.

Watch the video replay of the presentation below. The actual presentation ends at about the 18:50 mark, the remainder of the video includes the detailed Q&A session with our DB2 tech panel. Enjoy!

DB2 Parallel Development and Testing – Made Easy

All Baseline Posts, Baseline Videos, Webinars

Watch the video below and learn how to:

  • consolidate your test environment into a single database in a single subsystem,
  • realize faster application time-to-completion and higher developer productivity,
  • overcome typical challenges of parallel and single-threaded testing, and
  • improve ROI on your existing test data management tools.

The Slice tool can be installed in less than a day. Learn more about it here.

SoftBase Announces General Availability for TestBase Release 5.1.0

All Baseline Posts, Baseline Videos

SoftBase’s latest DB2 test data management solution further improves development productivity and reduces database backup time.

TestBase helps DB2 shops test new database applications faster and with fewer resources, reducing both time to market and overall development costs. The newest version, 5.1.0, includes several features that enable faster manipulation of test data, faster database archiving, enhanced performance with large data sets, and improved usability. These new features include:

  • Longer names supported – 128 character names
  • DB2 v10 functions supported
  • Edit data in tables without indexes
  • Image Copy Extract supported
  • Allows use of DB2 Unload utility
  • Partitioned Slice enhances performance with large data sets
  • Renamed Definitions and Procedures

Here’s what one of our customer’s had to say about the new features:

“TestBase 5.1 has been a HUGE time saver for our operations. We currently house upwards of 300 million rows in TestBase databases, and with the new features of 5.1 we are able to delete and load this amount of data in less than an hour, as opposed to over 12 hours using SQL deletes and inserts. We are able to partition the databases in the best way possible for our customers, while being able to control the integrity of the database and its functionality. We currently execute TestBase via batch to take nightly backups of over 200 databases, and with 5.1 we have been able to cut our batch processing time from 12 hours to 4 hours. We are completely happy with the changes, new features, and time savings that utilizing TestBase 5.1 has brought to us. TestBase has always been a great product, but the improvements from 4.5 to 5.1 are phenomenal! We love the TestBase product, Neal [TestBase Product Manager], and SoftBase in general!” –IT Specialist, Large Federal Government Agency

Read their case study here.

Watch the Video – What’s New in TestBase 5.1.0?

Director of Sales, Scott Garrett, provides an overview of TestBase, and TestBase Product Manager, Neal Lozins, discusses the new features in TestBase 5.1.0.

Neal begins discussing the new features at the 4 minute and 35 second mark, if you want to skip ahead.

Interested in TestBase?

Click here to learn more about TestBase or contact us by clicking here or calling 800-669-7076.

Watch the replay of Craig Mullins’ DB2 data security webinar

All Baseline Posts, Baseline Videos, Data Security, Regulation Compliance, Webinars

Craig gave another excellent presentation today on data security. If you missed it, you can watch the replay through GoToWebinar here:

Alternatively, you can just watch the replay below. Enjoy!


You can also download Craig’s presentation slide deck at:

Toward the end of the presentation, Craig explained the test data masking features of TestBase, our powerful test data management tool. Learn more about TestBase’s here or contact us to learn more.


Thanks again for another great presentation Craig!

Planning Next Year’s IT budget? Don’t forget MRF!

All Baseline Posts, Baseline Videos, Multi-Row FETCH

Watch the 3 minute video to learn why:


Implementing multi-row FETCH (MRF) in your DB2 applications can dramatically improve CPU consumption, by as much as 75% in open cursor FETCH processing. But the big challenges are:

  • Costs of allocating time to manually recode
  • Risk damaging functionality

Attach Facility mitigates these challenges by quickly and automatically implementing MRF in your batch DB2 applications – no recoding required.

Click here to use our free MRF ROI calculator to see how much you can save with Attach Facility!

Click here to contact us or call us at (800) 669-7076

Watch the Replay: Craig Mullins’ R4H Cost Reduction Webinar

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

Craig gave another great presentation yesterday on how to control your rolling four hour average (R4H). When you’re on variable workload licensing, understanding and controlling the R4H is critical to keeping your monthly bill in check. Craig discusses how you can directly restrict the R4H using soft capping and how techniques like tuning DB2 can reduce your overall CPU consumption – and subsequently your R4H. You can download Craig’s presentation slide deck here.

Register here to watch the replay and to join our mailing list – we’ll keep you in the loop about our upcoming DB2 webinars and our other DB2 resources!

Alternatively, if you don’t want to register, you can just watch the replay below. Enjoy!


If you have any questions or comments, we’re all ears! Send us a message here.

Watch the Sheryl Larsen’s SQL Tuning webinar replay

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

We’ve seen a huge response to the Sheryl Larsen webinar we sponsored yesterday, titled “Find Lost Money in your SQL: Efficiently Finding and Fixing High Resource Consuming SQL”.

It was an incredibly informative and educational webinar, in which Sheryl showed us dozens of ways to reduce CPU usage. At the end of the webinar, we talked breifly about our new ROI calculator for multi-row FETCH, which estimates the amount of money your shop will save over a 5 year period by implementing multi-row FETCH manually, or by using SoftBase’s Attach Facility MRF feature which automatically retrofits your applications for multi-row FETCH. You can input a few variables, and we’ll generate a custom 5-year savings and ROI forecast, specific to your shop! It’s quick easy, and a little fun! Here are a few neat examples of what we’ll create for you (did I mention it’s FREE?)

Check it out here:


If you’ve come to watch Sheryl’s webinar replay, it’s available on GoToWebinar now at:

You can download her presentation slide deck at:


Or you can watch the presentation replay below.

If you like the presentation or have any questions or comments, let us know at We’d love to hear from you!


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:

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’ Webinar September – DB2 10 for z/OS features that most impact developers

All Baseline Posts, Baseline Videos, Webinars

Last September, SoftBase and IDUG sponsored a webinar featuring Craig Mullins discussing upgrading to DB2 version 10 and the impact on developers.  You can watch the video below!


Here’s the video replay of Craig’s presentation:


Here’s Craig discussing how to best prepare your applications for the upgrade, and how to test them afterward:


Contact us for more information about our products!

Video: SoftBase employees share funny and embarrassing moments…

All Baseline Posts, Baseline Videos

Everyone has had an embarrassing work moment that they’d love to forget. But instead of forgetting our personally embarrassing moments, we’re broadcasting them to the world!

And why, you might ask? Because, let’s face it, embarrassing moments make pretty funny stories.

So sit back, relax, and have a laugh – at our expense!