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. .

 

 
The Db2 12 for z/OS Blog Series - Part 22: Function Levels 501 and 502 (Continuous Delivery) If you have heard anything about Db2 Version 12 chances are that you have heard about continuous delivery. Instead of waiting 2 to 3 years for a new version of Db2 to be released, new functionality will be continuously delivered on a regular basis. The idea is to bring Db2 into the modern age of de…
Improving Performance by Caching Select Statement Results A significant trend in the database world these days is moving more data management and processing into memory. If you can bypass disk I/O you can achieve tremendous performance gains. There are many reasons for this, but of course, the most important reason is that disk access is much slower than …
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…