Articles & Content

Craig S Mullins

Craig S Mullins is president & principal consultant of Mullins Consulting, Inc., is an IBM Information Champion, and an IBM Gold Consultant for DB2. Craig has three decades of experience in all facets of database systems development including developing and teaching DB2 and SQL classes, systems analysis and design, database and system administration, and data analysis and modeling. Craig is a frequent speaker at IT conferences, having spoken about database issues to thousands of folks at conferences such as IDUG, IBM Information on Demand, SHARE, and DAMA. He has spoken at events in North America, Europe, Asia, and Australia.

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG and should not be construed as reflecting official positions of the IBM Corporation. .

 

 
Catch You in Philly for the IDUG Db2 Tech Conference 2018 Well, this year’s IDUG North American DB2 Tech Conference is almost upon us and I hope you have made plans to be there. If not, it is still not too late, though. The conference is being held in Philadelphia, PA this year -- The Cradle of Liberty -- from April 29 - May 3, 2018. I don’t know abo…
The Db2 12 for z/OS Blog Series - Part 21: New Global Variables for Continuous DeliveryOne of the most important new "features" of Db2 12 for z/OS is continuous delivery. With continuous delivery more functionality will be made available more quickly than ever before. Instead of waiting for big version migrations new function levels can be applied rapidly, thereby delivering desired f…
On Leaky Pipes and DBAs How is a plumber like a DBA? I was working in my backyard a couple of weekends ago, trying to find the cause of a leak. You see, there was a big puddle of water in the backyard, it hadn’t rained lately, and it was larger than the sprinklers could’ve made. Down here in Texasalmost everyone has …
Db2 Application Development for Performance: Be Early and Be InformedThe title of this blog post is also the title of one of my two IDUG Db2 Tech Conference presentations in Philadelphia this year. I chose this topic because I am in the process of writing a book on Db2 performance from a developer perspective. There are a lot of performance-focused presentations but…
Seasons Greetings 2017It is that time of year again... A time to reflect on the year gone by and to enjoy time with our friends, family and loved ones. A time to put down the work that consumes us most of the year and to celebrate and enjoy... to remember past years and to consider the upcoming year. No matter what…
The Db2 12 for z/OS Blog Series - Part 20: Fast Insert: An Alternative INSERT AlgorithmDb2 12 offers many performance improvements that can help you to speed up your applications. The Fast Insert algorithm, also called Insert Algorithm 2, is one such improvement, but you have to understand what it is and when it can be helpful. The general idea behind this alternative Insert algorithm…
Happy Thanksgiving 2017Today, November 23rd, in the United States of America, we celebrate Thanksgiving by gathering together with our loved ones and giving thanks for what we have. Typically, this involves celebrations with food, traditionally a big turkey dinner with stuffing, mashed potatoes and gravy, as we watch a …
The Db2 12 for z/OS Blog Series - Part 19: Profile Monitoring ImprovementsThe ability to monitor Db2 using profile tables is a newer, though by no means brand new capability for Db2 DBAs. You can use profile tables to monitor and control various aspects of Db2 performance such as remote connections and certain DSNZPARMs. But this blog post is not intended to describe what…
Db2 Social Advocate of the YearA great big thank you to IBM and IDUG for naming me Db2 Social Advocate of the Year for 2017 at the Db2 Awards ceremony at IDUG in Lisbon this year. I received a nice crystal award and recognition on stage at the event with Surekha, Daniel and Namik. It is always great to be recognized for my …
The Db2 12 for z/OS Blog Series - Part 18: Adaptive IndexesHave you ever had one of those tough queries that was always a challenge to keep performing well? This type of query usually experiences fluctuating filtering. By that I mean that the filtering can change, sometimes dramatically, between executions of the query. Some of the things that can cause fl…