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
  • BIND/DDL Thread Break-In

    DB2 10 for z/OS introduced high-performance database access threads (DBATs). Also known as DDF threads, DBATs are used to execute packages bound with option RELEASE(DEALLOCATE). For an excellent in-depth look at this topic, IBMer Robert Catterall examines some of the system parameters you should be aware of before implementing DBATs.

    Read More

    Posted: December 15, 2015 |

    Identifying Excessive DSNDB07 Sort Work Usage

    During a recent DB2 user group meeting, a question came up about identifying applications that consume excessive amounts of DB2 DSNDB07 sort work. As the presenter, IBM's Robert Catterall, noted, this capability is available in DB2 11 through some new system parameters.

    Read More

    Posted: December 08, 2015 |

    The Client Application Correlation Token

    The client application correlation token is another helpful tool delivered with DB2 11. But before getting into the details, let's briefly recount at the history of the correlation-id, or CORR-ID.

    Read More

    Posted: December 01, 2015 |

    The Dangers of Moving DB2 Data Off of z Systems

    In last week's post about the DB2 12 for z/OS ESP, I explained how customers can benefit by keeping data in DB2 for z/OS while the IBM DB2 Analytics Accelerator provides ETL support and analytic processing. David Beulke and Brian Smith and Bob Potter expound on this topic in two interesting posts.

    Read More

    Posted: November 24, 2015 |

    IBM Launching DB2 12 for z/OS ESP

    It was exciting to attend the recent IBM Insight 2015 conference -- especially now that I'm an IBM employee. Last month I was hired as a DB2 advisor for z/OS, and in that role, I'll help DB2 for z/OS customers plan their migrations and educate them on new DB2 features and other technical aspects of the IBM database.

    Read More

    Posted: November 17, 2015 |

    DB2 11 Enhanced DB2 Restart

    Last week I wrote about the new group buffer pool CASTOUT processing DB2 11 performs to improve overall memory constraints. Now I'll explain how castout processing relates to restarting DB2 and tell you about the new castout parameter used in the –START DB2 LIGHT() command.

    Read More

    Posted: November 10, 2015 |

    Group Buffer Pool-Related Enhancements in DB2 11

    Several enhancements in DB2 11 are designed to ease and eliminate storage constraints on group buffer pools and to reduce elapse time processing in applications.

    Read More

    Posted: November 03, 2015 |

    Big Data's Impact on Enterprise Security

    With the growing demand to integrate DB2 for z/OS data with Hadoop and other systems used to perform business analytics, I was wondering what information and solutions are available from IBM to govern, audit and protect sensitive data.

    Read More

    Posted: October 27, 2015 |

    How DB2 11 Manages Ever-Increasing Amounts of Data

    While many customers have upgraded to DB2 11, not all of them are taking full advantage of features like the DB2 Analytics Accelerator. While I've written extensively about the accelerator and other new capabilities that help customers manage high volumes of data, for an in-depth look at these topics, check out this recently released IBM Redbook.

    Read More

    Posted: October 20, 2015 |

    Previewing the IBM Insight Conference

    I'm looking forward to the IBM Insight 2015 in Las Vegas Oct. 25-29. One thing that intrigues me about this conference is its variety of keynote sessions covering data management, advanced analytics, cloud computing, content management and more.

    Read More

    Posted: October 13, 2015 |

    Displaying results 81-90 (of 499)
     |<  <  5 - 6 - 7 - 8 - 9 - 10 - 11 - 12 - 13 - 14  >  >|