• John Campbell

  • S204 - Hard Lessons Learned using High Performance DBATs

    Session Evaluation

    Distributed applications, both read and update, accessing Db2 is by the fast growing area of new business application transaction processing.
    High Performance DBATs (HP-DBATs) is a significant and valuable performance feature for distributed applications introduced in Db2 10.
    Use of this feature can also be dangerous if not implemented in an intelligent way.
    The main objective of this session is to help users implement HP-DBATs in a safe controlled way and to maximise the performance benefit.
    This session will cover the following topics:
    Overview of preexisting support for thread pooling and inactive connection support; What are HP-DBATs and operational characteristics
    Where are the performance benefits coming from
    Which application workloads are best suited to HP-DBATs and how to identify them
    What are the risks
    How to get into a safe starting position
    WLM considerations and setup
    War stories based on real world customer experiences