SQL Explorer features

You can prevent or resolve common SQL-related performance problems by using BMC AMI SQL Explorer for Db2.

This section contains the following topics:

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

Understanding-online-versus-batch-processing

Important

With

Some content is unavailable due to permissions.

, you can analyze objects on local or remote Db2 subsystems through the Call Attach Facility (CAF) or through the Db2 Distributed Data Facility (DDF).

Also, many of the reports that

Some content is unavailable due to permissions.

produces are available either online or in batch mode.

For more information, view the Quick Course SQL Explorer for DB2—Getting Started.

SQL Explorer features

On this page