Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • A Goodbye, and Many Thanks
    05/29/2018
  • IBM Redbook: Db2 12 for z Optimizer
    05/22/2018
  • Extended Plan Management and Migration
    05/15/2018
  • Submitting an RFE
    05/08/2018
  • Db2 12 for z/OS Tools Compatibility
    05/01/2018
  • A Goodbye, and Many Thanks

    After 28 years of working with IBM Db2 for z, and almost 11 years writing the DB2utor blog for IBM Systems Magazine, I’m saying goodbye.

    Read More

    Posted: May 29, 2018 |

    IBM Redbook: Db2 12 for z Optimizer

    I was recently asked about the Db2 zparm, NPGTHRSH. Admittedly, I knew little about it. The first place I always go to learn about zparms is the Db2 installation and migration manual. Unfortunately, the manual wasn't much help in this case. So I did some searching and found this IBM Redbook: "Db2 12 for z Optimizer."

    Read More

    Posted: May 22, 2018 |

    Extended Plan Management and Migration

    I’ve written often about plan management over the years. Most recently I wrote about a study of how customers are setting Db2 zparm.

    Read More

    Posted: May 15, 2018 |

    Submitting an RFE

    I was recently asked about submitting a request for enhancement (RFE) for Db2 for z/OS. The answer is simple: Just go to IBM developerWorks and conduct an appropriate search (e.g., "Db2 for z").

    Read More

    Posted: May 08, 2018 |

    Db2 12 for z/OS Tools Compatibility

    Before migrating from Db2 11 to Db2 12 for, you must verify that all IBM Db2 tools are supported. In this blog, I've listed the different product areas and supported version of each product.

    Read More

    Posted: May 01, 2018 |

    Additional Support for JSON

    The JSON_VAL function provides an SQL interface to extract and retrieve JSON data into SQL data types from BSON objects. BSON is a standardized binary representation format for serializing JSON documents. It allows for fast traversal of JSON documents.

    Read More

    Posted: April 24, 2018 |

    Previewing the Upcoming IDUG Conference

    The annual IDUG North America conference is only two weeks away. This year's event is set for April 29 to May 3 in Philadelphia.

    Read More

    Posted: April 17, 2018 |

    Continuous Delivery the Subject of New Redbook

    IBM recently released a new Redbook covering the topic of continuous delivery. In this blog post, I'll provide details regarding the key points about this publication.

    Read More

    Posted: April 10, 2018 |

    Upgrading Data Server Clients and Drivers for Db2 12

    As you move to new function levels in Db2 for z/OS Version 12, you'll need to upgrade your remote Db2 data server clients and drivers. IBM's Db2 12 Knowledge Center provides instructions.

    Read More

    Posted: April 03, 2018 |

    A New Addition to the IBM z Trial Program

    I'm sometimes asked about options for getting hands on experience with Db2 for z/OS. Basically, I know of only one option, but it's an excellent one: the IBM z Trial Program.

    Read More

    Posted: March 27, 2018 |

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