Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • Enhancements for Db2 Native REST Web Services
  • Converting from 6- to 10-byte RBA/LRSN
  • IBM Z Trial Program
  • The Evolution of Compression: Db2 12
  • The Evolution of Compression: Db2 11
  • 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 |

    Avoiding Indirect References in DB2 11

    When designing the physical structure “table space” used to store table data, DBAs must understand the types of processing that will occur against the table. Will the table have lots of inserts, updates or deletes, or is it mainly read-only? Will the table rows be variable length due to either VARCHAR columns or data compression? Answering these questions helps DBAs choose the appropriate table space storage options during the creation.

    Read More

    Posted: February 24, 2015 |

    How to Control Statistics Feedback

    DB2 11 introduced a feature to help identify missing or conflicting statistics that can help the optimizer choose a more efficient access path. I wrote about this feature here, however, I've since learned that two DB2 subsystem parameters can be used to reduce the amount of information collected and control how frequently information is written to memory.

    Read More

    Posted: February 17, 2015 |

    DB2 Resource Limit Facility

    With early DB2 releases, many customers would restrict dynamic SQL on a production online transaction processing system (OLTP). DBAs had no way to lock in the access path to avoid unexpected performance problems that could occur due to ad hoc queries impacting business critical applications. To help provide some controls and allow access to production data, DB2 provides a resource “governor” through the resource limit facility (RLF). The RLF can be set to cancel the query once a given amount of processor service units (CPU) have been consumed. This is known as “reactive” governing.

    Read More

    Posted: February 10, 2015 |

    IBM z13 Announcement Review

    If you missed out on IBM's live streaming of the System z13 announcement, do yourself a favor and watch the replay. Though the entire events lasts almost three hours, it's well worth your time.

    Read More

    Posted: February 03, 2015 |

    Displaying results 141-150 (of 524)
     |<  <  11 - 12 - 13 - 14 - 15 - 16 - 17 - 18 - 19 - 20  >  >|