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

Archive for the ‘Webinars’ Category

Webinar with Craig Mullins: Data Security in the Age of Regulatory Compliance

All Baseline Posts, Data Security, Regulation Compliance, Webinars

Webinar Title: Data Security in the Age of Regulatory Compliance
Presenter: Craig S. Mullins

As governmental regulations expand, organizations need to deploy better controls to ensure quality data and properly protected database systems. Sarbanes-Oxley, HIPAA, BASEL II, PCI DSS and more make the news, but what do they mean in terms of your data? And what steps can be taken to ensure compliance?

Anyone who has been paying attention lately knows at least something about the large number of data breaches in the news… and their impact on business. Data breaches and the threat of lost or stolen data will continue to plague organizations until comprehensive plans are enacted to combat them. Many of these breaches have been at the database level, and more will be unless better data protection policies and procedures are enacted on operational databases.

As a result of expanded regulations and the ever-present specter of data breaches, data security has grown in importance. And that places new burdens on DBAs and data management professionals. This presentation will offer an overview of this new landscape focusing particularly on techniques for improving data and database security.

Topics to be discussed include:

  • An Introduction to Industry and Governmental Regulations
  • The Pervasiveness of Data Breaches with Techniques for Avoidance and Remediation
  • Long-term Data Retention
  • Database Activity Monitoring and Auditing
  • Data Encryption
  • Data Masking
  • Metadata Management

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.

SoftBase Sponsor’s Craig Mullins: Reduce Costs by Tuning DB2 to Reduce Your Rolling 4 Hour Average

All Baseline Posts, Webinars


Title:Reduce Costs by Tuning DB2 to Reduce Your Rolling 4 Hour Average
When: 2pm EDT September12
Register at: https://www.softbase.com/redirect_craig_mullins_webinar_register_09122012.php

Variable workload licensing can be a powerful mechanism to reduce your mainframe software costs. But are you taking full advantage of the opportunities that exist to lower your monthly software bill? Do you know how the rolling four hour (R4H) average impacts your bill and what you can do to lower that average?

This free webinar, sponsored by SoftBase and delivered by Craig S. Mullins, will provide education on variable workload licensing, the R4H, and soft capping… and then focus on ways to reduce the R4H by tuning DB2 resources.
SoftBase – Craig Mullins and SoftBase Present: Reduce Costs by Tuning…

SoftBase will be giving away a signed copy of Craig Mullins’ DB2 Developer’s Guide, Sixth Edition. Attend for your chance to win!

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: https://www.softbase.com/mrf_roi.php


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 contactus@softbase.com. We’d love to hear from you!


SoftBase Sponsors Sheryl Larsen Webinar

All Baseline Posts, Webinars

What:     “Find Lost Money in your SQL: Efficiently Finding and Fixing High Resource Consuming SQL”
Who:      Sheryl Larsen, IBM Information Champion & Gold Consultant
Where:   To register, please go to https://www.softbase.com/redirect_sheryl_larsen_webinar_register.php?src=blog



Sheryl Larsen and SoftBase have teamed up to bring you a crash course in serious SQL and application performance improvement.

In this presentation, Sheryl will demonstrate how to find, analyze and tune the top 40 expensive queries. Special emphasis will be on finding the cursors that could benefit from multi-row fetch. In addition, Sheryl will discuss designing perfect indexes, MQTs and AQTs, along with manual query rewrite, SQL exploitation and, most importantly, proper use.

Sheryl will also show you a revolutionary new way to implement multi-row FETCH in your existing applications without the time consuming recoding and testing.

There’s a lot of material to cover in this presentation, so be ready to take notes!

If you can’t attend the live presentation, a replay will be available the following day through the registration link above.

Why aren’t you using Multi-Row FETCH?

All Baseline Posts, Multi-Row FETCH, Webinars

Throughout our interactions with customers, we found that most shops aren’t using multi-row FETCH in their existing applications. We found that a little strange, considering multi-row FETCH (MRF) has been shown to improve FETCH statement CPU on the order of 50-70%, and it’s been available since DB2 v8. And based on the level of interest in MRF we’ve seen, it’s safe to say that most DB2 users understand its benefits. So why aren’t more shops using it?

A few weeks ago, my assumption was that a combination of lack of training and resources forced shops to put multi-row FETCH on the back-burner. There’s a lot at stake running a company database, and the highest priority for a database professional has always been to keep it running – so performance tuning, albeit very important, never ranks as high a priority as ‘keeping things from breaking’.

According to a recent poll of over we performed in Craig Mullin’s Multi-Row FETCH Webinar, over 350 database professionals told us why they don’t use MRF in their old applications.



Over half said they either lacked sufficient developer resources or had other priorities. Those folks should talk to us about our Attach Facility’s MRF feature! It puts multi-row FETCH in your old applications quickly, automatically and without development. Sound interesting? Shoot us a quick email here and we’ll send you details.

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.

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!