Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • DB2 12 Catalog Availability Improvements
    04/25/2017
  • Improved EDM Pool Management in DB2 12
    04/18/2017
  • Machine Learning Applications
    04/11/2017
  • Adding a Partition Between Logical Partitions
    04/04/2017
  • DB2 12 Pending Column Alterations
    03/28/2017
  • The Ever-Diminishing Need for REORGs

    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.

    Read More

    Posted: February 23, 2016 |

    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 |

    Displaying results 61-70 (of 488)
     |<  <  3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 - 12  >  >|