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

 

 
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…
The Db2 12 for z/OS Blog Series - Part 17: A New Privilege for UNLOADDb2 12 for z/OS introduces a new privilege that, when granted, enables a user to be able to unload data using the DB2 IBM UNLOAD utility. In past releases, the SELECT privilege (or other higher level admin privileges) was required to unload data using the UNLOAD utility. But this was less than desir…
See You in Lisbon for the EMEA IDUG DB2 Tech Conference!This year the IDUG EMEA DB2 Tech Conference is being held in Lisbon, Portugal from October 1st through October 5th. Lisbon is a beautiful city with a lot to see and do, so you can plan for a great week of DB2 and analytics education... and then follow it up with a visit to truly remarkable city. Wh…
DB2 for z/OS Coupling Facility SizingJust a very brief blog post today to inform you about something that I ran across doing some web research today... and that is a free, web-based Coupling Facility sizing tool from IBM named CFSIZER. The CFSIZER tool will connect to your live server to get information. You will need to input some v…
The Db2 12 for z/OS Blog Series - Part 16: Db2 Catalog Availability ImprovementsIBM has improved the availability of accessing Db2 Catalog objects when maintenance is being run in Db2 12 for z/OS. This impacts access during CATMAINT and online REORG. This change is largely being driven by dynamic SQL, which is more prevalent but can cause problems. When dynamic SQL statement i…