You are currently on IBM Systems Media’s archival website. Click here to view our new website.

Troy Coleman

Troy L Coleman

Bookmark and Share

Recent Posts

  • A Goodbye, and Many Thanks
    May 29, 2018
  • IBM Redbook: Db2 12 for z Optimizer
    May 22, 2018
  • Extended Plan Management and Migration
    May 15, 2018
  • Submitting an RFE
    May 8, 2018
  • Db2 12 for z/OS Tools Compatibility
    May 1, 2018
  • 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 9, 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 2, 2017 |

    DB2 12 Catalog Availability Improvements

    During the early releases of DB2, enterprises (specifically DBAs) would restrict dynamic SQL from running in their production OLTP environments. This choice stemmed primarily from the likelihood of ad hoc OLAP queries adversely impacting the performance of OLTP applications. Of course, over the next 20-plus years, this issue has been largely mitigated by the widespread adoption of dynamic SQL. Dynamic SQL continues to be a focus of DB2 development, and DB2 12 features an important enhancement in the area of catalog availability.

    Read More

    Posted: April 25, 2017 |

    Improved EDM Pool Management in DB2 12

    Environmental descriptor manager (EDM) pools  contain skeleton application plans and packages, database descriptors, and cached dynamic SQL statements.

    Read More

    Posted: April 18, 2017 |

    Machine Learning Applications

    The recent announcement of IBM Machine Learning on z/OS is significant for a couple of reasons. First, it's another example of IBM's ongoing investment to the mainframe. Beyond that, it's important for anyone who supports software installation, database administration and analytics on z/OS.

    Read More

    Posted: April 11, 2017 |

    Adding a Partition Between Logical Partitions

    Designing and sizing table space requires DBAs to  make numerous determinations. How many rows per day will be inserted/updated/deleted? How will the data be processed? What is the criteria to determine active versus historical data? How long will the data (active and historical) need to be stored before it will be deleted?

    Read More

    Posted: April 4, 2017 |

    DB2 12 Pending Column Alterations

    Prior to DB2 12 function level V12R1M500, altering column attributes such as data type, precision, scale or length would occur instantly.

    Read More

    Posted: March 28, 2017 |

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