Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • Learning to Code Efficient Db2 SQL
  • The Latest on Data Server Manager
  • Big Changes for Db2 Analytics Accelerator
  • Data Virtualization on z/OS
  • A Look at Upcoming Db2 Conferences
  • 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 05, 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 07, 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 |

    Contest Introduces Students to the Mainframe

    For years I've discussed the aging mainframe workforce and the need to get young IT pros onto the platform. I've written about zNextGen, the great SHARE program that helps recent graduates who are entering the workforce connect with one another. I've also covered the IBM Academic Initiative, which works with high schools and universities and provide the curriculum and access to systems educators need to teach mainframe skills to the next generation. The Academic Initiative has provided mainframe training and resources to students at more than 1,000 schools in 70 countries.

    Read More

    Posted: October 24, 2017 |

    Db2 12 Brings Enhanced Data Validation Capabilities to DSN1COPY

    This post is outlines DSN1COPY, which is a stand-alone utility to copy Db2 VSAM data sets.

    Read More

    Posted: October 17, 2017 |

    Db2 12 Avoids CPU and I/O During PIT Recovery

    Traditionally when a point-in-time (PIT) recovery is needed, all the tables that have a referential relationship will be recovered simultaneously to the same PIT. The problem is there's no way to determine whether one or more parent tables or related child tables have changed. Besides substantially lengthening the recovery time, this can consume a lot of CPU resources, which of course drives up recovery costs.

    Read More

    Posted: October 10, 2017 |

    DBaaS and Streamlined Development

    The term Database-as-a-Service (DBaaS) can convey different things. You may think of off-premise cloud deployment of a DBMS, like IBM's Db2 on Cloud (formerly known as dashDB).

    Read More

    Posted: October 03, 2017 |

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