Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • Using Installation SYSOPR Authority
    03/21/2017
  • Converting DBRMs to Packages in DB2 12
    03/14/2017
  • DB2 12 Enhancements to System Profiles
    03/07/2017
  • DB2 12 Active Logs Greater than 4 GB
    02/28/2017
  • DB2 12 Webinar Series
    02/21/2017
  • z13 Designed for Cloud, Analytics and More

    As a follow-on to last week's post about hosted DB2, I'd like to tell you about a new IBM Redbook.

    Read More

    Posted: June 09, 2015 |

    Hosted DB2

    Software as a service (SaaS) is a way of delivering applications over the Internet. Rather than hire an in-house staff to install and maintain the software, company developers simply access the tools they need online.

    Read More

    Posted: June 02, 2015 |

    DB2 11 Improves Duplicate Removal in SQL Result Set

    When DBAs tune SQL, one of their priorities is to find SQL that invokes sorts, because sorts are expensive.

    The statements that typically cause sorts are SELECT DISTINCT and GROUP BY. Other causes of sorts include the use of MAX/MIN aggregate functions and certain non-correlated subqueries (not transformed). The latest DB2 release, DB2 11, is designed to bring improved query performance to applications that use these types of statements.

    Read More

    Posted: May 26, 2015 |

    A Great Time at IDUG NA 2015

    The recent IDUG NA 2015 conference was, in my opinion, the best IDUG event in years. Attendance was way up, and you could feel the energy and excitement during the sessions. Maybe best moment came out of the opening session. When the first-time attendees in the audience were asked to identify themselves, by my count about 30 to 40 hands went up.

    Read More

    Posted: May 19, 2015 |

    Using SQL in a UTS Conversion

    Last week I wrote about converting simple table spaces to partition by growth (PBG) Universal Table Spaces (UTS). This week I'll share some SQL that can be used in this conversion process.

    Read More

    Posted: May 12, 2015 |

    Revisiting Universal Table Space

    After seeing recent discussions about converting simple or segmented table space to partition-by-growth (PBG) universal table space (UTS) on the DB2 mailing list,. I thought I'd cover this topic. I've previously written about UTS, but it's been awhile. My first UTS post was back in 2007. Then in 2009 I wrote about IBM's migration path to UTS.

    Read More

    Posted: May 05, 2015 |

    A Look at DB2 for z/OS OLAP Functions

    I was recently asked how to calculate the moving average for a given metric. To be honest, I've only done minimal work with OLAP functions, so I consulted the SQL Reference guide for help. I need to see examples to get an understanding of how things work; unfortunately, those were lacking in the reference guide.

    Read More

    Posted: April 28, 2015 |

    Minimizing the Processing Cost of DB2 Traces

    In a recent blog post, Denis Tronin discussed DB2 for z/OS performance monitoring.
     
    Denis provides a nice introduction to this topic by examining the different types of trace information. To me, the single most important take-away comes toward the end of the article, when he says: “It is important to understand that traces bring an overhead to your DB2 subsystem, so they should be used wisely.”

    Read More

    Posted: April 21, 2015 |

    Fun with SQL

    In writing about the upcoming IDUG DB2 tech conference last week, I noted that the event includes expanded content for developers. This is no isolated occurrence. The IDUG organization has been expanding its focus to include greater education and support for developers (in addition to its traditional audience of DB2 systems programmers and database administrators). With this in mind, I want to mention the "online SQL challenge" that's going on throughout April.
     

    Read More

    Posted: April 14, 2015 |

    A Look at the Upcoming IDUG NA Conference

    The IDUG DB2 North American Tech Conference is May 4-8 in Philadelphia. This year's conference has been expanded by a day to more conveniently spread out the technical education and labs.

    Read More

    Posted: April 07, 2015 |

    Displaying results 91-100 (of 483)
     |<  <  6 - 7 - 8 - 9 - 10 - 11 - 12 - 13 - 14 - 15  >  >|