Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • Dealing with Db2 10-11 Migration Incompatibilities
  • Data Compression Enhanced in Db2 12
  • A New Utility Stored Procedure
  • How to Determine Current Db2 Function Level
  • Db2 for z/OS in the Cloud: What's Ahead
  • Db2: A Small but Significant Change

    If you scan IBM websites, or you're on Twitter looking for news about Db2, or you're following those who have a hand in its direction, you may have noticed something: DB2 is now Db2. The b is lower-case.

    Read More

    Posted: July 11, 2017 |

    Subsystem Parameter Changes in DB2 12

    Following up on last week's post about new and changed with DB2 11 for z/OS subsystem parameters, here's an update about DB2 12 zparms. It’s important to note that, starting with DB2 12, zparms become available at function level at which they're introduced (e.g., function level V12R1M500, V12R1M501, etc.).

    Read More

    Posted: June 27, 2017 |

    New and Changed Subsystem Parameters in DB2 11

    Even though DB2 12 is now available, a fair number of customers are now or have recently migrated from DB2 10 to DB2 11. I know this because I've been getting queries about subsystem parameters (zparms) default changes in DB2 11. So I'll share with you what I've been telling them: IBM, thankfully, documents this information in the Knowledge Center's What’s New guide.

    Read More

    Posted: June 20, 2017 |

    MERGE Statement Enhancements in DB2 12

    The MERGE statement has been around awhile. It was actually among the first topics I covered upon launching DB2utor in 2007.

    Read More

    Posted: June 13, 2017 |

    DB2 12 Technical Workshops

    Many customers have asked when IBM will offer DB2 12 for z/OS education and training. The answer is "very soon." IBM is hosting six one-day workshops around the U.S. in June and July.

    Read More

    Posted: June 06, 2017 |

    DB2 Tools Fix Lists

    The IBM Support page lists all fixes for DB2 and IMS tools products. You'll find summaries of problem descriptions (APARs) and fixes (PTFs), by product and version. The list of APARs can be downloaded as a CSV file and imported into a spreadsheet or database for sorting and filtering.

    Read More

    Posted: May 30, 2017 |

    Parameter Places Retry Claims on Stopped Objects

    This should be obvious to anyone who reads this blog, but each DB2 release has literally dozens of new features and enhancements. I write about them on a weekly basis, but occasionally even I miss something. For instance, I recently learned about a new parameter introduced in DB2 10 that's designed to improve productivity (and reduce frustration) in your test and development environment.

    Read More

    Posted: May 23, 2017 |

    DB2 12 Session Token Support

    If you have a client application using Parallel Sysplex workload balancing (WLB), you'll want to take advantage of session token support in DB2 12. But before I get into this new feature, some quick background.

    Read More

    Posted: May 16, 2017 |

    DB2 12 Debuts Advanced Triggers

    A trigger defines a set of actions that represent the business logic that should occur when INSERT, UPDATE or DELETE operations are performed on a given table or view. Triggers can be used to update tables or generate or transform values to be used to insert or update rows. They can also invoke functions that operate within and outside of DB2.

    Read More

    Posted: May 09, 2017 |

    A Welcome Alternative to Object Ownership Change

    Most DBAs dread changing the ownership of an object. You have to take the database offline, sometimes for an extensive period, to unload, drop, recreate and reload the data, run runstats and--finally--rebind all the application packages. I’m sure many of you have at least a horror story or two about this experience.

    Read More

    Posted: May 02, 2017 |

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