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

 

 
Every Db2 Article I've WrittenI've written a lot of articles on Db2 topics over the years and I try to keep everything I've written available over the web. Some of the older articles may not be as applicable today as they were in the past, but I still try to keep them available in case somebody remembers reading something and th…
Will I See You at SHARE in Fort Worth 2020? I hope you’ve already made your plans to be there, but if you haven’t there’s still time to get your manager’s approval, make your travel plans, and be where all the in-the-know IT folks will be the last week of February, the SHARE conference in Fort Worth, Texas! If you’ve ever attended …
IBM Gold Consultant for Data and AI :: 2020I am proud to announce that I will be continuing as an IBM Gold Consultant for Data and AI in 2020. For those of you who do not know what an IBM Gold Consultant is... the IBM Gold Consultant program is an elite group of independent consultants with vast experience in IBM data repositories, unifie…
Db2 11 for z/OS End of Support Coming This Year (2020)What better way to start off the New Year than with a quick blog post to remind everybody that the end of service deadline is looming for Db2 11 for z/OS... and that means it is time for you to move to Db2 12 for z/OS this year! Version 11 of our favorite DBMS was made generally available way back…
Planning Your Db2 Performance Monitoring Strategy The first part of any Db2 performance management strategy should be to provide a comprehensive approach to the monitoring of the Db2 subsystems operating at your shop. This approach involves monitoring not only the threads accessing Db2 and the SQL they issue, but also the DB2 address spaces. Ther…
High Level Db2 Indexing Advice for Large and Small Tables In general, creating indexes to support your most frequent and important Db2 SQL queries is a good idea. But the size of the table will be a factor in decided whether to index at all and/or how many indexes to create. For tables more than 100 (or so) pages, it usually is best to define at least one…
A Guide to Db2 Application Performance for Developers: A Holiday Discount!Regular readers of my blog know that I have written a couple of Db2 books, including DB2 Developer's Guide, which has been in print for over 20 years across 6 different editions. But you may not be aware that I recently wrote a new Db2 book, this time focusing on the things that application programm…
Happy Thanksgiving 2019Just a quick post today to wish all of my readers in the US (and everywhere, really) a very Happy Thanksgiving. Thanksgiving is a day we celebrate in the USA by spending time with family, eating well (traditionally turkey), and giving thanks for all that we have and hold dear. Oh... and also for…
Db2 12 for z/OS Function Level 506Late last month, October 2019, IBM introduced a new function level, FL506, for Db2 12 for z/OS. There are two significant impacts of this new function level: Alternative function names supportSupport for implicitly dropping explicitly created table spacesThe first impact, support for additional, al…
Have You Considered Speaking at the IDUG Db2 Technical Conference? You should!The 2020 North American Db2 Technical Conference is being held in Dallas, TX the week of June 7th. And the call for papers is still open and IDUG is looking for Db2 folks who want to share their experiences with Db2. You can talk about a project you worked on, an experience you had tuning or optimiz…