Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI SQL Explorer for Db2 13.1.

Analyze mismatched data types

Using the Mismatch Analysis option, 

SQL Explorer

 analyzes a plan or package, comparing the data type and length of host variables or expressions to the Db2 catalog and reporting any differences. You can use this feature to identify the effects of anticipated column changes.

For example, the Db2 optimizer can change access paths based solely on the data-type differences between the column and the host variable or expression. However, the Db2 optimizer does not provide any warning that a data-type mismatch occurred. The Mismatch Analysis option detects data-type mismatches and reports whether they could result in changes in the access path.

Related topics

Performing-mismatch-analysis

SQL-Explorer-features



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI SQL Explorer for Db2 12.1