Pool Advisor for DB2 12.1

This space contains information about the 12.1.00 release of the BMC System Performance for DB2 solution and its products.

The combined features and functionality of the solution help you tune your DB2 system dynamically and automatically as workloads change.

The solution comes with a comprehensive set of reports that lets you monitor all aspects of DB2 from one central report. You can quickly hyperlink to other reports if an anomalous value is highlighted. The report set combines the reporting abilities of the MainView for DB2 and Pool Advisor for DB2 components with a supplemental set of comprehensive reports on all aspects of DB2.

updated 11 Jun

What's new
This section describes the changes or new features in this release.

In this section:

BMC System Performance for DB2 User Guide


 An overview of the solution and how to use the solution

Pool Advisor for DB2 User Guide


A description of the product and instructions how to use it

MainView for DB2 documentation


Documentation for using and customizing the MainView for DB2 product and for using the MainView Performance Reporter

OPERTUNE for DB2 Reference Manual


A description of the product's features and functions



A description of how to use CATALOG MANAGER for interactive access to catalog information and application data 

Common infrastructure documentation


Information about managing and deploying global infrastructure components that certain mainframe BMC products use

System and SQL Performance for DB2 Administration


A description of the products' administrative functions



Information about installing and maintaining the product



Customization tasks that you need to perform after you install and configure BMC products and solutions for DB2



BMC messages from the following product lines:

  • BMC products for DB2
  • BMC products for IMS
  • Cost Optimization products
  • MainView products

PDFs and videos

This topic provides access to PDFs and videos that support this product. It also explains how to create your own custom PDFs.

Creating a custom PDF

From any page in the space, use the following procedure to create a PDF of either the current page or multiple pages (a parent topic and its child topics):
  1. From the Tools menu in the upper-right, select Export to PDF:


    Although you can export to Microsoft Word, this portal is not optimized for Word exports.

    If you require an export in XML or HTML format, contact us.

  2. In the Template box, select the PDF style:

    • Simple to export a PDF with no cover, table of contents, or index 
      By default, the Simple template exports only the current page.
    • Standard to export a traditional PDF with a cover, table of contents, and index 
      By default, the Standard template exports the current page and its child pages.
  3. In the Export Scope box, select what you want to export:

    • Only this page to export the current page
    • This page and its children to export an entire section (current page and any child topics)


    In this example, selecting This page and its children creates a PDF of all topics in the space's Reference section:

  4. Select Start Export.

For more information, see Help for BMC Online Technical Documentation .


This section lists videos that supplement the text-based documentation.

This library offers Quick Courses related to Performance for DB2 SQL and Performance products:


FAQs and additional resources

This topic answers common questions and explains how to access additional resources, including BMC Support.

Frequently asked questions

This section answers frequently asked questions (FAQs) about the documentation portal.


 How can I get a PDF of selected content in a space?
  1. From the Tools menu in the upper-right, select Export to PDF.

  2. Select the type of PDF that you want:
    • Only this page for a PDF of the current page
    • This page and its children for a PDF of the current page and all of its child topics

Depending on the number of topics included in the export, it might take several minutes to create the PDF. After the export is complete, you can download the PDF.

 Where can I get a list of all mainframe Cost Optimization products, MainView products, and BMC products for the IBM DB2 and IBM IMS subsystems?

Go to the main dashboard and click the BMC Mainframe products (DB2 IMS MainView Cost Optimization) box, or click here to go directly to the list.


If looking for the Control-M mainframe documentation, click the Control-M box on the dashboard, or click here to go directly to the Control-M space.

Additional resources

The following BMC sites are external to this portal and provide information that you might find helpful:

Support information

This topic contains information about contacting BMC Support and determining support status for specific product versions.

 How can I contact BMC Support?

If you have problems with or questions about a BMC product, or for the latest support policies, see the Customer Support website at You can access product documents, search the Knowledge Base for help with an issue, and download products and maintenance.

If you do not have access to the web and you are in the United States or Canada, contact Customer Support at 800 537 1813. Outside the United States or Canada, select your country at Contact BMC to view local Support Contacts.

 How can I check a product version's support status?

You can find the support status for specific product versions on Support Central. Selecting a product from the “A–Z Supported Product List” shows:

  • All versions of the product and their current support levels (full or limited)
  • Dates on which support ends

You can also find information about the latest support policies on Support Central.

Related topics

Was this page helpful? Yes No Submitting... Thank you


  1. Gerald Moritz

    Hi, the link for the Pool Advisor PDF does not work !

    Oct 12, 2018 12:46
  2. Aparna Saxena

    Hello Gerald,

    We've updated the PDF link now.



    Oct 15, 2018 07:40
    1. Gerald Moritz

      PDF now downloaded ! Thank you ! Regards, Gerald

      Oct 16, 2018 01:33
  3. Gerald Moritz

    Wanted to download "Pool Advisor for DB2 12.1, PTF BQU1659 applied" as Ready-made space PDFs. Got an Error "Page not found".

    Jul 12, 2019 01:02
    1. Dov Kaiser

      Hi, Gerald. Thanks for contacting us!

      You can access the PDF as follows:

      1. In the Downloading PDFs box (near the top of the "PDFs and videos" page, click Restricted space PDFs.
      2. On the launched page, click the link for the space PDF.

      We hope this helps!

      Jul 14, 2019 01:52