Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • A Happy 10 Years
    07/18/2017
  • Db2: A Small but Significant Change
    07/11/2017
  • Subsystem Parameter Changes in DB2 12
    06/27/2017
  • New and Changed Subsystem Parameters in DB2 11
    06/20/2017
  • MERGE Statement Enhancements in DB2 12
    06/13/2017
  • Spark Takes Data Analysis to the Next Level

    I must admit that, until very recently, I'd never heard of Spark. But since it was such a big deal at this spring's IDUG NA conference --  an entire day was devoted to it -- I figured I should take some time and learn about it.

    Read More

    Posted: July 19, 2016 |

    RESTful APIs Unlock the Value of z/OS Assets

    If you work on the mainframe using z/OS and haven't heard of RESTful APIs, you need to wake up and smell the coffee. Seriously, even though RESTful APIs are still a fairly new thing, they're already essential. If you don't know about them, ask the people on the distributed side of your business -- who I can assure you already rely upon them -- to help bring you up to speed.

    Read More

    Posted: July 12, 2016 |

    Moving to the DB2 Connect Client

    Recently I’ve fielded a number of questions about the best use of DB2 Connect. Specifically, customers want to know if they should continue to use the DB2 Connect gateway or move applications toward a direct connection using the DB2 Connect client with IBM DB2 data server drivers.

    Read More

    Posted: July 05, 2016 |

    Best Practices for Tuning Local and Group Bufferpools

    During May's IDUG NA conference, I attended a session by IBM's John Campbell. A question came up on how to size and configure local and group bufferpools. John mentioned that a presentation he'd given on this in 2013 is available as a webcast.

    Read More

    Posted: June 28, 2016 |

    Really, We're All Experts Here

    Since joining IBM last year I've been spending more time speaking to user groups. This got me thinking about a post I wrote back in December 2012 on the professional benefits of public speaking. While I'd love for you to read the whole thing, I'll sum it up in four words: You can do this.

    Read More

    Posted: June 21, 2016 |

    developerWorks Community for DB2 Analytics Accelerator

    Last year I noted that IBM was accelerating development of the DB2 Analytics Accelerator. With new maintenance releases coming out about every 3-6 months, it's a challenge to keep up with all the changes. That's why I was excited to discover the IBM developerWorks Community for DB2 Analytics Accelerator.

    Read More

    Posted: June 14, 2016 |

    Plan Management Best Practices for Upgrades

    Each new DB2 release brings enhancements to the SQL optimizer, which is designed to speed response times by improving the access path used to return qualified data to the application. However, these improvements can only be realized by first REBINDing the program package.

    Read More

    Posted: June 07, 2016 |

    Setting Maximum Open Datasets to Greater Than 10,000

    Recently I was sitting in on a customer review and the topic of maximum number of open data sets came up. In DB2 11, the maximum number of open datasets is increased from 10,000 to 200,000.

    Read More

    Posted: May 31, 2016 |

    Using Trusted Context on a Local Connection

    Back in August 2011, I wrote about the use of roles and trusted context in auditing DBA activity. Just recently two separate customers have asked me about how and when to use this. Given that -- not to mention the increased attention on enterprise security, the growing demand for remote access through mobile devices, and the ongoing need to audit all management activities -- this topic is well worth revisiting.

    Read More

    Posted: May 24, 2016 |

    Using Predicate Selectivity Overrides

    Back in 2011, I wrote a series of posts about the evolution of optimization hints and the new DB2 10 statement-level optimization hints.
    Now with DB2 11, the statement-level optimization hint can override the selectivity of predicates for matching statements. This is needed because DB2 cannot estimate filter factors for certain types of predicates. It must rely on inaccurate estimates or even default filter factors to select access paths for statements that use such predicates.

    Read More

    Posted: May 17, 2016 |

    Displaying results 51-60 (of 499)
     |<  <  2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 - 11  >  >|