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

 

 
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…
The Db2 12 for z/OS Blog Series - Part 15: DSN1COPY and Data Validation ImprovementsIf you’ve worked with Db2 for z/OS for awhile (note to IBM: I still have a problem with that lower case "b" but I'm trying), particularly as a DBA, you’ve almost certainly had the opportunity to use the DSN1COPY offline utility, sometimes called the Offline Copy utility. DSN1COPY can be used in…
The DB2 12 for z/OS Blog Series - Part 14: Improved MERGE SQL StatementA very common requirement for application developers is to be able to read through new data – from a table, a file or as entered by an end user – and either INSERT the data if it does not already exist or UPDATE data that does exist with new values. The ANSI SQL standard defines the MERGE state…