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 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…
The IBM z14: There's a New Mainframe Coming!Today, July 17, 2017, IBM announced the next iteration of its stalwart mainframe hardware, the IBM z14. The news comes a little more than two years since the previous version, the IBM z13. The hardware will be generally available later this year. The big news is that IBM delivering pervasive encry…
The DB2 12 for z/OS Blog Series - Part 13: DRDA Fast LoadHave you ever had a situation where you needed to load data into a DB2 table, but the file with the data was not on the mainframe? So you had to PTF that data to the mainframe and then load it. Well, with DB2 12 for z/OS you get a new capability to load the data to the mainframe without moving the f…
The DB2 12 for z/OS Blog Series - Part 12: New Built-in FunctionsAs with most new releases of DB2 for z/OS, at least lately, there are several new built-in functions (or BIFs) that have been added. DB2's BIFs are used to translate data from one form or state to another. They can be used to overcome data format, integrity and transformation issues when you are rea…
BMC and CA: Impending Nuptials?Have you heard the one about BMC Software acquiring CA, Inc.? At first glance, to those of us who have been in the business for awhile, that sentence may look odd? Those two have been slugging it out in the mainframe software world for decades now. And to be fair, not just the mainframe world, but…
The DB2 12 for z/OS Blog Series - Part 11: Enhanced Support for ArraysThe ARRAY data type was added to DB2 in the last release (Version 11) with the ability to define both ordinary arrays or associative arrays. An ordinary array has a user-defined number of elements that are referenced by their ordinal position in the array. An associative array has no user-defined nu…
The DB2 12 for z/OS Blog Series - Part 10: Improved EDM Memory ManagementEDM pool management is improved in DB2 12 for z/OS, which is especially beneficial to organizations running many concurrent threads with with large EDM pools specified. Prior to DB2 12, the EDMDBDC, EDMSTMTC and EDM_SKELETON_POOL DSNZPARM values were used to allocate DBD cache, dynamic statement ca…
Hope to See You in Anaheim for the IDUG DB2 Tech Conference! This year the IDUG North American DB2 Tech Conference is being held in Anaheim, CA from April 30th through May 4th. That means we'll be near Disneyland, so you can plan for a great week of DB2 and analytics education... and then follow it up with a visit to Mickey. Whether or not you care about D…
The DB2 12 for z/OS Blog Series - Part 9: Piece-wise DeletionAdding the FETCH FIRST clause to the DELETE statement at first appears to be a very simple enhancement, but upon closer examination it is really quite powerful. Prior to DB2 12 for z/OS, the FETCH FIRST n ROWS ONLY clause could be specified on a SELECT statement. The clause had two impacts:the numb…
The DB2 12 for z/OS Blog Series – Part 8: Index FTBsIBM has delivered many new in-memory processing capabilities in DB2 12 for z/OS, so much so that Gartner has dubbed DB2 12 for z/OS an in-memory DBMS. This is good news for those of us in the mainframe world looking to utilize memory to improve the performance of our database applications. Perhaps t…