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
  • Continuous Delivery and DB2 12 Function Levels

    I recently attended a regional DB2 user group meeting, and the subject of continuous delivery came up frequently. People were wondering about the process of adding new features being added through the maintenance stream and how to fallback if it's determined that the new features are causing a problem.

    Read More

    Posted: November 29, 2016 |

    DB2 12 for z/OS Manuals Available

    Long-time readers of DB2utor know that I prefer using the DB2 manuals in PDF form as opposed to the electronic versions available from the IBM Knowledge Center. After hearing rumors that IBM would no longer make documents available in PDF, I was very pleased to find the DB2 12 for z/OS manuals available in PDF form.

    Read More

    Posted: November 22, 2016 |

    Cloud's Future on the Mainframe

    In last week's IBM DB2 Analytics Accelerator for z/OS V6.1 announcement summary, I mentioned that I'd get to the other piece of news, which is the introduction of IBM DB2 Analytics Accelerator on Cloud V1.1.

    Read More

    Posted: November 15, 2016 |

    A Look at Analytics Accelerator for z/OS V6.1

    On Oct. 18, IBM announced the latest version of DB2 Analytics Accelerator for z/OS as well as a new product, IBM DB2 Analytics Accelerator on Cloud.

    Read More

    Posted: November 08, 2016 |

    DB2 12 Takes Inserts to the Millions Per Second

    When a high number of inserts arrive in a non-clustered way at the end of a table space or table space partition, it's known as a "journaling pattern." While I personally haven't worked on this type of application, Dan Luksetich of  DanL Database Consulting has, and he wrote this white paper about it.

    Read More

    Posted: November 01, 2016 |

    DB2 12 REORG To Support EasyTier

    Storage technology keeps improving, which is obviously a good thing. However, DBAs may not always be up to date on these changes and how they impact application performance. (In our defense, we DBAs have a lot on our plates!) I started writing about this two years ago, and followed up by asking the potentially contentious question, “Are REORGs Still Necessary?”

    Read More

    Posted: October 25, 2016 |

    DB2 12 for z/OS Tools: What's Improved

    Following up on last week's DB12 for z/OS announcement, I want to discuss the supporting tools, which include the DB2 utilities.

    Read More

    Posted: October 18, 2016 |

    Thoughts on DB2 12

    Last week IBM announced DB 12 for z/OS and its Oct. 21 general availability. Of course there's a lot to dissect -- and I'll certainly be getting into specifics of DB2 12 features in the weeks and months ahead -- but for now, here are some of my initial reactions.

    Read More

    Posted: October 11, 2016 |

    DB2 12 In-Memory Table Optimization

    Following up on last week's post on real memory and in-memory index optimization, here's a little more about the upcoming DB2 12. The new release will support in-memory tables that use in-memory contiguous buffer pools.

    Read More

    Posted: October 04, 2016 |

    DB2 12 In-Memory Index Optimization

    Last month I wrote about the trend of increasing the amount of real storage when configuring new mainframe systems. DB2 12 (which is set for delivery in the fourth quarter of 2016) features many new performance improvements that are designed to take advantage of available real storage. One of these enhancements is called In-Memory Index Optimization -- aka, index fast traversal blocks (FTBs).

    Read More

    Posted: September 27, 2016 |

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