BMC AMI SQL Explorer for Db2 13.1

This space contains information about the 13.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 Getting started with the product 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 Data for Db2 products BMC AMI Data for IMS products BMC AMI DevX products BMC AMI Ops products BMC AMI Security products BMC AMI Storage products BMC AMI Cloud 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

If you are logged in, you can create a PDF from any topic in the space. Use the following procedure to create a PDF of either the current topic or multiple pages (a parent topic and its child topics):

Go to the branch or topic for which you want to create a PDF.
On the toolbar in the upper-right of the window, clickand select Export to PDF:
Important
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.
In the Exporting PDF dialog box:
- In the Template box, select one of the following PDF styles:
  - 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.
  In this example, selecting This page and its children creates a PDF of all topics in the space's "Reference" section:
- 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)
Click Export.

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

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