Limited supportBMC 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.

Explain return codes

 The following table lists the return codes for the Explain function and provides information about the events that cause Explain to issue a particular return code.

 Return codes for the Explain function

Condition

Return code

Only informational messages are issued.

0

This return code is displayed when the following events occur:

  • At least one severe or warning message is issued.
  • The ADMIN_EXPLAIN_MAINT Db2 stored procedure discovers that one or more explain tables are not of the UNICODE format.

4

This return code is displayed when the ADMIN_EXPLAIN_MAINT Db2 stored procedure discovers the following about one or more of the existing explain tables:

  • The tables are of a format that cannot be altered.
  • The tables are of an unknown format.

8

A connection error, unexpected SQL errors, or memory errors occur.

12

Related topics

Customizing-expert-rules

SQL Explorer Return codes






 

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