Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • Dealing with Db2 10-11 Migration Incompatibilities
    09/19/2017
  • Data Compression Enhanced in Db2 12
    09/12/2017
  • A New Utility Stored Procedure
    09/05/2017
  • How to Determine Current Db2 Function Level
    08/30/2017
  • Db2 for z/OS in the Cloud: What's Ahead
    08/21/2017
  • 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 |

    DB2 Analytics Accelerator for z/OS Resources

    I’ve written extensively about the DB2 Analytics Accelerator. My most recent post, from January, covered IBM's future plans for the product.

    Because the accelerator is becoming a critical tool for DB2 professionals, I wanted to share a couple of resources I’ve recently come across. The first is the IBM Support Portal for DB2 Analytics Accelerator for z/OS. It contains dozens of links to IBM documentation about the accelerator (installation, configuration, maintenance, education, etc.) and business analytics in general.

    Read More

    Posted: March 31, 2015 |

    Authorization Checking During Auto Rebind

    Last week I discussed the factors that cause a package to be marked invalid and go through AUTOREBIND. My recommendation was to always REBIND the package manually once the changes have been implemented.

    Read More

    Posted: March 24, 2015 |

    Changes that Invalidate Packages

    Certain DB2 changes can cause your application package to be marked invalid. When this occurs, the VALID column of SYSIBM.SYSPACKAGES will contain a value of other than “Y.” Then the next time the package is executed, automatic rebind will occur. If the rebind is unsuccessful, the package remains invalid and the OPERATIVE column is changed to “N.” At this point when the package is executed, an SQLCODE -904 will be returned with a reason code of 00E30305.

    Read More

    Posted: March 17, 2015 |

    BIF_COMPATIBILITY Eases Data-Conversion Process

    Software vendors that develop products for the IBM z/OS mainframe know that when new DB2 features are introduced, the old features must still be able to function so that applications running on z/OS aren't affected. Over the past few releases, controlling these changes and their impact on applications has made DB2 migrations much more difficult. Some customers have delayed migrations for years, while others that have migrated needed a year or more to implement the necessary changes and conduct application testing.

    Read More

    Posted: March 10, 2015 |

    Time Travel Views Not Supported in DB2 11?

    In 2012 I wrote about new DB2 10 support for temporal tables. Just recently, while reading the DB2 11 for z/OS Application Programming and SQL Guide, I came across this disturbing paragraph found on Page 4 in Chapter 1, under the sub-topic, “Views, materialized query tables, and SQL table functions with period specifications”:

    Read More

    Posted: March 03, 2015 |

    Displaying results 121-130 (of 508)
     |<  <  9 - 10 - 11 - 12 - 13 - 14 - 15 - 16 - 17 - 18  >  >|