SQL Performance for DB2 12.1

This space contains information about the 12.1.00 release of the SQL Performance for DB2 solution.

The SQL Performance for DB2 (SQL Performance) solution enables DBAs, application developers, and system programmers to identify and correct performance problems in Db2 applications that run in IBM CICS, IMS, and other z/OS environments. This solution is the answer to the ongoing quest for optimal application efficiency. SQL Performance for DB2 provides a unique set of tools that allow an application to be fine-tuned through its conception and growth, to its retirement.

Notices Updated 12 Feb 2018

You must log in or register to view this page

The following illustration shows the documentation available for the SQL Performance for DB2. You can access a documentation space by clicking the corresponding box, or use the product-specific search boxes to locate specific topics.

SQL Performance for DB2 12.1.00

Common documentation

Getting started See more		Planning Deployment planning and system requirements See more Installing Installation, configuration, and maintenance See more Customizing after installation Post-installation product customization See more
Getting started See more		Using Working with the product See more
Command and syntax reference Descriptions of commands and syntax, and related reference information See more	Administering Security and system administration See more	Working with infrastructure Management of shared components See more

Messages

BMC messages from the following product lines:

BMC AMI Cost products
BMC AMI Data for Db2 products
BMC AMI Data for IMS products
BMC AMI Ops products
BMC AMI Security products

Integrating

Integrations with other product

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.

You must log in or register to view this page

Legacy PDFs related to this space

The following legacy PDFs provide older product documentation that is not otherwise available in this documentation portal:

Document	Title	Date
88725.pdf	BMC Performance Manager for WebSphere MQ Message Management Command Line Interface Reference Manual	February 29, 2008

Creating a custom PDF

Important

We are working to improve the PDF export experience. We are currently working on the following issues:

Page order—If you export more than one page to PDF, they might be displayed in alphabetical order instead of the order in the interface.
Interface update—The export interface options are changing, so these instructions might not match them exactly.
Known limitations—PDF exports are not always completed successfully.
Thank you for your patience.

If you are not logged in, click the head icon at the top-right of the window, select Log in, and follow the instructions:
Navigate to the page that you want to export to PDF. To create a PDF of the whole space, navigate to the space home page.
Next to the page title, click Export .
In the Export dialog box, click PDF:
In the Export as PDF dialog box, perform one of these steps:
- To create a PDF of that page only, proceed to step 6.
- To create a PDF of that page and its child pages, click select all.
- To create a PDF of that page and a selection of its child pages, select the checkboxes next to the pages that you want to include your PDF.
Click Export.
In the PDF Export Options dialog box, select the checkboxes for the features that you want to include in your PDF.
Tip
If you are creating a PDF of a single page, clear the Table of Contents checkbox.
Click Export.
The PDF is created.
Save the PDF locally.

Videos

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

This library offers Quick Courses related to SQL Performance:

SQL Performance	Duration
Using SQL Performance	10:18
Using the Explain interface	8:08
Using Exception Advisor	6:29
Using Workload Index Advisor	9:02
Using Recommindex	6:37
Using Workload Compare Advisor	9:19
Implementing Reorg Advisor	11:43
Creating and using application profiles	9:35
Migrating access path statistics	6:55
Seeing which programs and packages update DB2 objects	4:35
Seeing which tables a program accessed	4:47
Understanding the Performance Advisor Database	9:28

Important

See also APPTUNE, SQL Explorer, 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.

The following are general questions about mainframe documentation:

How can I get a PDF of selected content in a space?
Click here to expand...
Important
We are working to improve the PDF export experience. We are currently working on the following issues:
Page order—If you export more than one page to PDF, they might be displayed in alphabetical order instead of the order in the interface.
Interface update—The export interface options are changing, so these instructions might not match them exactly.
Known limitations—PDF exports are not always completed successfully.
Thank you for your patience.
1. If you are not logged in, click the head icon at the top-right of the window, select Log in, and follow the instructions:
2. Navigate to the page that you want to export to PDF. To create a PDF of the whole space, navigate to the space home page.
3. Next to the page title, click Export .
4. In the Export dialog box, click PDF:
5. In the Export as PDF dialog box, perform one of these steps:
  To create a PDF of that page only, proceed to step 6.
  To create a PDF of that page and its child pages, click select all.
  To create a PDF of that page and a selection of its child pages, select the checkboxes next to the pages that you want to include your PDF.
6. Click Export.
7. In the PDF Export Options dialog box, select the checkboxes for the features that you want to include in your PDF.
  Tip
  If you are creating a PDF of a single page, clear the Table of Contents checkbox.
8. Click Export.
  The PDF is created.
9. Save the PDF locally.
Where can I get documentation for all BMC mainframe products?

Click here to expand...

Go to the docs.bmc.com main dashboard and click the name of a specific product area, or click here to go directly to the list of all products.
Important
If you're 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

The following questions offer information about BMC Support:

How can I contact BMC Support?

Click here to expand...

If you have problems with or questions about a BMC product, or for the latest support policies, go to Support Central. You can search the Knowledge Base for help with an issue or download products and maintenance.
If you do not have access to the web and you are in the United States or Canada, contact BMC 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?
Click here to expand...
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.
Where can I get the security certificates required to transfer files to BMC Support?

Click here to expand...

BMC Support requires a security certificate when you are using the File Transfer Protocol Secure (FTPS) method to send files to BMC Support. TheSecure File Transfer User Guide for BMC Customers explains how to use the certificate.
The following table includes the security certificate:
Certificate
Validity
Digicert Global Root G2.txt
Effective from April 6, 2021, until further notice