Efficient buffer pool tuning improves performance and saves on expensive mainframe resources. However, buffer pool tuning usually proves challenging. In many cases, it is so daunting and labor intensive that it tends to be done only when 'needed'. This lack of monitoring leads to I/O problems, avoidable CPU consumption, inefficient storage usage, and premature CPU upgrades and memory expansion. BPA4DB2 offers a better and cost effective alternative. Designed to be easy to use, it offers expert system problem detection, problem resolution guidance and automated audit with pro-active notification for impending problems.

Automatic Problem Detection

“Are there problems with the bufferpools or is the current bufferpool setup already optimal?” In other words, is there tuning potential or not? How much improvement can be expected? BPA4DB2 has been designed to provide precise metrics: ReRead Percentage is a unique indicator of good or bad buffer pool behavior. Distinct GetPage describes the memory capacity requirements.

Problem Resolution Guidance

BPA4DB2 describes all feasible solutions to a problem in plain English phrases: enlarge or decrease, change this threshold to, Re-assign these objects from BP0x to BP0y.

Automated Audit

BPA4DB2 sends emails when IO performance decreases.

Business information

Show all   |   Hide all

  • Functional details

    • Automated problem detection
    • Clear identification of tuning opportunities
    • Recommends tuning measures
    • Offers simulation for buffer pool sizes and thresholds
    • Host examination and email alerts
    • Graphical workstation with expert analysis
    • Visual presentation of metrics analysis
    • 'Alter' statement generation
    • User guidance and education
    • Automated auditing of any number of DB2 subsystems at a time
    • Detects waste of memory and CPU time
    • Monitors IO performance
    • Makes Bufferpool tuning easy
    • Supports local pools and group buffer pools
    • Determines optimal thresholds

  • Business problem

    Tuned buffer pools are the basis of any system tuning, appropriate adapted pools help to avoid service interruptions and resource bottlenecks. The goal of buffer pool tuning is to enable DB2 to make the best possible use of the available memory. Properly adjusted buffer pools save valuable resources as memory, DASD IO, and CPU time, hence money.

  • Business opportunity

    BPA4DB2 clearly indicates tuning potential and bufferpool related problems. It describes the problem and its causes. Whether the issue resides with group bufferpools, local bufferpools or a particular object, BPA4DB2 provides the information required to resolve the situation. BPA4DB2 uncovers and describes all feasible solutions to a problem or tuning issue, it does so in plain English phrases: enlarge or decrease the pool size of Bpxx to .. , change this threshold to .., re-assign (shift) these objects from BP0x to BP0y.

    Valuable DBA time can now be spent on analysis and 'what if' reasoning instead of plowing through volumes of raw data. BPA4DB2 generates ALTER statements, offers re-design strategies for the pools and suggests object grouping enhancements. BPA4DB2 justifies the suggested tuning measures and provides information rich colored charts to facilitate a visual analysis. It offers a wealth of bufferpool related details, ReReads, Distinct GetPages, DASD-IO, Average-IO, etc. Its greatest value lies in providing detailed guidance for problem resolution and tuning.

  • Return on investment

    BPA4DB2 is designed to make bufferpool monitoring and bufferpool tuning simple. It helps to turn an occasional project into an efficient ongoing task. A task that helps to save money and to avoid problems.

    Measurements are scheduled once a day or every x hours. The host based routines analyze each measurement file and check for preset quality criteria. An alert is sent as soon quality thresholds are exceeded.

    Database administration is freed from  tedious observation of I/O performance and related issues. The return on investment is constituted of savings in CPU time and memory as well as in savings in expenditure of human labor (DBA).


  • Competitive advantage

    Simple Problem Detection: The first question is always, is there a problem with the bufferpools or not, is the current bufferpool setup optimal or should it be improved, in other words, is there tuning potential? A clear indication for GOOD or BAD (improvable) is needed. BPA4DB2 clarifies this.

    Clear Briefings for Problem Solution: Although BPA4DB2 offers the finest granularity of bufferpool related details its unique strength is its ability to give clear briefings for problem solution and tuning.

    Automatic Surveillance: Whenever BPA4DB2 determines that the measured DB2 system doesn't adhere to defined quality criteria the database administrators are notified by email with the measurement results attached.

  • Industries

    Cross Industry

  • Solution areas

    Cross industry
       System and data management

  • Customer size

    Midmarket Business (100 to 499 employees)
    Midmarket Business (500 to 1000 employees)
    Large Business (greater than 1000 employees)

  • Languages supported


  • Countries/regions available for distribution

  • Solution collateral

    Name Date Categories
    Nov 11, 2020 News/Marketing

Technical information

Show all   |   Hide all

  • Hardware/OS platforms

    z/OS 1.9
       IBM Systems: z Systems
    z/OS 1.10
       IBM Systems: z Systems
    z/OS 1.11
       IBM Systems: z Systems
    z/OS 1.12
       IBM Systems: z Systems
    z/OS 1.13
       IBM Systems: z Systems
    z/OS 2.1
       IBM Systems: z Systems
    z/OS 2.2
       IBM Systems: z Systems

  • Services

    Application Enabling Services
    Business Recovery Services

Date last modified:    Jul 12, 2021


Contact information

Timo Schneider, Susanne Tursman
(49) 6641 6551 0


UBS Hainer Unternehmensberatung & Software Service GmbH
Am Zickmantel 16
Lauterbach 36341

+49 6641 65510

Contact PartnerWorld

Live Chat is currently unavailable

The live chat service is normally available weekdays 8am-8pm Eastern Time. Use the 'Contact us' link or one of the other links for help now.