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
  • System z Apprentice Program

    Long-time readers of this blog know I've often discussed the mainframe skills shortage and cited various initiatives that aim to attract the next generation of talent. I came across new organization while attending last month's SHARE conference: LEAD-IT (Leadership, Empowerment, Apprenticeship and Diversity in Information Technology).

    Read More

    Posted: August 15, 2017 |

    New Function Level 501: Continuous Delivery Makes its First Delivery

    Db2 12 introduces continuous delivery. Making it possible for customers to rapidly put new features into production through normal maintenance is huge for the mainframe's continued viability. Businesses will now have a more positive view of running applications on DB2 for z/OS because they know they'll no longer have to wait years for required features.

    Read More

    Posted: August 8, 2017 |

    Db2 12 Automated Statistics Collection

    Terry Purcell, who leads the Db2 Optimizer team, recently told me that at least 80 percent of all SQL access path performance problems reported to IBM could be avoided if customers had collected proper runstats.

    Read More

    Posted: August 1, 2017 |

    The New z/14 and Pervasive Encryption

    Last week IBM unveiled the newest mainframe system--the z14. As noted in the announcement letter, the z14 is intended to provide the cornerstone for the "trust economy."

    Read More

    Posted: July 25, 2017 |

    A Happy 10 Years

    Ten years ago this week--July 16, 2007, to be specific--this blog published its first post, on Universal Table Space. IBM Systems Magazine had asked me if I would consider writing a blog about Db2 for z/OS. I'm not exaggerating when I say I felt like the luckiest guy in the world.

    Read More

    Posted: July 18, 2017 |

    Db2: A Small but Significant Change

    If you scan IBM websites, or you're on Twitter looking for news about Db2, or you're following those who have a hand in its direction, you may have noticed something: DB2 is now Db2. The b is lower-case.

    Read More

    Posted: July 11, 2017 |

    Subsystem Parameter Changes in DB2 12

    Following up on last week's post about new and changed with DB2 11 for z/OS subsystem parameters, here's an update about DB2 12 zparms. It’s important to note that, starting with DB2 12, zparms become available at function level at which they're introduced (e.g., function level V12R1M500, V12R1M501, etc.).

    Read More

    Posted: June 27, 2017 |

    New and Changed Subsystem Parameters in DB2 11

    Even though DB2 12 is now available, a fair number of customers are now or have recently migrated from DB2 10 to DB2 11. I know this because I've been getting queries about subsystem parameters (zparms) default changes in DB2 11. So I'll share with you what I've been telling them: IBM, thankfully, documents this information in the Knowledge Center's What’s New guide.

    Read More

    Posted: June 20, 2017 |

    MERGE Statement Enhancements in DB2 12

    The MERGE statement has been around awhile. It was actually among the first topics I covered upon launching DB2utor in 2007.

    Read More

    Posted: June 13, 2017 |

    DB2 12 Technical Workshops

    Many customers have asked when IBM will offer DB2 12 for z/OS education and training. The answer is "very soon." IBM is hosting six one-day workshops around the U.S. in June and July.

    Read More

    Posted: June 6, 2017 |

    Displaying results 41-50 (of 543)
     |<  <  1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10  >  >|