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
  • Converting from 6- to 10-byte RBA/LRSN

    Db2 11 introduced an option to convert the log relative byte address (RBA) and data sharing log record sequence number (LRSN) from the basic 6-byte format to the extended 10-byte format. Timm Zimmermann of the IBM Db2 for z/OS development "swat team" has a great presentation that goes into the details on the different formats. More importantly, Timm lays out the dwindling time that customers have left to convert their old 6-byte addresses and numbers to the soon-to-be standard 10-byte format.

    Read More

    Posted: January 9, 2018 |

    IBM Z Trial Program

    Mainframe customers running z/OS know all too well the amount of the work that comes with a proof-of-concept. The process requires months of planning among system programmers, security and storage administrators and end users.

    Read More

    Posted: January 3, 2018 |

    The Evolution of Compression: Db2 12

    With each release of Db2, enhancements have been made to improve compression performance, availability and scalability. An important change in Db2 12 is the introduction of the online deferred option, ALTER INDEX COMPRESS YES. This allows you to able compression for an index without causing an outage.

    Read More

    Posted: December 19, 2017 |

    The Evolution of Compression: Db2 11

    This is my fourth installment in a series detailing the history of Db2 compression. As is the case with all previous releases, the Db2 engine takes advantage of the z System hardware platform in Db2 Version 11 for z/OS. With Db2 11 and zEC12 hardware, compression overhead was reduced by as much as 15 percent.

    Read More

    Posted: December 12, 2017 |

    The Evolution of Compression: Db2 10

    My backgrounder on compression continues with Db2 for z/OS Version 10. This release brought compression support to SMF trace data and provided an availability option to activate data compression without placing the table space in REORG pending.

    Read More

    Posted: December 5, 2017 |

    The Evolution of Compression: Db2 9

    Last week I discussed many of the data compression benefits delivered with Db2 8. That release included perhaps the most significant development in data compression in the past decade: since Version 8, Db2 has handled data compression using hardware, not software.

    Read More

    Posted: November 28, 2017 |

    The Evolution of Db2 Compression

    You don't hear much about data compression these days, but recently I encountered a customer who was curious about it. He said his company never used compression due to the belief that because the CPU overhead was too high, but he was wondering if the feature has improved, and if so, how can you determine which tables will benefit from compression?

    Read More

    Posted: November 21, 2017 |

    The Future of Db2 Documentation: More PDFs, More Frequent Updates.

    As I've noted a few times, I maintain a PDF library of Db2 for z/OS documentation. I just find it easier to search PDF docs as opposed to looking up information online.

    Read More

    Posted: November 14, 2017 |

    IBM Champions: Nomination Period Ends Soon

    I've been an IBM employee for the past two years. Prior to that, I was an IBM Champion.

    Read More

    Posted: November 7, 2017 |

    Planning for a Db2 for z/OS Upgrade: Application Testing

    I recently received this question about upgrading to Db2 12:
    "Our shop will be upgrading to DB2 V12 z/OS and typically we do extensive testing with any new release in both CM and NFM. If we will not be using any of the new functionalities in our applications, and we test in CM (function level 100), do we really need to test again in NFM (function level 500)?"

    Read More

    Posted: October 31, 2017 |

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