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 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…
The Tao of DB2 - Part 15: Putting it all together!We rejoin our soon-to-be-retiring DBA and the intern who is tasked with replacing him as the old DBA continues to teach the young intern about Tao and DB2. "Soon, I will be retiring, and all of this will be yours," said the expert DBA. "Are you ready?" "I am trying my best," said the intern. "Do y…
Happy Holidays 2016It is that time of year again. When we all take some time to pause and spend time with our family, friends and loved ones. We take time off of work to celebrate and reflect on the past year... and to welcome the new year. No matter what holiday tradition you celebrate, I wish you an enjoyable holid…
The Tao of DB2 - Part 14: A Short Lesson on WisdomAfter a long day of dealing with problems the DBA and his intern were readying themselves to head home for the evening. The mentor glanced over at his trainee and saw that something was troubling him. "You seem to be troubled," noted the DBA. “I guess so," replied the intern. "We did a lot today…