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

Posts Tagged ‘DB2 Consultant’

DB2 Multi-Row Fetch can reduce CPU time – but is it worth the effort?

All Baseline Posts, Webinars

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

 

SoftBase is providing a free tutorial on 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.

After this webinar, you will be able to:

  • Identify the best program and cursor candidates for MRF
  • Calculate your potential CPU savings from MRF
  • Access free tools to help you calculate ROI from implementing MRF manually or automatically
  • Determine if an MRF retrofit project is valuable enough to pursue

Wednesday, May 8

2:00-3:00pm Eastern

……………………………………………………

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:

https://www1.gotomeeting.com/register/565100185

You can download her presentation slide deck at:

https://s3.amazonaws.com/SoftBase/Efficiently+Finding+and+Fixing+High+Resource+Consuming+SQL+Softbase+Webinar.pdf

 

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

 

Overview

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.


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!


IOD 2011: Craig Mullins wraps up IOD

All Baseline Posts, Baseline Videos, IOD

We had a great experience with this year’s IOD. We met plenty of new and familiar faces, had some great conversations, and learned a lot about what DB2 users want and need. IOD is always a good opportunity for us to get “back to the roots”. We’ve had an excellent experience with Craig, who interviewed some top-notch DB2 experts this week (see video posts below). If you’re a DB2 professional, I’d highly recommend watching these videos. You’ll hear a variety of thoughts from some of the world’s best DB2 consultants, centered around hot topics in the DB2 world. Take a few minutes to watch them – you’ll be glad you did.

We’d like to thank Craig Mullins for working with us this year at IOD. He’s a first-class DB2’er, and it’s always a pleasure to work with him.

We’d also like to thank our guest speakers for spending some time with us. Thank you Cristian Molaro, Klaas Brant, Sheryl Larsen, Suresh Sane, and Dave Beulke. Check out the videos below in this blog to hear their thoughts on current hot DB2 topics!

Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc; a principal with SoftwareOnZ, a mainframe software distributor; and the publisher and editor for The Database Site. Craig has more than two decades of experience in all facets of database systems development including developing and teaching DB2 and SQL Server classes, systems analysis and design, database administration and system administrator, and data analysis and modeling.  He has worked with DB2 for z/OS since Version 1 and has experience working with other database technology including Microsoft SQL Server, Sybase and IMS. Craig has worked in multiple industries including manufacturing, banking, commercial software development, education, research, utilities, and consulting.

You can follow Craig on Twitter at @craigmullins, or you can check out his website at http://www.craigsmullins.com or read his blog at db2portal.blogspot.com.

 

 


IOD Highlights: Craig Mullins Interviews Dave Beulke

All Baseline Posts, Baseline Videos, IOD

Thursday was our last day in Vegas, and although we were sad to leave, we left with some great insights into exciting developments in the DB2 world. Craig talked with Dave Beulke for a few minutes before we left. Dave shared his thoughts on implementing temporal data, his recent experience mapping out a very large database for a client, and his thoughts on this year’s IOD.

Dave Beulke, an internationally recognized DB2 consultant with over 25 years in the industry, performs application performance reviews for Fortune 500 clients. He is known for his extensive expertise in DB2 high performance development and tuning. Dave’s expertise is in business intelligence data warehouse, Internet applications, Java architectures and system/application performance. Dave is a frequent speaker at local, national and international conferences, is a co-author of the IBM V8 and V7 z/OS DB2 Certification exams, and the Business Intelligence Certification exam, as well as a columnist for DB2 Magazine and former editor of the IDUG Solutions Journal. Dave has also been an instructor for The Data Warehouse Institute (TDWI) and a past president of the International DB2 Users Group.

Dave is a member of IBM’s DB2 Gold Consultants program and just announced, an inaugural member of IBM’s Data Champion program . Through his consulting service experiences, Dave researches performance and has dramatically reduced CPU demand for his clients, saving them from unnecessary hardware upgrades and millions in processing charges.

You can find out more about Dave and his consulting services at davebeulke.com

 


IOD Highlights: Craig Mullins Interviews Suresh Sane

All Baseline Posts, Baseline Videos, IOD

Wednesday was the last day for exhibitors at IOD, and it seemed to be the busiest. It was a good convention this year, with plenty of new and exciting things to learn about DB2. We tried to talk to as many of you z/OS folks as we could. If you saw one of us, we were probably handing you a flash drive and asking to scan your badge!

Craig talked with Suresh Sane today as well, and Suresh shared his thoughts on exciting new DB2 features, the difference in IBM conferences, and recommendations for anybody just getting started with DB2.

Suresh works as a Database Architect at DST Systems in Kansas City, MO and manages the Database Consulting Group, which provides strategic direction for deployment of database technology at DST.  He is an IDUG Hall of Fame speaker with three Best User Speaker awards.  He has lectured worldwide and co-authored 4 IBM Redbooks. And Suresh has also been recognized by IBM as an Information Champion for the past three years.

You can view his IBM Infomation Champion profile at https://www.ibm.com/developerworks/mydeveloperworks/profiles/user/SureshSane


IOD Highlights: Craig Mullins interviews Sheryl Larsen

All Baseline Posts, Baseline Videos, IOD

Tuesday was another bustling day at IOD. Craig talked with Sheryl Larsen for a little while after the expo. She discussed the things that she finds most surprising about development and how it is handled in DB2 shops today, as well as the most pressing features of DB2 10 for developers to focus on and the most exciting things that she’s heard about at IOD.

Sheryl is an internationally recognized researcher, consultant, and lecturer, specializing in DB2. She owns Sheryl M. Larsen, Inc., a firm specializing in Advanced DB2 Consulting and Education.  Sheryl is known for her extensive expertise in SQL and her firm performs detailed DB2 Performance Reviews for many clients. Sheryl has over 25 years’ experience in DB2, has published many articles, and she co-authored the DB2 Answers book.  Sheryl has spoken at events around the globe and is a member of the IDUG “Speaker Hall of Fame” as well as being an IBM Information Champion and a member of IBM’s DB2 Gold Consultants program since 1994.

You can find out more about Sheryl and her work with DB2 at www.smlsql.com

 


IOD Highlights: Craig Mullins interviews Klaas Brant

All Baseline Posts, Baseline Videos, IOD

Monday was another busy and exciting day for us at IOD. Craig took a few minutes to talk with Klaas after the general reception. Craig asked Klaas, organizer of the DB2 Symposium, to share his thoughts on what DB2 area people need the most training in, as well as his thoughts on exciting IBM developments.

Klaas Brant is the founder of KBCE, a company that specializes in DB2. Klaas has been working with DB2 for more than 25 years and he has published many articles on DB2 topics. He also is the organizer of the DB2 Symposium, a training event with full day seminars presented by industry leading DB2 consultants. Klaas is also the chairman of the Dutch DB2 User Group and an IBM certified DB2 Database Administrator. He is a member of IBM’s DB2 Gold Consultants Team and an IBM Champion. And if you have ever attended the web-based DB2Night Show, he is the host of the z/OS edition.

You can keep up with Klaas at www.kbce.com and you can find out more information about the DB2 Symposium at www.db2-symposium.com

Check back tomorrow for Craig’s interview with Sheryl Larsen.


IOD Highlights: Craig Mullins interviews Cristian Molaro

All Baseline Posts, Baseline Videos, IOD

Sunday had a great turnout at IOD! We saw lots of new and familiar faces, and enjoyed the festivities provided by IBM.

Craig Mullins spoke with Cristian Molaro for a few minutes. They discussed Cristian’s thoughts on the trends in programmer capabilities and work environments, DB2 features that might be most underutilized, and the biggest impediment to building efficient distributed DB2 systems.

Cristian Molaro is an independent consultant based in Belgium working in Europe for customers with some of the largest DB2 for z/OS and LUW installations. He is a regular presenter at international conferences and local user groups across Europe and North America. He holds a Chemical Engineering degree and a Master in Management Sciences, and is a coauthor of 5 IBM redbooks related to DB2. Cristian is part of the IDUG EMEA Conference Planning Committee, where he works as the Presentations Team Leader, and Chairman of the DB2 LUW User Group BeLux. He has also been recognized by IBM as a Gold Consultant and an Information Champion.

You can follow him on Twitter at @cristianmolaro or you can check out his LinkedIn profile at http://www.linkedin.com/in/cristianmolaro

Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc; a principal with SoftwareOnZ, a mainframe software distributor; and the publisher and editor for The Database Site. Craig has more than two decades of experience in all facets of database systems development including developing and teaching DB2 and SQL Server classes, systems analysis and design, database administration and system administrator, and data analysis and modeling.  He has worked with DB2 for z/OS since Version 1 and has experience working with other database technology including Microsoft SQL Server, Sybase and IMS. Craig has worked in multiple industries including manufacturing, banking, commercial software development, education, research, utilities, and consulting.

You can follow Craig on Twitter at @craigmullins or you can check out his website at http://www.craigsmullins.com