Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • Subsystem Parameter Changes in DB2 12
  • New and Changed Subsystem Parameters in DB2 11
  • MERGE Statement Enhancements in DB2 12
  • DB2 12 Technical Workshops
  • DB2 Tools Fix Lists
  • The Page Residency Time Metric

    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.

    Read More

    Posted: February 16, 2016 |

    Options for Storing ARRAY Data in a DB2 Table

    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.

    Read More

    Posted: February 09, 2016 |

    DB2 Certification Preparation for IDUG NA 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.

    Read More

    Posted: February 02, 2016 |

    Recent XML Enhancements

    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.

    Read More

    Posted: January 26, 2016 |

    DB2 11 Improvements to Drop Pending Changes

    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.

    Read More

    Posted: January 19, 2016 |

    DB2 11 Enables Auto-Recovery of Indexes from GRECP/LPL Status

    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.

    Read More

    Posted: January 12, 2016 |

    Data Server Manager Now Supports DB2 for z/OS

    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.

    Read More

    Posted: January 05, 2016 |

    Temporal Special Registers Simplify 'Time Travel'

    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.

    Read More

    Posted: December 22, 2015 |

    BIND/DDL Thread Break-In

    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.

    Read More

    Posted: December 15, 2015 |

    Identifying Excessive DSNDB07 Sort Work Usage

    During a recent DB2 user group meeting, a question came up about identifying applications that consume excessive amounts of DB2 DSNDB07 sort work. As the presenter, IBM's Robert Catterall, noted, this capability is available in DB2 11 through some new system parameters.

    Read More

    Posted: December 08, 2015 |

    Displaying results 71-80 (of 497)
     |<  <  4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 - 12 - 13  >  >|