BMC AMI SQL Explorer for Db2 12.1

This space contains information about the 12.1.00 release of the BMC AMI SQL Explorer for Db2 (formerly known as the SQL Explorer for DB2) product.

The BMC AMI SQL Explorer for Db2 (SQL Explorer) product lets you prevent or resolve common SQL-related performance problems. Use SQL Explorer to:

Explain SQL statements
Compare SQL statements
Analyze mismatched data types
Analyze the impacts of schema changes
Compare timestamp matches before production
Migrate access path statistics to another subsystem
Generate automatic DECLARE TABLE statements

Notices Updated 12 Feb 2018

You must log in or register to view this page

Getting started See more Administering Security and system administration See more Working with infrastructure Management of shared components See more Command and syntax reference Descriptions of commands and syntax, and related reference information 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 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
		Using Working with the product See more Integrating Integrations with other product See more

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

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 BMC AMI SQL Explorer for Db2 product:

Title	Duration
Using SQL Explorer	8:10
Using DCLGEN	6:33
Using Impact Analysis	8:14
Using Mismatch Analysis	9:45

Important

See also 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