You are currently on IBM Systems Media’s archival website. Click here to view our new website.

Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • A Goodbye, and Many Thanks
    May 29, 2018
  • IBM Redbook: Db2 12 for z Optimizer
    May 22, 2018
  • Extended Plan Management and Migration
    May 15, 2018
  • Submitting an RFE
    May 8, 2018
  • Db2 12 for z/OS Tools Compatibility
    May 1, 2018
  • Big News About DB2 11 for z/OS Certification

    IBM just made available a new DB2 for z/OS certification test, DB2 11 Fundamentals for z/OS (C2090-320). To put it mildly, this is great news.

    Read More

    Posted: March 29, 2016 |

    Access Database Command Improvements

    DB2 11 brings a number of enhancements to the ACCESS DATABASE command. Before getting into those improvements, I want to discuss how the ACCESS DATABASE command is used.

    Read More

    Posted: March 22, 2016 |


    At times a transaction executing on DB2 for z/OS could cause resource problems with other transactions. It could be driving up CPU usage, holding locks and blocking critical transactions, or causing a number of other issues.

    Read More

    Posted: March 15, 2016 |

    DB2 11 Autonomous Procedures

    DB2 11 introduced autonomous procedures, which are native SQL procedures that commit independently from the calling application. They execute under their own units of work, separate from the calling program.

    Read More

    Posted: March 8, 2016 |

    RESTful Software Installation on z/OS

    Traditionally, the mainframe hasn't been viewed as a platform for modern software development. Of course the reality is that IBM z Systems has embraced an array of new technologies over the past several years, while at the same time strengthening its already-world class availability and security capabilities.

    Read More

    Posted: March 1, 2016 |

    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 9, 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 2, 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 |

    Displaying results 111-120 (of 543)
     |<  <  8 - 9 - 10 - 11 - 12 - 13 - 14 - 15 - 16 - 17  >  >|