In December 2014 I wrote a post titled, “Are Reorgs Still Necessary?” In it I discussed how IBM Easy Tier storage technology may eliminate the need to run REORGs. This week I want to revisit this question, framing the discussion with information from an IBM Redpaper I initially reviewed in August 2014.
Posted: February 23, 2016 |
During my years as a DB2 systems programmer, I spent time tuning buffer pools. A key metric I'd use is buffer pool hit ratio, which is a measure of how often a page access (a getpage) is satisfied without requiring an I/O operation. However, it's been a long time since I've worked on buffer pools, something I was reminded of when I read IBMer John Campbell's presentation on page residency time.
Posted: February 16, 2016 |
I’ve heard some confusion around ARRAY, the new user-defined data type (UDT) introduced with DB211, and the preferred way (read: easiest) to store an ARRAY of data into a column on a DB2 table.
Posted: February 09, 2016 |
It's not too early to plan on attending IDUG DB2 Tech Conference in Austin, Texas, May 23-26. If you are going to the conference, you should consider taking a DB2 certification test. One of the great benefits of attending IDUG is that IBM sponsors up to two certifications to help attendees get certified for DB2.
Posted: February 02, 2016 |
In general, XML enhancements in DB2 11 involve improving native XML language support using XQuery. This is designed to save developers the effort of converting to SQL/XML syntax. While differences remain between DB2 for LUW and DB2 for z/OS, improvements continue on the mainframe side.
Posted: January 26, 2016 |
Ease of use was a primary focus of IBM in its development of DB2 11. Another example of this comes with the new capability added to the DROP PENDING CHANGES clause.
Posted: January 19, 2016 |
During a recent reading of the DB2 11 Administration guide, I learned that another autonomic feature has been added to improve availability. Now indexes that are in a group buffer pool recovery pending (GRECP) or logical page list (LPL) status can be recovered automatically.
Posted: January 12, 2016 |
In October I covered the announcement of IBM Data Server Manager. In a sense, I jumped the gun, because the initial release supported only DB2 for LUW. But given the significance of this product, I was excited to write about it -- plus I knew that the DB2 for z/OS version would be out soon. Indeed, Data Server Manager 1.1.2 was released on Dec. 12 with DB2 for z/OS support.
Posted: January 05, 2016 |
DB2 10 introduced the concept of "time travel" queries. When DB2 11 came out, I wrote a post titled, "Time Travel Views Not Supported in DB2 11." I should clarify that DB2 11 does support time travel views through the use of new temporal special registers.
Posted: December 22, 2015 |
DB2 10 for z/OS introduced high-performance database access threads (DBATs). Also known as DDF threads, DBATs are used to execute packages bound with option RELEASE(DEALLOCATE). For an excellent in-depth look at this topic, IBMer Robert Catterall examines some of the system parameters you should be aware of before implementing DBATs.
Posted: December 15, 2015 |