Troy Coleman

Troy L Coleman




Bookmark and Share
RSS

Recent Posts

  • A Happy 10 Years
    07/18/2017
  • Db2: A Small but Significant Change
    07/11/2017
  • Subsystem Parameter Changes in DB2 12
    06/27/2017
  • New and Changed Subsystem Parameters in DB2 11
    06/20/2017
  • MERGE Statement Enhancements in DB2 12
    06/13/2017
  • How Customers are Benefiting from DB2 Accelerator Tables

    Following up on my recent posts on the latest version of IBM DB2 Analytics Accelerator for z/OS (DB2 Accelerator) as well as the new Accelerator cloud-centric solution, I wanted to step back a bit and discuss an IBM Redbook.

    Read More

    Posted: December 06, 2016 |

    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 |

    Displaying results 31-40 (of 499)
     |<  <  1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10  >  >|