Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • The Evolution of Db2 Compression
    11/21/2017
  • The Future of Db2 Documentation: More PDFs, More Frequent Updates.
    11/14/2017
  • IBM Champions: Nomination Period Ends Soon
    11/07/2017
  • Planning for a Db2 for z/OS Upgrade: Application Testing
    10/31/2017
  • Contest Introduces Students to the Mainframe
    10/24/2017
  • Data Compression Enhanced in Db2 12

    Db2 12 function level V12R1M500 introduces the capability to compress LOB table space using zEnterprise data compression (zEDC) hardware.

    Read More

    Posted: September 12, 2017 |

    A New Utility Stored Procedure

    The stored procedure DSNUTILS has been deprecated as of Db2 12. It's used to call utility program DSNUTILB using EBCIDIC encoded parameters. While your application will continue to function when DSNUTILS is called, it could be removed from future releases. For this reason, you should replace DSNUTILS with either of two current support procedures, DSNUTILU and DSNUTILV.

    Read More

    Posted: September 05, 2017 |

    How to Determine Current Db2 Function Level

    With the introduction of continuous delivery making it possible for customers to put new features into production through regular maintenance, awareness of Db2 function levels takes on greater importance. So how do you determine what level you're at and what level of maintenance has been applied?

    Read More

    Posted: August 30, 2017 |

    Db2 for z/OS in the Cloud: What's Ahead

    Troy Coleman explores how Db2 for z/OS on the IBM mainframe fits into the cloud.

    Read More

    Posted: August 21, 2017 |

    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 08, 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 01, 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 |

    Displaying results 11-20 (of 517)
     |<  <  1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10  >  >|