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

 

 
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…
The DB2 12 for z/OS Blog Series – Part 7: Relative Page Number Table SpacesOne of the most significant new features for supporting big data in a DB2 12 environment is relative page numbering (or RPN) for range-partitioned table spaces. You can either create a new RPN range-partitioned table space, or an existing range-partitioned table space can be changed to RPN via an AL…
The DB2 12 for z/OS Blog Series – Part 6: Transferring Ownership of Database ObjectsWhen a database object is created it is given a qualified two-part name. This applies to tables, indexes, table spaces, distinct types, functions, stored procedures, and triggers. The first part is the schema name (or the qualifier), which is either implicitly or explicitly specified. The default sc…
The DB2 12 for z/OS Blog Series - Part 5: Enhancements for Managing Dynamic and Static SQL Most modern application development is done using dynamic SQL. But some features work only with static SQL and others only with dynamic SQL. DB2 12 for z/OS delivers functionality that minimizes the difference between static and dynamic SQL. Dynamic plan stability brings the plan stability feature o…
The DB2 12 for z/OS Blog Series - Part 4: Real Time Statistics HistoryReal Time Statistics (RTS) were introduced in DB2 for z/OS as part of the maintenance stream of Version 7 and IBM has been improving their functionality every release since. For those uninitiated to what RTS are, they are a series of statistics that are automatically maintained by DB2 and can be use…
The DB2 12 for z/OS Blog Series - Part 3: Temporal ImprovementsTemporal tables and time-travel query support was added in DB2 10 for z/OS. With temporal tables a time period is attached to the data to indicate when it was valid or changed in the database. A traditional database stores data implied to be valid at the current point-in-time; it does not track the …
The DB2 12 for z/OS Blog Series - Part 2: Advanced TriggersAs we continue our series on new functionality in DB2 12 for z/OS, today we take a look at the improvements delivered for triggers. Before we dive into the new capabilities, let's briefly review what triggers are. Triggers are event-driven specialized procedures that are stored in, and executed by,…
The DB2 12 for z/OS Blog Series - Part 1: SQL PaginationToday’s blog post kicks off a new series of posts that examine new features and functionality delivered with the latest and greatest new version of DB2 foir z/OS – Version 12. We’ll begin with a nice new feature that should make it easier for programmers writing queries where the program needs…